cse2dbf database fundamentals

DATABASE FUNDAMENTALS

CSE2DBF

2019

Credit points: 15

Subject outline

This subject starts with an overview of the architecture and management of database systems, and a discussion of different existing database models. The main focus includes relational database analysis, design, and implementation. This subject prepares students for subjects such as the final year industry project which require an understanding of database design and implementation. The students learn: relational algebra as the formal foundation of relational databases; relational conceptual design using an entity-relationship diagram; relational logical database design; foundation of normalization; security and integrity; and SQL implementation of relational database queries. Students are required to design a database application that meets the needs of a system requirement specification, and to implement the system using a commercial standard database system such as ORACLE or POSTGRESQL. In addition, a selection of advanced topics in databases will be introduced and discussed.

SchoolSchool Engineering&Mathematical Sciences

Credit points15

Subject Co-ordinatorLianhua Chi

Available to Study Abroad StudentsYes

Subject year levelYear Level 2 - UG

Exchange StudentsYes

Subject particulars

Subject rules

Prerequisites CSE1OOF or CSE1PE

Co-requisitesN/A

Incompatible subjects CSE4DBF AND students admitted in any Graduate Diploma or Masters by Coursework course.

Equivalent subjectsN/A

Special conditionsN/A

Graduate capabilities & intended learning outcomes

01. Apply a database modelling technique using an ER and EER diagram, and use a transformation process to change these to a relational database design.

Activities:
Two lectures on the topics of ER/EER diagrams and the transformation methodology. Two associated lab sessions where students are given a problem statement and they are required to design the ER/EER representation diagram of the problem statement.

02. Identify the appropriate normalization techniques for database design.

Activities:
One lecture on normalization theory. One associated lab session where a set of un-normalized relations is given to students, and they are required to identify the correct steps to normalize the relations and remove anomalies.

03. Implement a database system using SQL and apply the relevant knowledge in database management and administration.

Activities:
Three lectures on SQL syntax and coding, and advanced database implementation techniques In the associated lab sessions, students write codes for creating tables, populating tables, and SQL queries.

04. Define the underlying model of relational database operations using relational algebra.

Activities:
One lecture on relational algebra fundamentals, One associated lab session where students are required to complete exercises in relational algebra.

05. Identify the possible risks and ethical and social considerations relevant to a designed system.

Activities:
One lab session discusses ethical and social issues in relation to database implementations using a case study from the Australian Computer Society.

Subject options

Select to view your study options…

Start date between: and    Key dates

Bendigo, 2019, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorTim Whitfort

Class requirements

Laboratory ClassWeek: 31 - 43
One 2.0 hours laboratory class per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.

LectureWeek: 31 - 43
One 2.0 hours lecture per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.

Assessments

Assessment elementComments%ILO*
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory6001, 02, 03, 04, 05
Assignment 1 - One database design assignment (400-words equivalent)1501
Assignment 2 - One database programming assignment (400-words equivalent)2003
Mid Semester Multiple Choice Test (700-words equivalent)501, 02, 03

Melbourne, 2019, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorLianhua Chi

Class requirements

LectureWeek: 10 - 22
Two 1.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Laboratory ClassWeek: 10 - 22
One 2.0 hours laboratory class per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementComments%ILO*
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory6001, 02, 03, 04, 05
Assignment 1 - One database design assignment (400-words equivalent)1501
Assignment 2 - One database programming assignment (400-words equivalent)2003
Mid Semester Multiple Choice Test (700-words equivalent)501, 02, 03

Melbourne, 2019, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorLianhua Chi

Class requirements

LectureWeek: 31 - 43
Two 1.0 hours lecture per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.

Laboratory ClassWeek: 31 - 43
One 2.0 hours laboratory class per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.

Assessments

Assessment elementComments%ILO*
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory6001, 02, 03, 04, 05
Assignment 1 - One database design assignment (400-words equivalent)1501
Assignment 2 - One database programming assignment (400-words equivalent)2003
Mid Semester Multiple Choice Test (700-words equivalent)501, 02, 03

Sydney, 2019, Study Period 1, Day

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorLianhua Chi

Class requirements

LectureWeek: 10 - 22
Two 1.0 hours lecture per week from week 10 to week 22 and delivered via face-to-face.

Laboratory ClassWeek: 10 - 22
One 2.0 hours laboratory class per week from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementComments%ILO*
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory6001, 02, 03, 04, 05
Assignment 1 - One database design assignment (400-words equivalent)1501
Assignment 2 - One database programming assignment (400-words equivalent)2003
Mid Semester Multiple Choice Test (700-words equivalent)501, 02, 03

Sydney, 2019, Study Period 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 31 - 42
One 2.0 hours laboratory class per week on weekdays during the day from week 31 to week 42 and delivered via face-to-face.

LectureWeek: 31 - 42
Two 1.0 hours lecture per week on weekdays during the day from week 31 to week 42 and delivered via face-to-face.

Assessments

Assessment elementComments%ILO*
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory6001, 02, 03, 04, 05
Assignment 1 - One database design assignment (400-words equivalent)1501
Assignment 2 - One database programming assignment (400-words equivalent)2003
Mid Semester Multiple Choice Test (700-words equivalent)501, 02, 03

Sydney, 2019, Study Period 3, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 46
One 2.0 hours laboratory class per week on weekdays during the day in week 46 and delivered via face-to-face.

LectureWeek: 46
Two 1.0 hours lecture per week on weekdays during the day in week 46 and delivered via face-to-face.

Assessments

Assessment elementComments%ILO*
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory6001, 02, 03, 04, 05
Assignment 1 - One database design assignment (400-words equivalent)1501
Assignment 2 - One database programming assignment (400-words equivalent)2003
Mid Semester Multiple Choice Test (700-words equivalent)501, 02, 03