Area: | School of Information Systems |
Credits: | 25.0 |
Contact Hours: | 2.0 |
Lecture: | 1 x 2 Hours Weekly |
Laboratory: | 1 x 2 Hours Weekly |
Equivalent(s): | 5924 (v.3) Business Computing 573 or any previous version
|
Anti Requisite(s): | 10997 (v.3) Database Systems 201 or any previous version
|
Prerequisite(s): | 11735 (v.3) Information Systems 501 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. |
| |
Unit Outcomes: | On successful completion of this unit, students will have - Created a relational database schema based on a conceptual model and any other data storage requirements otherwise identified. Created document database structures including tables, columns, andindexes according to standards. Used SQL to construct, secure and access data in a 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: | Hoffer, J.A. Prescott, M. and McFadden, F. R. (2002), Modern Database Management. 6th ed. New York, Prentice Hall. Date, C .J. (2000), An Introduction to Database Systems. New York, Addison-Wesley. |
Unit Texts: | Rob, P. and Coronel, C. (2002), Database Systems: Design, Implementation and Management, Boston, USA. 5th ed. Boston, Course Technology. |
| |
Unit Assessment Breakdown: | Final Examination 60%. Group Assignment 20%. Lab Exercises 10%. Lab Exercises 10%. 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: | Supplemental | 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 | | |
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 |
|
