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. |
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: | 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. |
Field of Education: | 20300 Information Systems (Narrow Grouping) | HECS Band (if applicable): | 2 |
|
Extent to which this unit or thesis utilises online information: | Not Online | Result Type: | Grade/Mark |
|
Availability
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Bentley Campus | Semester 1 | Y | Y | 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 |
|
