FEC 4/04:

Previous:

The Graduate Diploma of Computing and the Master of Applied Information Technology (MAIT) have been reviewed and restructured jointly by all schools involved in teaching it. The changes have been designed to ensure smoother movement of students between the Graduate Diploma of Computing and the MAIT, and in light of changed immigration rules. This unit is being modified to add an on-campus offering for this revised program.

An on-campus offering is added to GCO9804 in preparation for the Gippsland on-campus offering of the MAIT.

Deletion of pre-requisite. The topic of embedded SQL has been excluded from GCO9804 because it is more appropriate in the commercial programming unit. Thus, no programming pre-requisite is required any more for GCO9804.

Current (Semester 1, 2006):

The reason of the syllabus change in this version is because it is an equivalent unit to the core unit, FIT1004, which is introduced in Semester 1, 2006, as part of the BITS degree.

See "Reasons for Change"

GCO9804 offers theoretical knowledge and practical applications for the use of database technology to support a wide range of Information Systems in a variety of applications. The use of database technology for the persistent storage of information, is a vital skill to aquire to enable students to be competitive and informed in their further study or future employment.

At the completion of this unit students will have knowledge and understanding of:

1. the major objectives of database technology;
2. the relational model for databases and competing models;
3. the phases of the database development life cycle and their correspondence to the phases of the system development lifecycle;
4. the techniques and tools to design and implement a database suitable for an information system;
5. a database retrieval and manipulation language;
6. methods to in put place physical structures to permit efficient operation of a database;
7. the relationship of database technology to data warehousing and data mining;
8. the role of a database administrator;

At the completion of this unit students will have developed attitudes that enable them to:

9. Appreciate the privacy issues relating to storage of data in a database.
10. Practice ethical behaviour when developing, implementing and using a database.

ASCED Discipline Group classification: 020303 Database Management

This unit will provide an introduction to the concepts of database management. This will include planning, designing, using and implementing a data model using an enterprise-scale relational database system. Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.

This unit will provide an introduction to the principles and concepts of database systems their organisation and management. The issues of physical and logical data description are addressed. Various data models,and a query language, are introduced. This will include planning, designing, using and implementing a data model using an enterprise-scale relational database system. Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.

Prescribed text:

Rob, P. and Coronel, C., Database Systems 6th Edn., Thomson Course Technology, 2004

Recommended Reading:

Hoffer, J.A., Prescott, M.B. and McFadden, F.R., Modern Database Management 7th Edn., Addison-Wesley, 2005

Kifer, M., Berstein, A. and Lewis, P., Database Systems: An Application-Oriented Approach, 2nd Edn., Addison-Wesley, 2005

On-campus and off-campus learning

Teaching will be conducted through lectures and tutorials which will include discussion groups and the use of commercial database management software. The specified reading will support the lecture and tutorial activity. The unit will also be taught by OCL using a range of web based and printed materials.

Lectures: The lectures will introduce the theory and explore each topic addressing objectives 1 to 10. Laboratory sessions: Laboratory sessions will provide an environment in which material presented in lectures will be reviewed and put into practice, where possible. Students will undertake exercises that will enable them to create and maintain a database addressing objectives 1 to 10.

Assessment will include two practical assignments based on case studies and a three hour exam based on both the theorectical and practical content of the subject.

Assessment will consist of one three hour examination primarily designed to test theoretical and practical knowledge, and two practical assignments; both of which must be attempted. In arriving at the final grade for this subject, the examination will carry 60% of the result and the practical work will carry 40% WORKLOADS

12 hours per week. Contact time for on-campus modes will usually be four hours per week. The breakdown of contact time into lectures, tutorials, laboratories, workshops and studio sessions will be set individually for each campus.

On-campus offerings will require a high-tech lecture theatre with data display and internet connection, with a PC and facility to plug in a laptop, for two hours per week throughout the semester. Equivalent requirements for summer semester offerings.

Will be set according to the individual needs of each campus offering. Tutorials will normally be scheduled in flexible learning spaces with access to networked computers, discussion and group-work facilities (flexible desk arrangements, white boards, data projectors).

Oracle Client, IRA (Instructional Relational Algebra), Visio, Gershwin

Special Interest Group (SIG) to monitor unit and prepare resources.

One lecturer from GSIT to teach the unit. A tutor (from GSIT) per tutorial/lab session/workshop/studio offering each semester.

• Software Title:
• Vendor:
• Version:
• OS: MS Windows XP ( ) and/or LINUX ( )
• License Details: (A valid software license certificate/s or Vendor permission must be available upon request if the software is to be installed for teaching)
• Are we currently licensed: Yes ( ) or No ( ) (If unsure, please check with your local IT support )
• If (Yes), who is the contact person for this software?:
• If (No), will the software license be arranged by: Staff member requesting the software ( ) or Technical Services* ( ) ? *If the latter is selected, please discuss your requirement/s with myself ASAP, prior to finalising your request, as there could be financial or resourcing implications.
• Is the software to be installed and accessed from a: Client/Workstation ( ), or Server ( ) ?
• Type of license: Site License ( ), Freeware ( ), FOSS (Free and Open Source Software) ( ), Shareware ( ), Lab based ( ) # of Licenses needed ____
• In what week will you commence using the software in class? Semester 1 (Week ___ ) and/or Semester 2 (Week ___ ):
• Nominated Staff For Acceptance Testing Software: (Name) (Phone) (Email)
• Additional Information: Special Requirements, Software Configuration/Installation Requirements, etc:

Course Technology Kit for Oracle9i Software Boston, USA, Course Technology, Thomson Learning ISBN 0-619-15913-8

Adequate copies of at least the recommended texts listed above.

100% from GSIT

Since GCO9804 uses the syllabus of FIT1004, which is a Faculty unit, the team responsible for FIT1004 development has had represntatives from all organizational units of the faculty.

The administration of teaching of GCO9804 is handled by GSIT.

Off-campus learning requirements: students are required to have access to a PC with a specified minimum configuration and to the Internet

None