Networks, Data and Information

Module description

The vast majority of IT systems within business are involved with the collection, processing and movement of data.   Data relating to transactions, customer behaviour and business activities must be stored and processed to deliver useful business information.  This module will provide you with the skills required to create and manage efficient networks and databases and to write intelligent queries to deliver useful business information from the collected data.

Full module specification

Module title:Networks, Data and Information
Module code:ECMM420
Module level:M
Academic year:2014/5
Module lecturers:
  • Dr David Wakeling - Convenor
Module credit:15
ECTS value:

7.5

Pre-requisites:
Co-requisites:
Duration of module: Duration (weeks) - term 1:

0

Duration (weeks) - term 2:

11

Duration (weeks) - term 3:

0

Module aims

The aim of the module is to cover theoretical and technical issues underlying current and future information systems including network structures, databases and three-level architectures.

ILO: Module-specific skills

  • 1. distinguish between and give examples of the different types of information systems;
  • 2. distinguish between the different types of networks and their applications;
  • 3. produce a database design and demonstrate how it can be managed;
  • 4. use SQL to query the database;
  • 5. develop and implement a three-level architecture with the use of PHP.

ILO: Discipline-specific skills

  • 6. express designs at different levels of abstraction and mapping between them;
  • 7. design a three-level architecture.

ILO: Personal and key skills

  • 8. use on-line resources to develop advanced computer language skills;
  • 9. communicate technical information using a written report.

Learning activities and teaching methods (given in hours of study time)

Scheduled Learning and Teaching ActivitiesGuided independent studyPlacement / study abroad
301200

Details of learning activities and teaching methods

CategoryHours of study timeDescription
Scheduled learning and teaching activities20Lectures
Scheduled learning and teaching activities8Workshops (SQL)
Scheduled learning and teaching activities2Surgeries (one for each assignment)
Guided independent study80Individual assessed work
Guided independent study40Private study

Formative assessment

Form of assessmentSize of the assessment (eg length / duration)ILOs assessedFeedback method
Workshop problem sheet1 hour each workshopAllOral

Summative assessment (% of credit)

CourseworkWritten examsPractical exams
10000

Details of summative assessment

Form of assessment% of creditSize of the assessment (eg length / duration)ILOs assessedFeedback method
Database design document30253,5Individual marksheet
Database implementation assignment30253,5,7Individual marksheet
Linking the database assignment40301,2,4,6,7,Individual marksheet

Details of re-assessment (where required by referral or deferral)

Original form of assessmentForm of re-assessmentILOs re-assessedTimescale for re-assessment
As aboveCourseworkAllTimescale to be determined by examiners board – September or December referrals possible

Re-assessment notes

Since this is assessed entirely by coursework, all referred assessments will be by the assignment of a new piece of coursework.

Deferred assignments will be done by the original piece of coursework combining elements of the module.

Syllabus plan

- computer network, types, topographies and applications;
- data security within a network;
- types of database;
- information modelling: database design and management, and mapping to SQL;
- three-level architecture.

Indicative learning resources - Basic reading

Web based and Electronic Resources:

ELE: http://vle.exeter.ac.uk

Other Resources:

Module notes given by lecturer(s).

  1. Fundamentals of Database Systems,Elmasri and Navathe,5th,Addison-Wesley,2007,001.6442 ELM,032141506X
  2. Database Systems: A Practical Approach to Design, Implementation and Management,Connolly, Thomas and Begg, Carolyn,4th,Addison Wesley,2004,001.6442 CON,0321210255
  3. Database Management Systems,Ramakrishnan and Gehrke,5th,McGraw-Hill,2007,001.6442 RAM,007-1151109 (Int)

Module has an active ELE page?

Yes

Origin date

19/11/12

Last revision date

19/11/12