cse4dbf database fundamentals
DATABASE FUNDAMENTALS
CSE4DBF
2014
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.
FacultyFaculty of Science, Tech & Engineering
Credit points15
Subject Co-ordinatorEric Pardede
Available to Study Abroad StudentsYes
Subject year levelYear Level 4 - UG/Hons/1st Yr PG
Exchange StudentsYes
Subject particulars
Subject rules
Prerequisites CSE1OOF or CSE4OOF AND Enrolment in one of the following courses: SMIT, SMITCN, SMICT, SMCSC, SMBBS, SGBBS, SGCS, or SGIT.
Co-requisitesN/A
Incompatible subjects CSE2DBF
Equivalent subjectsN/A
Special conditionsN/A
Subject options
Select to view your study options…
Melbourne, 2014, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorEric Pardede
Class requirements
Computer LaboratoryWeek: 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.
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.
Assessments
Assessment element | Comments | % |
---|---|---|
3 hour examination | 60 | |
Assignment 2 - database implementation | Hurdle requirment: In order to pass the subject, students must obtain an overall pass grade, pass the examination and pass the assignment component. | 20 |
Assignment 1 - database design and normalization theory | 15 | |
one class test | 5 |