310661 (v.1) Database 200

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
Tutorial:	1 x 1 Hours Weekly
Laboratory:	1 x 1 Hours Weekly
Prerequisite(s):	310410 (v.1) Systems Analysis and Design 150 or any previous version OR 305457 (v.1) Design (User Interface and Web Design) 150 or any previous version
Syllabus:	Principles of relational database modelling and design, including creation of a rational model from a conceptual (entity relationship) model, normalisation, integrity of data and databases, design and definition of database structures: tables and views and use of structured query language (SQL). Definition and use of triggers and procedures.
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)
SOLT (Online) Definitions*:	Essential *Extent to which this unit or thesis utilises online information
Result Type:	Grade/Mark

Availability

Year	Location	Period	Internal
2008	Bentley Campus	Semester 1	Y
2008	Bentley Campus	Semester 2	Y
2008	De Chazal Du Mee Bus Mauritius	Semester 1	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