305474 (v.1) Design (Database Design) 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

Anti Requisite(s):

10997 (v.3) Database Systems 201 or any previous version
13604 (v.1) Database Systems 203

Prerequisite(s):

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 relational model from a conceptual (entity relationship) model, normalisation, integrity of data and databases, design and definition of database structures - tables, fields,indexes, sets and views and use of Structured Query Language (SQL) as a database interface language.

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

Essential
*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
2005	Bentley Campus	Semester 1	Y
2005	Bentley Campus	Semester 2	Y
2005	Bentley Campus	Study Period 1 (Summer)	Y
2005	Miri Sarawak Campus	Semester 1	Y
2005	Miri Sarawak Campus	Study Period 1 (Summer)	Y
2005	Uni Bina Nusantara Indonesia	Semester 1A	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