Area: | School of Information Systems |
Credits: | 25.0 |
Contact Hours: | 5.0 |
Lecture: | 1 x 2 Hours Weekly |
Tutorial: | 1 x 1 Hours Weekly |
Laboratory: | 1 x 2 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. |
| |
Unit Outcomes: | On successful completion of this unit student will have - Created a relational database schema based on a conceptual model and any other data storage requirements otherwise identified. Documented database structures including tables, fields, and indexes according to standards. Used SQL to construct, secure and access the database. Understood the fundamental principles of different data architectures. |
Texts and references listed below are for your information only and current as of September 30, 2003. Some units taught offshore are modified at selected locations. Please check with the unit coordinator for up-to-date information and approved offshore variations to unit information before finalising study and textbook purchases. |
Unit References: | Rob, P. and Coronel, C. (2002), Database Systems, Design, Implementation and Management. 5th ed. Thompson Learning. Pratt, P. J. and Adamski, J. J. (2002), Concepts of Database Management, 4th ed. Thompson Learning. Kroenke, D. M. (2002), Database Processing: Fundamentals, Design and Implementation. 8th ed. Prentice Hall. ACM Transactions on Database Systems. Database. Data and Knowledge Engineering. Datamation. Morien, R., Representing Relationships in the Relational Model, Tutorial Paper, Curtin University. ACM Transactions on Database Systems. Database. Data and Knowledge Engineering. Datamation. |
Unit Texts: | Hoffer, J. A., Prescott, M. and McFadden, F. R. (2002), Modern Database Management. 6th ed. Prentice Hall. |
| |
Unit Assessment Breakdown: | Final examination 50%, Group assignment 20%, Laboratory test 15%, Semester test 10%, Turorial participation 5%. This is by grade/mark assessment. |
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 | | |
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 |
|
