Lecture schedule, Subject Outline, Assessment and other resources
Contact Details for Subject
Announcements
Subject Overview:
The primary aims of the subject CP1500 are to provide the student with an understanding of the importance of database technology in today's society and how they can use this technolory to manage their own data requirements. The subject will include a detailed discussion of database design and the relational database model.
Objectives:
Students completing this subject should be able to:
- Describe the features of a database and a database management system;
- Describe the relational database model, its features and their rationale;
- Formulate queries in SQL;
- Understand the database development process;
- Model a databse using the Entity-Relationship model;
- Use the techniques of normalisation and describe their basis;
- Implement a database design as a relational database using MS Access;
Textbook
Rob and Coronel, Database Systems: Design, Implementation, & Management, 6th Ed. Thomson LearningThis text will be used extensively throughout the course and students are required to have access to a text.
Previous Years: 1995, 1996, 1997, 1998, 1999, 2000, 2001, Sem1 2002, Sem1 2003, Sem1 2004, Sem1 2005,