DATABASE FUNDAMENTALS

CSE4DBF

2021

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.

SchoolEngineering and Mathematical Sciences

Credit points15

Subject Co-ordinatorLianhua Chi

Available to Study Abroad/Exchange StudentsYes

Subject year levelYear Level 4 - UG/Hons/1st Yr PG

Available as ElectiveNo

Learning ActivitiesN/A

Capstone subjectNo

Subject particulars

Subject rules

Prerequisites CSE4OOF OR Admission into one of the following courses: SMIT, SMITCN, SMICT, SMCSC, SGCS, SGIT, SMDS, HMSA, HGSA, HMDH, HCHCA or SMAI

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

Quota Management StrategyN/A

Quota-conditions or rulesN/A

Special conditionsN/A

Minimum credit point requirementN/A

Assumed knowledgeN/A

Career Ready

Career-focusedNo

Work-based learningNo

Self sourced or Uni sourcedN/A

Entire subject or partial subjectN/A

Total hours/days requiredN/A

Location of WBL activity (region)N/A

WBL addtional requirementsN/A

Graduate capabilities & intended learning outcomes

Graduate Capabilities

Intended Learning Outcomes

01. Design a relational database using an ER or EER diagram, and use a transformation process to change the ER or EER diagram to a relational database design.
02. Evaluate database design in terms of data anomalies and redundancies by applying the appropriate normalization techniques.
03. Implement database systems using SQL and advanced PL/SQL including stored procedures and triggers.
04. Explain the underlying model of relational database operations using relational algebra.
05. Evaluate the possible risks and ethical and social considerations relevant to designed systems.

Subject options

Select to view your study options…

Start date between: and    Key dates

Bendigo, 2021, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Computer LaboratoryWeek: 10 - 22
One 2.00 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.00 hour lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

3 hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory.

N/AN/AN/AYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 2 - Database implementation (800-words equivalent)

N/AN/AN/ANo20 SILO3

Assignment 1 - Database design and normalization theory (600-words equivalent)

N/AN/AN/ANo15 SILO1, SILO2

One multiple-choice 50 minute class test (700-words equivalent)

N/AN/AN/ANo5 SILO1, SILO2, SILO3

Melbourne (Bundoora), 2021, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Computer LaboratoryWeek: 10 - 22
One 2.00 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.00 hour lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

3 hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory.

N/AN/AN/AYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 2 - Database implementation (800-words equivalent)

N/AN/AN/ANo20 SILO3

Assignment 1 - Database design and normalization theory (600-words equivalent)

N/AN/AN/ANo15 SILO1, SILO2

One multiple-choice 50 minute class test (700-words equivalent)

N/AN/AN/ANo5 SILO1, SILO2, SILO3

Bendigo, 2021, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Computer LaboratoryWeek: 30 - 42
One 2.00 hours computer laboratory per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

LectureWeek: 30 - 42
Two 1.00 hour lecture per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

3 hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory.

N/AN/AN/AYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 2 - Database implementation (800-words equivalent)

N/AN/AN/ANo20 SILO3

Assignment 1 - Database design and normalization theory (600-words equivalent)

N/AN/AN/ANo15 SILO1, SILO2

One multiple-choice 50 minute class test (700-words equivalent)

N/AN/AN/ANo5 SILO1, SILO2, SILO3

Melbourne (Bundoora), 2021, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Computer LaboratoryWeek: 30 - 42
One 2.00 hours computer laboratory per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

LectureWeek: 30 - 42
Two 1.00 hour lecture per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

3 hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory.

N/AN/AN/AYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 2 - Database implementation (800-words equivalent)

N/AN/AN/ANo20 SILO3

Assignment 1 - Database design and normalization theory (600-words equivalent)

N/AN/AN/ANo15 SILO1, SILO2

One multiple-choice 50 minute class test (700-words equivalent)

N/AN/AN/ANo5 SILO1, SILO2, SILO3

Bendigo, 2021, LTU Term 1, Blended

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Computer LaboratoryWeek: 2 - 7
Two 2.00 hours computer laboratory per week on weekdays during the day from week 2 to week 7 and delivered via online.
2 classes per week with 2 hours each

LectureWeek: 2 - 7
Four 1.00 hour lecture per week on weekdays during the day from week 2 to week 7 and delivered via online.
4 classes per week with 1 hour during each

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

3 hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory.

N/AN/AN/AYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 2 - Database implementation (800-words equivalent)

N/AN/AN/ANo20 SILO3

Assignment 1 - Database design and normalization theory (600-words equivalent)

N/AN/AN/ANo15 SILO1, SILO2

One multiple-choice 50 minute class test (700-words equivalent)

N/AN/AN/ANo5 SILO1, SILO2, SILO3

Melbourne (Bundoora), 2021, LTU Term 1, Blended

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Computer LaboratoryWeek: 2 - 7
Two 2.00 hours computer laboratory per week on weekdays during the day from week 2 to week 7 and delivered via online.
2 classes per week with 2 hours each

LectureWeek: 2 - 7
Four 1.00 hour lecture per week on weekdays during the day from week 2 to week 7 and delivered via online.
4 classes per week with 1 hour during each

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

3 hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory.

N/AN/AN/AYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 2 - Database implementation (800-words equivalent)

N/AN/AN/ANo20 SILO3

Assignment 1 - Database design and normalization theory (600-words equivalent)

N/AN/AN/ANo15 SILO1, SILO2

One multiple-choice 50 minute class test (700-words equivalent)

N/AN/AN/ANo5 SILO1, SILO2, SILO3