cse2dbf database fundamentals

DATABASE FUNDAMENTALS

CSE2DBF

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. 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.

FacultyFaculty of Science, Tech & Engineering

Credit points15

Subject Co-ordinatorEric Pardede

Available to Study Abroad StudentsYes

Subject year levelYear Level 2 - UG

Exchange StudentsYes

Subject particulars

Subject rules

Prerequisites CSE1OOF or (If enrolled in Bachelor of Computer Science (Hons)/Bachelor of Electronic Engineering CSE1CES or CSE2CES).

Co-requisitesN/A

Incompatible subjects CSE4DBF

Equivalent subjectsN/A

Special conditionsN/A

Subject options

Select to view your study options…

Start date between: and    Key dates

Bendigo, 2014, 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
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 elementComments%
one 3-hour examination60
Assignment 120
Assignment 2Hurdle requirement: In order to pass the unit, students must obtain an overall pass grade, pass the examination and pass the overall non-examination components.20

Melbourne, 2014, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Enrolment information

Subject Instance Co-ordinatorEric Pardede

Class requirements

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.

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 elementComments%
one 3-hour examination60
Assignment 1, one database design assignment (equivalent to 600-words)15
Assignment 2, one database programming assignment (equivalent to 900-words)20
Mid Semester Test (45 minutes)Hurdle requirement: In order to pass the unit, students must obtain an overall pass grade, pass the examination and pass the overall non-examination components.5