4533 (v.4) Database Systems 252
| Area: | Department of Computing |
| Credits: | 25.0 |
| Contact Hours: | 4.0 |
| Lecture: | 1 x 2 Hours Weekly |
| Practical: | 1 x 2 Hours Weekly |
| Prerequisite(s): | 1922 (v.6) Software Technology 152 or any previous version
|
| Syllabus: | Introduction to database systems, Relational model and basic SQL, ER model, ER to relational mapping. Advanced SQL, SQL Programming, Triggers, Relational algebra, Normalisation, Data and Index Organisation, Relational query optimisation, Concurrency control, Crash recovery. |
| |
| Unit Outcomes: | On successful completion of this unit students will gain an understanding of the concepts underlying contemporary database systems and be able to design and implement databases to support many common applications. They will gain an ability to apply knowledge of basic science and engineering using logic as the basis for database models and design of structures. |
| Text and references listed above are for your information only and current as of September 30, 2003. Please check with the unit coordinator for up-to-date information. |
| Unit References: | Oracle8 Documentation http://isis.curtin.edu.au/oracle920/DOC/. Elmasri, R. and Navathe, S. B., 2000, 'Fundamentals of Database Systems', 3rd Edition, Addison-Wesley. Ullman, J. D. and Widom, J., 2002, 'A First Course in Database Systems', 2nd Edition, Prentice Hall. |
| Unit Texts: | Ramakrishnan, R. and Gehrke, J., 2003, 'Database Management Systems', 3rd Edition, McGraw Hill. Lecture slides available at http://www.computing.edu.au/units/ds252/. |
| |
| Unit Assessment Breakdown: | Test One 10%. Test Two 20%. Final Examination 70%. |
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Bentley Campus | Semester 1 | Y | | | | 2004 | Bentley Campus | Semester 2 | Y | | | |
Current as of: February 2, 2004
CRICOS provider code 00301J
