BUS9003

Database development and management (6 points)

(IT)

Leader: Peter Lawrence

Offered:
Caulfield First semester 2003 (Evening)
Caulfield Second semester 2003 (Evening)
Caulfield First semester 2004 (Evening)
Caulfield Second semester 2004 (Evening)

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