2012/13 | Engineering, Mathematics and Physical Sciences Intranet

MODULE TITLE	Information Systems	CREDIT VALUE	15
MODULE CODE	ECM2407	MODULE CONVENER	Unknown

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

Number of Students Taking Module (anticipated)	30

DESCRIPTION - summary of the module content

You will cover theoretical and technical issues underlying current and future database management systems, and introduce you to one current system. You will be introduced to methods for the development of information systems and forms-based applications.

AIMS - intentions of the module

The aim of this module is to equip you with the underlying theory and knowledge that underpins modern-day database systems. You will be introduced to the main principles underpinning modern database systems, and apply these principles to providing database solutions to typical commercial information systems. You will demonstrate what you have learnt by developing a database solution to a specified real-life commercial problem, and implementing this using a current database management system.

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

Module Specific Skills and Knowledge:
1 demonstrate an understanding of the ACID properties of database systems;
2 develop and interpret database schemas and queries expressed in SQL-92;
3 develop conceptual designs and transform them into SQL-92 schemas;
4 demonstrate an understanding of relational theory and its use in database design;
5 demonstrate an understanding of the transaction concept and its use in integrity and recovery;
6 demonstrate an understanding of dynamic modelling.
Discipline Specific Skills and Knowledge:
7 express designs at different levels of abstraction and map between them;
8 design with a data-centric view;
9 develop appropriate data for testing a set-oriented model;
10 express queries in a declarative language.
Personal and Key Transferable/ Employment Skills and Knowledge:
11 use on-line resources to develop advanced computer language skills.

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

The relational model and its expression in SQL-92; Information modelling and mapping to SQL; Database design theory; Transactions and their use in integrity and recovery management; Physical database implementation; Dynamic modelling and user interaction via forms.

LEARNING AND TEACHING

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

Scheduled Learning & Teaching Activities	48.00	Guided Independent Study	102.00	Placement / Study Abroad	0.00

DETAILS OF LEARNING ACTIVITIES AND TEACHING METHODS

Category	Hours of study time	Description
Scheduled Learning & Teaching activities	18	Lectures
Scheduled Learning & Teaching activities	8	Workshops
Scheduled Learning & Teaching activities	2	Surgeries
Scheduled Learning & Teaching activities	20	Individual assessed work
Guided independent study	102	Lecture & assessment preparation; wider reading

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

SUMMATIVE ASSESSMENT (% of credit)

Coursework	25	Written Exams	75	Practical Exams

DETAILS OF SUMMATIVE ASSESSMENT

Form of Assessment	% of Credit	Size of Assessment (e.g. duration/length)	ILOs Assessed	Feedback Method
Written exam – closed book	75	2 hours	1, 2, 3, 4, 5, 6, 7, 8, 10	Exam mark
Coursework – individual practical assignments	25	20 hours	2, 3, 6, 7, 9, 10, 11	Written

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
All above	Written exam (100%)	All	Last week August

RE-ASSESSMENT NOTES

If a module is normally assessed entirely by coursework, all referred/deferred assessments will normally be by assignment.
If a module is normally assessed by examination or examination plus coursework, referred and deferred assessment will normally be by examination. For referrals, only the examination will count, a mark of 40% being awarded if the examination is passed. For deferrals, candidates will be awarded the higher of the deferred examination mark or the deferred examination mark combined with the original coursework mark.

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

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

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	Howe, David	Data Analysis for Database Design	3rd	Butterworth-Heinemann	2001	978-0750650861	[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]
Set	Silberschatz, A, Korth, H F, and Sudarshan, S	Database System Concepts	6th	McGraw-Hill	2013	9332901384	[Library]

CREDIT VALUE	15	ECTS VALUE	7.5

PRE-REQUISITE MODULES	None
CO-REQUISITE MODULES	None

NQF LEVEL (FHEQ)	2 (NQF level 5)	AVAILABLE AS DISTANCE LEARNING	No
ORIGIN DATE	Monday 12 March 2012	LAST REVISION DATE	Wednesday 17 October 2012

KEY WORDS SEARCH	None Defined

Computer Science

ECM2407 - Information Systems (2012)