Databases M

2008 | 2009 | 2010

Area/catalogue: INFS 5042
Course ID: 013685

School: School of Computer and Information Science

Campus/course component(s):
City West: Lecture — Tutorial — Computer Practical
Mawson Lakes: Lecture — Tutorial — Computer Practical
Note: These components may or may not be scheduled in every study period. Please refer to the timetable for further details.

Unit value: 4.5

Offered externally: Yes (Study Period 2, Study Period 5)

Undergraduate elective course: No

Course details

The role of data models in object-oriented system development:
Conceptual design: UML class diagrams; guidelines on choosing between alternative data model constructs. Learning to learn - translation between UML and Entity-Relationship diagrams.
Logical design: Relational model, when and how to normalise; mapping UML diagrams into relational database schemas.
Physical design: Cluster and index structures, general rules of thumb on selection and placement of clusters and indices.
Interactive SQL.
Architecture and technology of database management systems: 3-schema architecture and data independence, transaction management (techniques for concurrency control and recovery), storage management , access control.
Distributed database systems: Architecture; fragmentation and allocation; distributed transaction management; design of distributed databases, client-server architecture.
Object-oriented databases: Shortcomings of relational database systems and major characteristics of object-oriented database systems
General overview of current trends: Active database systems, temporal database systems, data warehouses, databases and the WWW.

Text book/s:

T. Connolly and C. Begg 2005, Database Systems: A Practical Approach to Design, Implementation and Management, 4th Edition, Addison Wesley IBSN 0321210255.

Course coordinator/s:

Dr Lin Liu

Fee information for this course

EFTSL: 0.125

Please note all EFTSL values are published and calculated at ten decimal places. Values are displayed to three decimal places for ease of interpretation.

UniSA offers courses to students either:

as part of a Commonwealth Supported program
as part of a postgraduate fee-paying program
as part of a program for fee-paying international students
as a non-award enrolment

Not all courses are available on all of these bases, and students must check to ensure that they are permitted to enroll in a particular course.

International students and students undertaking this course as part of a postgraduate fee paying program must refer to the relevant program home page to determine the applicable cost for undertaking this course.

Non-award tuition fees are set by the Division offering the course. How to determine the relevant non award tuition fee

The student contribution amount for students enrolling in this course as part of the requirements of a program for which they are Commonwealth Supported may be determined below:

Commonwealth Supported Band Amount: Band 2
How to determine your Commonwealth Supported course fee (student contribution)

Learning resources for this course

Resources specific to this course

General learning resources available through the Learning and Teaching Unit

Course evaluation online – student access only

Course evaluation online – staff access only

Assignment submission online

Open AssignIT

General Library resources

Support resources for this course

Technical/computer assistance

Administrative services

Campus Central
myUniSA
Class Timetable (Study Period 2 - 2009)
Class Timetable (Study Period 5 - 2009)
FINAL end of year exam timetable
More information about textbooks is available from Unibooks (clicking on the Unibooks logo will take you out of the University's web site)

[ ] [ ]

top^

Resources and Tools