BUS9003

Database development and management ( 6 points, SCA Band 2, 0.125 EFTSL)

Leader: Peter Lawrence

Offered:
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

Prohibitions: BUS9520, BUS9530, BUS5071, BUS4112, IMS9003, CSE9002, GCO9804, CSE4430