GCO2815

Database management systems

(IT)

L F Smith

6 points + 4 hours per week + Second semester + Gippsland, distance + Prerequisites: GCO1810 or GCO2811 + Prohibitions: BUS2112, CFR2132, CFR3203, COT2132, COT2138

Synopsis: Introduction to database systems.The relational data model & DBMS record structures.Relational algebra, advanced features of relational model.DB design techniques:entity relationship (ER) modeling, normalization, Database Design Language (DBDL).Alternative data models:CODASYL model, Hierarchical model.Physical DB design.Relational query languages, SQL, Oracle SQL*Plus, embedded SQL using Java (SQLJ).DB administration, security.Transaction management, concurrency control, Query execution.DB recovery.Overview of distributed DB systems and object oriented DB systems.Access to the university's computer systems through an Internet service provider is compulsory for distance education students.

Assessment: Assignments (3): 40% + Examination (3 hours): 60%