2015/16 | Engineering, Mathematics and Physical Sciences Intranet

MODULE TITLE	Networks, Data and Information	CREDIT VALUE	15
MODULE CODE	ECMM420	MODULE CONVENER	Prof Geyong Min (Coordinator)

DURATION: TERM	1	2	3
DURATION: WEEKS	0	12 weeks	0

Number of Students Taking Module (anticipated)	11

DESCRIPTION - summary of the module content

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.

AIMS - intentions of the module

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.

INTENDED LEARNING OUTCOMES (ILOs) (see assessment section below for how ILOs will be assessed)

On successful completion of this module, you should be able to:

Module Specific Skills and Knowledge:
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.
Discipline Specific Skills and Knowledge:
6.express designs at different levels of abstraction and mapping between them;
7. design a three-level architecture.
Personal and Key Transferable / Employment Skills and Knowledge:
8.use on-line resources to develop advanced computer language skills;
9. communicate technical information using a written report.

SYLLABUS PLAN - summary of the structure and academic content of the module

- 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.

LEARNING AND TEACHING

LEARNING ACTIVITIES AND TEACHING METHODS (given in hours of study time)

Scheduled Learning & Teaching Activities	30.00	Guided Independent Study	120.00	Placement / Study Abroad	0.00

DETAILS OF LEARNING ACTIVITIES AND TEACHING METHODS

Category	Hours of study time	Description
Scheduled learning and teaching activities	20 Hours	Lectures
Scheduled learning and teaching activities	8 Hours	Workshops (SQL)
Scheduled learning and teaching activities	2 hours	Surgeries (one for each assignment)
Guided independent study	80 hours	Individual assessed work
Guided independent study	40 hours	Private study

ASSESSMENT

FORMATIVE ASSESSMENT - for feedback and development purposes; does not count towards module grade

Form of Assessment	Size of Assessment (e.g. duration/length)	ILOs Assessed	Feedback Method
Workshop problem sheet	1 hour each workshop	All	Oral

SUMMATIVE ASSESSMENT (% of credit)

Coursework	100	Written Exams	0	Practical Exams	0

DETAILS OF SUMMATIVE ASSESSMENT

Form of Assessment	% of Credit	Size of Assessment (e.g. duration/length)	ILOs Assessed	Feedback Method
Database design document	30%	25 hours	3,5	Individual marksheet
Database implementation assignment	30%	25 hours	3,5,7	Individual marksheet
Linking the database assignment	40%	30 hours	1,2,4,6,7,	Indivdiual marksheet

DETAILS OF RE-ASSESSMENT (where required by referral or deferral)

Original Form of Assessment	Form of Re-assessment	ILOs Re-assessed	Time Scale for Re-reassessment
As above	Coursework	All	Timescale 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.

RESOURCES

INDICATIVE LEARNING RESOURCES - The following list is offered as an indication of the type & level of
information that you are expected to consult. Further guidance will be provided by the Module Convener

Basic reading:

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

Other Resources:

Module notes given by lecturer(s).

Reading list for this module:

Type	Author	Title	Edition	Publisher	Year	ISBN	Search
Set	Elmasri and Navathe	Fundamentals of Database Systems	5th	Addison-Wesley	2011	032141506X	[Library]
Set	Connolly, Thomas and Begg, Carolyn	Database Systems: A Practical Approach to Design, Implementation and Management	6th	Pearson	2015	1292061189	[Library]
Set	Ramakrishnan and Gehrke	Database Management Systems	5th	McGraw-Hill	2007	007-1151109 (Int)	[Library]

CREDIT VALUE	15	ECTS VALUE	7.5

PRE-REQUISITE MODULES	None
CO-REQUISITE MODULES	None

NQF LEVEL (FHEQ)	7	AVAILABLE AS DISTANCE LEARNING	No
ORIGIN DATE	Friday 09 January 2015	LAST REVISION DATE	Friday 09 January 2015

KEY WORDS SEARCH	Database; SQL; PHP; networks.

Computer Science

ECMM420 - Networks, Data and Information (2015)