Monash home | About Monash | Faculties | Campuses | Contact Monash |
Staff directory | A-Z index | Site map |
(IT)
|
Leader: C Clemence
Offered:
Peninsula First semester 2006 (Day)
Peninsula SA-02 2006 (Day)
Peninsula Second semester 2006 (Day)
Synopsis: Basic Concepts: database characteristics and technology, data models, data abstraction, controlling redundancy, integrity. Database Architecture. Data independence. The client-server paradigm. Relational Model. Relational database design. Data Modelling. Weak entities. Notation. Normalisation. SQL: language components, DDL, DML. Tables and views. Constraints. Enforcing integrity and business rules. Triggers, procedures and functions. The system catalogue. Transaction concepts. Interleaving, lost updates, temporary updates, unrepeatable reads. Serialisability. Commits and rollbacks. Recovery concepts.
Assessment: Examination (3 hours): 60% + Practical work: 40%
Contact Hours: 4 hours per week
Prerequisites: 18 points of 1st Yr Network Computing study
Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT2901, COT3180, CSE2132, CSE2138, CSE2180, CSE3180, CSC3161, CSE3316, GCO2815, MMS2801, IMS2112, IMS1907.