Data Modelling

up to course's home page Convener/Lecturer:
Peter Bernus Tutoring/Marking:
Peter Bernus

2180CIT / 7180CIT

Data Modelling

Semester 2, 2004 offering

For 2005 go to http://www.cit.gu.edu.au/~noran/2180cit/

Course outline	pdf
Lecture	Thursdays 10:00AM-12:00noon	N48 - Nathan Heath Science Building 0.14	Weeks 1...13
Tutorials	Fridays 2PM-3PM	N18 - Central Theatre 2 (N18)	Weeks 2...5, 7..13

Consultation	Make appointment with the lecturer by email
Teaching material	Syllabus [password to be provided by email to students who are enrolled]
Textbook	Elmashri / Navathe: Fundamentals of Database Systems (3rd Edition) Addison Wesley, 2000. (abbreviated as 'E&N')
Mid-semester exam (15%)	Topics: Database concepts, ER, ER to relational mapping, Rel Algebra Review Q1-Q9 in a past exam (without solutions and with solution) homeworks for weeks 1-6 and lecture slides. Closed Book examination. Results available here	For the entire class: N48 - Nathan Heath Science Building 0.14 10AM-12noon Special seating for or MEE students: N06_0.14 8AM-10AM	Thursday Week 7
Individual lab work	Work with ORACLE 8i [Oracle login and passwd has been advertised by email to you on the 31 August 2004] - work in your own time plus participate the 'on line lab' in week 9 (see Syllabus)		Start in week 6
SQL assessed lab (20%)	Content and format similar to the exercises in 'Individual work with Oracle8i' above. Open book. See sample assessed lab. Students will be allocated to time slots / venues below (see where you need to go and when) Thursday 7th October 13:00-15:00 Nathan N44_2.16 10 Thursday 7th October 16:00-18:00 Nathan N44_2.16 10 Friday 8th October 8:00-10:00 Nathan N44_2.25 10 Friday 8th October 12:00-14:00 Nathan N44_2.25 10 Friday 8th October 16:00-18:00 Nathan N44_2.16 10 Friday 8th October 16:00-18:00 Nathan N44_1.18 10	Results to be advertised here	Week 10
Home Assignment (15%)	Home assignment available here	Results	Due week 6 (1 September 4:00 PM)
End of Semester Exam (50%)	All topics studied are examinable. See exam topics See an earlier exam paper [needs password] Last Minute Hints	Results for the entire semester

This course is a systematic introduction to techniques for logically modelling the information used by an enterprise, for translating such models to database schemata, for normalising database schemata, and to the use of modern database query and update languages. Assessment includes assignment, assessed laboratory, in-class examination and a final examination.