Database systems and data management II
R Li
6 points * One 2-hour lecture and one 1-hour lab session per week * First semester * Clayton * Prerequisites: BUS1010 or equivalent * Prohibitions: CFR2132, COT2132, COT2138, COT2180, COT3180, CSC3161
This subject is designed to introduce students to the fundamental concepts necessary for the planning, design, use and implementation of database systems. The main topics covered include motivation for the database approach, conceptual modelling, coverage of logical data models (hierarchical, network and relational data models) and the use of SQL and other facilities provided by database management systems.
Assessment
Assignment 1 (fact-oriented modelling): 20% * Assignment 2 (database planning and design): 20% * Examination (2 hours): 60% * Note that a pass on the examination is required to pass the subject
Prescribed texts
Date C An introduction to database systems vol. 1, 5th edn, Addison-Wesley, 1990
McFadden F R and Hoffer J A Modern database management 4th edn, Benjamin-Cummings, 1994
Recommended texts
Bradley J Introduction to database management in business 2nd edn, Holt, Rinehart and Winston, 1987
Flaatten P O and others Foundations of business systems Dryden, 1989
Loomis M E S Data management and file structures 2nd edn, Prentice-Hall, 1989
Nijssen G M and Halpin T A Conceptual schema and relational database design Prentice-Hall, 1989