CSE9002

Database Technology

(IT)

R Simpson

6 points + 2 hours lectures, 2 hours of laboratory practical and revision classes per week + First, second semester + Caulfield + Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT3180, CSE2132, CSE2138, CSE2180, CSE3180, CSC3161, COT7710 + On-campus enrolment mode.

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%