MMS2801

Database management systems (6 points)

(IT)

Leader: Lindsay Smith

Offered:
Berwick First semester 2004 (Day)

Synopsis: This unit is designed to provide students with an understanding of the principles and terminology of database management systems and database design so that they are able to design, implement and manage efficient database systems. The unit will for comparison purposes look at several different DBMS models including relational and object oriented and the underlying structures used to support these models. SQL will be introduced and used for access control, data definition, manipulation and query output generation. This interactive SQL will be extended to programming database applications via server side stored code. The special issues of lock management and recovery/backup in the multi-user environment of a DBMS will also be examined. The concepts and issues related to distributed database design will be presented.

Assessment: Three assignments (40%) two individual database design assignments (20%) one group database system implementationproject (20%). Three hour written examination (60%)

Contact Hours: 4 Hours per week (one 2 hour lecture and one 2 hour tutorial/laboratory session ).

Prerequisites: MMS1801 or MMS1802

Corequisites: Nil

Prohibitions: BUS3112, CPE2005, CSE2132, CSE2138, GCO2815