Leader: Peter Lawrence
Not offered in 2005.
Synopsis: Storing and indexing data and its influence on reporting; turning a business description into a formal conceptual data model; ER Diagrams; Generalisation Hierarchies; Data Normalisation; DBMS implementation models including flat file, hierarchical, Simple and Complex Networks, Relational and OO Models; the DDL, DML and DCL; Queries; Constraints and Data Integrity; Database Administration; Transaction Management; Deadlock Management; Introduction to Data Warehousing and Data Mining.
Assessment: Examination (2 hours): 40% + Six assignments: 60% + If exam mark is 50% or more and performance in all assignments is satisfactory, the unit mark will be determined from 60% of assignment marks and 40% of the exam mark. Otherwise, the exam mark will be returned.
Contact Hours: 3 contact hours per week, comprising of six sets of briefing, workshop and review sessions held fortnightly, of duration 2, 2.5 and 2 hours respectively
Prerequisites: Entry to the Master of Business Technology or equivalent Masters program