Search | Previous : 615-220 | Next : 615-237
Handbook 1997 : Faculty of Science : Information Systems

615-230 Database Concepts

Note:

This subject is regarded as a non-science subject for students enrolled in the single BSc and combined BSc courses.

Credit Points:

12.5

Coordinator:

Dr D Kemp

Prerequisite/s:

615-145 Concepts in Software Development I

Corequisite/s:

615-240 Concepts in Software Development II

Timetable:

Semester 1

Contact:

Three one hour lectures and one one hour tutorial each week

Objectives:

At the completion of this subject, students should:

  • understand the concepts of physical, conceptual, and view levels of data abstraction;

  • understand common techniques used for data modelling;

  • understand the concept of and need for data independence;

  • understand a commonly used data manipulation language;

  • be able to formulate ad-hoc database queries;

  • be familiar with database application development techniques;

  • be familiar with the role of a database administrator;

  • have hands-on experience with a commercially available database management system.

Content:

Aspects of the following topics will be considered: data models (relational, network, hierarchical, entity-relationship, and object-oriented), commercial data manipulation languages including structured query language (SQL), view definitions, database design (including update anomalies and normalisation), database administration (security, integrity, and concurrency), concurrency control, transaction processing, embedded SQL, and database application programming interfaces; other database concepts.

Assessment:

End of semester written examination of up to three hours, one group project taking up to forty hours. The weighting of the assessment components will be announced at the commencement of the subject.
Search | Previous : 615-220 | Next : 615-237
Handbook 1997 : Faculty of Science : Information Systems 
Status:                   OFFICIAL 1997
Last Modified:            Wednesday March 12 3:36 pm
SGML to HTML Conversion:  Information Technology Services
Authorised by:            Academic Registrar
Email Enquiries:          Course_Information@registrar.unimelb.edu.au
Copyright © University of Melbourne 1997.