DATABASE FUNDAMENTALS
CSE4DBF
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. The students learn: relational algebra as the formal foundation of relational databases; relational conceptual design using an entity-relationship diagram; relational logical database design; security and integrity; and SQL implementation of relational database queries. Students will also learn advanced normalization theory and the techniques to remove data anomalies and redundancies. In this subject, 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 4 - UG/Hons/1st Yr PG
Exchange StudentsYes
Subject particulars
Subject rules
Prerequisites CSE4OOF OR Admission into one of the following courses: SMIT, SMITCN, SMICT, SMCSC, SGCS, SGIT, SMDS, HMSA or HGSA.
Co-requisitesN/A
Incompatible subjects CSE2DBF AND Students in the following courses are not permitted to enrol: SBCS, SBIT, SBCSGT, SVCSE, SZCSC, SBITP and SBBIY.
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:
- Lectures 2 and 3 are on the topics of ER/EER diagrams and the transformation methodology. In Lab 2, a set of problem statements is given to students, and they are required to design the ER/EER representation diagram. Lab 3 is on transforming the above ER/EER to a relational database design.
02. Evaluate database design in terms of data anomalies and redundancies by applying the appropriate normalization techniques.
- Activities:
- Lecture 4 is on normalization theory. In Lab 4, a set of unnormalised relations is given to students, and they are required to identify the correct steps to normalise the relations and remove anomalies. In addition, students will have to complete a series of Moodle quizzes on normalization theory.
03. Implement a database system using SQL and advanced PL/SQL including stored procedures and triggers.
- Activities:
- Lectures 6, 7, 8 are on SQL syntax and coding, stored procedures and trigger implementation and case studies. Labs 5 to Lab 11 are on database implementation, SQL queries, implementation of stored procedures and triggers.
04. Explain the underlying model of relational database operations using relational algebra.
- Activities:
- Lecture 5 is on relational algebra fundamentals, and students are required to complete a Moodle online self-test on exercises in relational algebra.
05. Evaluate the possible risks and ethical and social considerations relevant to a designed system.
- Activities:
- In Lab 8, a case study based on a published case from the Australian Computer Society is presented and discussed.
Subject options
Select to view your study options…
Melbourne, 2019, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorLianhua Chi
Class requirements
Computer Laboratory
Week:
10
-
22
One 2.0 hours computer laboratory per week
on weekdays
during the day
from week 10 to week 22
and delivered via face-to-face.
Lecture
Week:
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.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| 3 hour examination (3,000-words equivalent) | Hurdle requirement: To pass the subject, a pass in the examination is mandatory. | 60 | 01, 02, 03, 04, 05 |
| Assignment 2 - Database implementation (800-words equivalent) | 20 | 03 | |
| Assignment 1 - Database design and normalization theory (600-words equivalent) | 15 | 01, 02 | |
| One multiple-choice 50 minute class test (700-words equivalent) | 5 | 01, 02, 03 |
Melbourne, 2019, Semester 2, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorLianhua Chi
Class requirements
Computer Laboratory
Week:
31
-
43
One 2.0 hours computer laboratory per week
on weekdays
during the day
from week 31 to week 43
and delivered via face-to-face.
Lecture
Week:
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.
Assessments
| Assessment element | Comments | % | ILO* |
|---|---|---|---|
| 3 hour examination (3,000-words equivalent) | Hurdle requirement: To pass the subject, a pass in the examination is mandatory. | 60 | 01, 02, 03, 04, 05 |
| Assignment 2 - Database implementation (800-words equivalent) | 20 | 03 | |
| Assignment 1 - Database design and normalization theory (600-words equivalent) | 15 | 01, 02 | |
| One multiple-choice 50 minute class test (700-words equivalent) | 5 | 01, 02, 03 |