This module introduces students to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration.
Describe and advise upon the importance of data independence, and comment upon the level of data independence offered by a particular DBMS.
Identify the important characteristics of the relational model for the purposes of developing relational databases
Determine whether a given relational database is well designed (ie. meets BCNF criteria) and transform a schema into BCNF
Create and query a relational database using command level SQL
Describe and advise upon the important aspects of a database implementation, operation and maintenance (including storage structures, recovery, concurrency and security mechanisms).
Compare and contrast the hierarchical, network, relational and object-oriented models
Use data modelling techniques for the design of databases
Design and build a small database system with a web interface
Show awareness and knowledge of other types of database interfaces
Practical work (labs): 18 hours
Tutorials/workshops: 5 hours
Independent study/coursework: 103
This document is the definitive current source of information about this module and supersedes any other information.