Area: | School of Information Systems |
Credits: | 25.0 |
Contact Hours: | 4.0 |
Lecture: | 1 x 2 Hours Weekly |
Laboratory: | 1 x 2 Hours Weekly |
Prerequisite(s): | 10997 (v.3) Database Systems 201 or any previous version
|
Syllabus: | Database maintenance functions - loading data, establishing referential integrity of data, backup and recovery of data, problems of concurrency and performance issues relating to data locking and query design. Application development using embedded SQL. Data warehousing and data mining. |
| |
Unit Outcomes: | On successful completion of this unit, students will have - Created and loaded a database applying various integrity constraints. Tuned database tables and worked out the access path chosen by the query optimiser. Competently carried out some of the functions of database administration. Understood issues in designing concurrent transactions. |
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: | Singh, L. and Leigh, et al. (1997), Oracle 7.3 Developer's Guide. Indiana, Sams Publications. Brown, B (2001), Oracle9i Web Development. 2nd ed. Osborne McGraw-Hill. |
Unit Texts: | Hotka, Dan (1999), Oracle Development Unleashed. 3rd ed. Indiana, Sams Publications. Oracle 9i Online Reference. |
| |
Unit Assessment Breakdown: | Final Examination 60%. Group Assignment 20%. Lab Exercises 10%. Two Class Tests 10%. 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: | Supplemental | Result Type: | Grade/Mark |
|
Availability
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Joondalup Campus | Semester 1 | Y | | | | 2004 | Infrmtcs BH Islamabad | Trimester 1 | Y | | | | 2004 | Infrmtcs BH Islamabad | Trimester 2 | Y | | | | 2004 | Infrmtcs BH Islamabad | Trimester 3 | Y | | | | 2004 | Infrmtcs BH Karachi | Trimester 1 | Y | | | | 2004 | Infrmtcs BH Karachi | Trimester 2 | Y | | | | 2004 | Infrmtcs BH Karachi | Trimester 3 | Y | | | | 2004 | Infrmtcs BH Lahore | Trimester 1 | Y | | | | 2004 | Infrmtcs BH Lahore | Trimester 2 | Y | | | | 2004 | Infrmtcs BH Lahore | Trimester 3 | Y | | | | 2004 | Infrmtcs BH Multan | Trimester 1 | Y | | | | 2004 | Infrmtcs BH Multan | Trimester 2 | Y | | | | 2004 | Infrmtcs BH Multan | Trimester 3 | Y | | | | 2004 | Infrmtcs CS S'pore | Trimester 1 | Y | | | | 2004 | Infrmtcs CS S'pore | Trimester 2 | Y | | | | 2004 | Infrmtcs CS S'pore | Trimester 3 | 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 |
|
