10080 (v.6) Database Systems 504

Area:

Department of Computing

Credits:

25.0

Contact Hours:

4.0

** The tuition pattern below provides details of the types of classes and their duration. This is to be used as a guide only. For more precise information please check your unit outline. **

Lecture:

1 x 2 Hours Weekly

Laboratory:

1 x 2 Hours Weekly

Syllabus:

Introduction to database systems, relational model and basic structured query language (SQL), entity relationship (ER) model, ER to relational mapping. Advanced SQL, SQL programming, triggers, relational algebra, Normalisation, data and index organisation, concurrency control and crash recovery.

** To ensure that the most up-to-date information about unit references, texts and outcomes appears, they will be provided in your unit outline prior to commencement. **

Field of Education:

020303 Database Management

Funding Cluster:

06 - Computing, Built Environment, Health

SOLT (Online) Definitions*:

Informational
*Extent to which this unit or thesis utilises online information

Result Type:

Grade/Mark

Availability

Year	Location	Period	Internal	Partially Online Internal	Area External	Central External	Fully Online
2007	Bentley Campus	Semester 1	Y
2007	Bentley Campus	Semester 2	Y

Area External	refers to external course/units run by the School or Department or offered by research.
Central External	refers to external and online course/units run through the Curtin Bentley-based Distance Education Area
Partially Online Internal	refers to some (a portion of) learning provided by interacting with or downloading pre-packaged material from the Internet but with regular and ongoing participation with a face-to-face component retained. Excludes partially online internal course/units run through the Curtin Bentley-based Distance Education Area which remain Central External
Fully Online	refers to the main (larger portion of) mode of learning provided via Internet interaction (including the downloading of pre-packaged material on the Internet). Excludes online course/units run through the Curtin Bentley-based Distance Education Area which remain Central External