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, HMSABU, 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
Subject options
Select to view your study options…
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 element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | SILO1, SILO2, SILO3 |
Bendigo, 2021, Semester 1, Online
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 online.
LectureWeek: 10 - 22
Two 1.00 day lecture per week on weekdays during the day from week 10 to week 22.
Assessments
Assessment element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | 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 element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | SILO1, SILO2, SILO3 |
Melbourne (Bundoora), 2021, Semester 1, Online
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 online.
LectureWeek: 10 - 22
Two 1.00 day lecture per week on weekdays during the day from week 10 to week 22.
Assessments
Assessment element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | 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 element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | SILO1, SILO2, SILO3 |
Bendigo, 2021, Semester 2, Online
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 online.
LectureWeek: 30 - 42
Two 1.00 hour lecture per week on weekdays during the day from week 30 to week 42 and delivered via online.
Assessments
Assessment element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | 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 element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | SILO1, SILO2, SILO3 |
Melbourne (Bundoora), 2021, Semester 2, Online
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 online.
LectureWeek: 30 - 42
Two 1.00 hour lecture per week on weekdays during the day from week 30 to week 42 and delivered via online.
Assessments
Assessment element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | 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 element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | 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 element | Category | Contribution | Hurdle | % | ILO* |
---|---|---|---|---|---|
3 hour examination (3,000-words equivalent) | Central exam | Individual | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 2 - Database implementation (800-words equivalent) | Assignment | Individual | No | 20 | SILO3 |
Assignment 1 - Database design and normalization theory (600-words equivalent) | Assignment | Individual | No | 15 | SILO1, SILO2 |
One multiple-choice 50 minute class test (700-words equivalent) | Quizzes | Individual | No | 5 | SILO1, SILO2, SILO3 |