GCO3851

Database management systems

L F Smith

6 points
* 4 hours per week
* First semester
* Gippsland and distance
* Prerequisites: GCO1813 or GCO2852 plus one of GCO1811, GCO1832 or GCO2851
* Note: This subject is not available to computing students

Objectives Students completing this subject should be able to demonstrate an understanding of relational and object-oriented database systems which will allow them to contrast the various systems' relative strengths and weaknesses; develop a conceptual database model for a particular environment using the tools of entity relationship modelling and normalisation and produce, from a given conceptual database design, a schema file from which an efficient database can be generated; and use SQL both interactively and to develop a user-oriented database system.

Synopsis Overview of database management systems; introduction to the relational model; normalisation and relational design; ER modelling, object data modelling, Database Design Language; the fourth-generation environment; database administration, database security and recovery, distributed databases and current trends in the field. Interactive SQL and embedded SQL in a third-generation language. Database system development using either MS Windows based MicroSQL or Visual Basic. For distance education students there is an optional four hours contact at each weekend school, coupled with study guides and provision for additional student contact through phone, fax and electronic mail.

Assessment Assignments: 40%
* Examination 60%
* To successfully complete this subject students must achieve at least 50% of the total overall marks with a contribution to this total of no less than 40% of the possible marks from the assignments and no less than 40% of the possible marks from the examination.

Prescribed texts

Rob P and Coronel C Database systems - design, implementation and management Wadsworth, 1997

Prescribed software

EQL Software Windows MicroSQL user guide vols 1 and 2, MicroResearch, 1996 or
MS Visual Basic Version 4.0 Professional edition (or later)