11737 (v.3) Designing Database Systems 502

Area:

School of Information Systems

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

Anti Requisite(s):

5924 (v.3) Business Computing 573 or any previous version
10997 (v.3) Database Systems 201 or any previous version
305474 (v.2) Database 200 or any previous version

Syllabus:

Concepts and principles of relational database modelling and design, creation of a relational database from a conceptual (entity relationship) model, normalisation, data and database integrity, design and definition of database structures (tables, columns, indexes and views), use of structured query language (SQL) to interface with a database, transaction analysis.

** 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:

020300 Information Systems (Narrow Grouping)

Funding Cluster:

06 - Computing, Built Environment, Health

SOLT (Online) Definitions*:

Supplemental
*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 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