305474 (v.1) Design (Database Design) 200

---

 

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.
Text and references listed above are for your information only and current as of September 30, 2003. Please check with the unit coordinator for up-to-date information.
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.
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