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:

20300 Information Systems (Narrow Grouping)

HECS Band (if applicable):

2

Extent to which this unit or thesis
utilises online information:

Essential

Result Type:

Grade/Mark

Availability

Year Location Period Internal Area External Central External
2004 Bentley Campus Semester 1 Y    
2004 Bentley Campus Semester 2 Y    
2004 Bentley Campus Summer Period Y    
2004 Joondalup Campus Semester 1 Y    
2004 Joondalup Campus Semester 2 Y    
2004 Miri Sarawak Campus Semester 1 Y    
2004 Uni Bina Nusantara Indonesia Semester 1A Y    
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