Entity models, relational design, mapping designs to implementations, normalisation and de-normalisation.
Database languages i.e. SQL: DML, DDL and DCL, JOIN and PL/SQL
Developing applications with appropriate database portal tools
Database system architecture - relational, network, hierarchical, object orientated.
Database reliability, integrity and concurrency control.

A coursework portfolio weighted at 100% comprising of several database related design and build based tasks assessing all learning outcomes (1 to 4).

As this is a heavily practical discipline, the content will be delivered over 40 hours of lectures and practical sessions. This will support the underlying knowledge and skills required to complete the module, and will be facilitated with booklets, course texts, and the Internet. Group discussions will also take place in these sessions.

ORACLE Relational Database Management System
The Library
Computing Lab
Web Browser

Available to EFREI students only

Rolland. F, (1998), The Essence of Databases, Prentice Hall, ISBN: 0137278276
Date. C, (2004), Database Systems, 8th Edition Vol 1, Addison-Wesley, ISBN: 0321189566
Connolly. T, and Begg. C, (2009) Database Systems: A Practical Approach to Design, Implementation and Management, Addison Wesley, 5th Edition, ISBN-10: 0321523067

1) ANALYSE SITUATIONS AND/OR ENVIRONMENTS FOR THE APPLICATION OF A DATABASE SOLUTION. Analysis
Problem Solving

2) CREATE, ALTER AND REMOVE RELATIONAL TABLES, INDEXES AND DATA USING AN APPROPRIATE DATABASE LANGUAGE.
Problem Solving

3) DEFINE THE CENTRAL CONCEPTS OF DATABASES, INCLUDING CONSTRAINTS IN THE DESIGN OF A DATABASE DUE TO ISSUES OF CONCURRENCY AND INTEGRITY.
Knowledge and Understanding

4) DESIGN AND JUSTIFY THE DESIGN OF A DATABASE SYSTEM AND SELECT, JUSTIFY THE SELECTION AND EXPLOIT ANY ASSOCIATED UNDERPINNING TECHNOLOGIES.
Communication
Knowledge and Understanding
Problem Solving