CSE9002

Database Technology

(IT)

Offered subject to final approval

R Simpson

6 points + 2 hours lectures, 2 hours of laboratory practical and revision classes per week + First semester + Caulfield + Prohibitions: BUS2112, CFR2132, CFR2201, COT2180, COT3180, COT2132, COT2138, CSC3161

Synopsis: Database concepts and models, relational database management systems, semantic data modelling, entities and entity relationship modelling, normalisation, user requirements specification, database specification. Storage media and data organisation, logical data structures : linear and non-linear. Physical database implementation, integrity, backup, recovery, security. Structured Query Language, database administration. Current topics; distributed database, data warehousing, O-O database.

Assessment: Examination (2 hours): 50% + Practical work: 50%