Data Modelling and Database Design

2008 | 2009 | 2010

Area/catalogue: INFS 2004
Course ID: 012529

School: School of Computer and Information Science

Campus/course component(s):
                    City West: Lecture — Tutorial — Computer Practical
                    Mawson Lakes: Lecture — Tutorial — Computer Practical
                    This course is also available to students studying at an offshore location.
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: Yes

Course details

Prerequisite(s): INFS 5058 Fundamentals of Information Systems M OR , INFT 1016 Fundamentals of Information Technology.

Corequisite(s): COMP 1011 Programming in Java 1 OR , COMP 1008 Business Applications Programming 1.

The database environment; strategic data and systems planning; traditional file and database concepts.

Three-level architecture (conceptual, internal and external schemas) and data independence. Database requirements definition. Conceptual design plus design guidelines.

Overview of emerging database concepts.

Alternative data model notations: ER and UML; guidelines on choosing between alternative data model notations. Translation between UML and Entity-Relationship diagrams.

Logical design plus design guidelines: the relational model, functional dependency; when and how to normalise.

Physical design plus design guidelines: de-normalization; cluster and index structures, general rules of thumb on selection and placement of clusters and indices. Mention of object relational, hierarchical and network implementations.

The use of interactive SQL to construct and query databases. SQL from within a program.

Database management systems, Database administration and related functions. The decision of whether or not to use a database management system.

Specialist database topics such as Relational Algebra and embedded SQL, database access components and database APIs

Text book/s:

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

Course coordinator/s:

Dr Jixue Liu: Study Period 5
Dr Wolfgang Mayer: Study Period 2

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