Link to Curtin homepage      CurtinSearch | Curtin Site Index 
Online handbook 2004
CoursesUnitsNew CoursesJoint Uni CoursesDefinition of TermsContact / Help
About Curtin University
Academic calendar
Admissions Information
Applying for a research higher degree
Applying to Curtin
Bookshop
Prospective student service
Curtin scholarships
Enrolment information
Fee Information
Grading system
IT Policy
Student rights and responsibilities
Student policy and procedures
    

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.

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

YearLocationPeriodInternalArea ExternalCentral External
2004Bentley CampusSemester 1Y  
2004Bentley CampusSemester 2Y  

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

 
Click here for a printable version of this page

    

Picture of sun setting over Henderson Court on Curtin's Bentley Campus

 

Curtin crest