FEC 3/03 Reasons for ChangeChanges to commercial programming and development environments now require that students studying these application development languages apply them using databases. Consequently the prerequisite for the core unit GCO2811 Commercial Programming in the Bachelor of Information Technology is to become GCO2815 Database Management Systems, requiring that this unit now be offered in both semester 1 and semester 2. The prerequisites are also being updated to a first level programming unit.The proposal also requests that the unit be made available in Malaysia and Gippsland in the BIT.Previous ChangeGCO2815 Database Management Systems is a core unit in all majors of the Bachelor of Computing at Gippsland.

This existing unit is being modified to allow for a summer semester offering. Reason for introducing GCO2815 is reflected above.

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.

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.

GCO2815 is a 2nd level core unit in the BIT degree.

GCO2815 is the pre-requisite for GCO2811, GCO3500, GCO3700, GCO3800, GCO3900, GCO3823

GCO2815 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

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%

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

Nil

Nil

Since GCO2815 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 GCO2815 is handled by GSIT.

GCO1810 or GCO1811