11737 (v.3) Designing Database Systems 502

---

 

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.
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:	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.
Year Location Period Internal Area External Central External 2004 Bentley Campus Semester 1 Y     2004 Bentley Campus Semester 2 Y