Area: | School of Information Systems |
Credits: | 25.0 |
Contact Hours: | 4.0 |
Lecture: | 1 x 2 Hours Weekly |
Laboratory: | 1 x 2 Hours Weekly |
Syllabus: | Architecture of a DBMS. Designing constraints and structures for database access - index, hashed cluster, tablespace. Loading and establishing data integrity. Concurrency control. Optimisation techniques. Mining a database for useful information, data warehousing. Designing database for e-commerce. |
| |
Unit Outcomes: | On successful completion of this unit students will be able to - Design methods and rules for databases and standards for loading database tables. Illustrate an in-depth knowledge of optimization and the concept and principle method of embedded SQL. Apply data warehousing and data mining to enterprise database environments. Design a database for an electronic commerce environment. |
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 and II, 5th ed., Mass, Addison-Wesley. McFadyen,R. and Kanabar, K., (1991), An Introduction to Structured Query Language, Wm. C. Brown, Dubuque. Koch, G. and Loney, K., (1997), Oracle 8 - TheComplete Reference, NY, Osboren McGraw-Hill. |
Unit Texts: | Hotka, Dan, 2000, Oracle Unleashed (3rd Ed.), SAMS Publishing Company Inc. |
| |
Unit Assessment Breakdown: | Examination 50%. Presentation 20%. Written Assessment 30%. 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 Categorised | Result Type: | Grade/Mark |
|
Availability
| Year | Location | Period | Internal | Area External | Central External | | 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 |
|
