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. |
Texts and references listed below are for your information only and current as of September 30, 2003. Some units taught offshore are modified at selected locations. Please check with the unit coordinator for up-to-date information and approved offshore variations to unit information before finalising study and textbook purchases. |
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%. |
Field of Education: | 31300 Electrical and Electronic Engineering and Technology (Narrow Grouping) | HECS Band (if applicable): | 2 |
|
Extent to which this unit or thesis utilises online information: | Informational | Result Type: | Grade/Mark |
|
Availability
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Bentley Campus | Semester 1 | Y | | | | 2004 | Bentley Campus | Semester 2 | Y | | |
Area
External | refers to external course/units run by the School or Department, offered online or through Web CT, or offered by research. |
Central
External | refers to external course/units run through the Curtin Bentley-based Distance Education Area |
|
