305472 (v.1) Design (Advanced Database Design) 300

---

 

Area:	School of Information Systems
Credits:	25.0
Contact Hours:	4.0
Lecture:	1 x 2 Hours Weekly
Laboratory:	1 x 2 Hours Weekly
Equivalent(s):	10812 (v.2) Database Systems 302 or any previous version
Prerequisite(s):	305474 (v.1) Design (Database Design) 200 or any previous version
Syllabus:	Designing constraints, indexes and storage structures; loading data. Design considerations for access path optimisation. Database maintenance. Issues in backup, recovery and locking. Design and development of applications using embedded SQL. Object oriented databases. Data warehousing and data mining. Design of databases for electronic commerce.
Unit Outcomes:	On successful completion of this unit students will have a knowledge of design methods and rules for databases, standards for loading database tables, an in depth knowledge of optimisation and an understanding of the concept and principle of embedded SQL.
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:	Date, C.J., 1991, An Introduction of Database Systems, Vol I & II, 5th Ed., Addison-Wesley Publishing Company, Mass. McFadyen, R., Kanabar, K., 1991, An Introduction to Structured Query Language,Wm. C. Brown, Dubuque. Koch, G., Loney, K., 1997, Oracle 8i: The Complete Reference, Osboren McGraw-Hill, New York
Unit Texts:	Hotka, Dan, 2000, Oracle Unleashed (3rd Ed.), SAMS Publishing Company Inc.
Unit Assessment Breakdown:	Continuous assessment 50%, Examination 50%. This is by grade/mark assessment.
Year Location Period Internal Area External Central External 2004 Bentley Campus Semester 1 Y Y Y