Last modified: 22 May 2019 17:07
This course will be of interest to anyone who wishes to learn to design and query databases. The course aims to teach the material using case studies from real-world applications. You will develop a critical understanding of the principal theories, principles and concepts, such as modelling techniques used in the design, administration and security of database systems. You will also learn core theoretical concepts such as relational algebra, file organisation and indexing. At the end of this course you will be able to design and build Web and cloud-based databases and have a critical understanding of how database-driven applications operate.
|Session||First Sub Session||Credit Points||15 credits (7.5 ECTS credits)|
The concepts of a database and database management. Database development. Illustrations. Entity-Relationship model. Database design: logical design and the relational model. Normalisation; different normal forms. Physical design; file organisation and access; indexing. Database administration. Query by Example and SQL. Query optimisation. Practical examples using MS Access.
Client-server model. Database servers. Database access from client applications. Web-based database access through server-side scripting. Practical examples using MS Access, My SQL, Php and JDBC.
A brief overview of key concepts in distributed, object -oriented, multimedia, spatial and geo-referenced database systems.
Information on contact teaching time is available from the course guide.
Group design project (25%); Individual design project (25%); Group report (25%); individual report (25%).
Resit: where a student fails the course overall they will be afforded the opportunity to resit those parts of the course that they failed (pass marks will be carried forward).
During lectures, student interaction will be used for formative assessment. Additionally, practical sessions will provide students with practice opportunities and formative assessment.
Formative feedback for in-course assessments will be provided in written form. Additionally, formative feedback on performance will be provided informally during practical sessions.