BUS5071

Database systems and data management V

R C Redpath

6 points
* One 2-hour lecture and one 1-hour laboratory session per week
* First semester
* Clayton

Objectives At the completion of this subject students should be able to understand the basis for database systems; capable of planning, designing and implementing database systems; familiar with hierarchical, network and relational data models; and capable of using SQL and other systems for management of the systems.

Synopsis 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 (data retrieval): 20%
* Assignment 2 (database planning, design and implementation): 20%
* Examination (2 hours): 60%
* Note that a pass on the examination is required to pass the subject

Prescribed texts

McFadden F R and Hoffer J A Modern database management 4th edn, Benjamin Cummings, 1994

Recommended texts

Date C An introduction to database systems vol. 1, 5th edn, Addison-Wesley, 1990
Elmasri R and Navathe S B Fundamentals of database systems 2nd edn, Benjamin Cummings, 1994
Loomis M E S Data management and file structures 2nd edn, Prentice-Hall, 1989