DATABASE FUNDAMENTALS
CSE2DBF
2020
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.
School: Engineering and Mathematical Sciences (Pre 2022)
Credit points: 15
Subject Co-ordinator: Lianhua Chi
Available to Study Abroad/Exchange Students: Yes
Subject year level: Year Level 2 - UG
Available as Elective: Yes
Learning Activities: N/A
Capstone subject: No
Subject particulars
Subject rules
Prerequisites: CSE1OOF OR CSE1PE
Co-requisites: N/A
Incompatible subjects: CSE4DBF AND students admitted in any Graduate Diploma or Masters by Coursework course
Equivalent subjects: N/A
Quota Management Strategy: N/A
Quota-conditions or rules: N/A
Special conditions: N/A
Minimum credit point requirement: N/A
Assumed knowledge: N/A
Career Ready
Career-focused: No
Work-based learning: No
Self sourced or Uni sourced: N/A
Entire subject or partial subject: N/A
Total hours/days required: N/A
Location of WBL activity (region): N/A
WBL addtional requirements: N/A
Graduate capabilities & intended learning outcomes
Graduate Capabilities
Intended Learning Outcomes
Melbourne (Bundoora), 2020, Semester 1, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Lianhua Chi
Class requirements
Laboratory ClassWeek: 10 - 22
One 2.00 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.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* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |
Bendigo, 2020, Semester 2, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Eric Pardede
Class requirements
Laboratory ClassWeek: 31 - 43
One 2.00 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
One 2.00 hours lecture per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |
Melbourne (Bundoora), 2020, Semester 2, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Lianhua Chi
Class requirements
Laboratory ClassWeek: 31 - 43
One 2.00 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.00 hour lecture per week on weekdays during the day from week 31 to week 43 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |
Melbourne (Bundoora), 2020, LTU Term 5, Blended
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Lianhua Chi
Class requirements
Computer LaboratoryWeek: 37 - 42
Two 2.00 hours computer laboratory per week on weekdays during the day from week 37 to week 42 and delivered via online.
LectureWeek: 37 - 42
Four 1.00 hour lecture per week on weekdays during the day from week 37 to week 42 and delivered via online.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |
Sydney, 2020, Study period 1, Day
Overview
Online enrolment: No
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Lianhua Chi
Class requirements
Laboratory ClassWeek: 10 - 22
One 2.00 hours laboratory class per week from week 10 to week 22 and delivered via face-to-face.
LectureWeek: 10 - 22
Two 1.00 hour lecture per week from week 10 to week 22 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |
Sydney, 2020, Study period 2, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Lianhua Chi
Class requirements
Laboratory ClassWeek: 31 - 42
One 2.00 hours laboratory class per week on weekdays during the day from week 31 to week 42 and delivered via face-to-face.
LectureWeek: 31 - 42
Two 1.00 hour lecture per week on weekdays during the day from week 31 to week 42 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |
Sydney, 2020, Study period 3, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Subject Instance Co-ordinator: Lianhua Chi
Class requirements
Laboratory ClassWeek: 46 - 0
One 2.00 hours laboratory class per week on weekdays during the day from week 46 to week 0 and delivered via face-to-face.
LectureWeek: 46 - 0
Two 1.00 hour lecture per week on weekdays during the day from week 46 to week 0 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
One 3-hour examination (3,000-words equivalent)Hurdle requirement: To pass the subject, a pass in the examination is mandatory | N/A | N/A | Yes | 60 | SILO1, SILO2, SILO3, SILO4, SILO5 |
Assignment 1 - One database design assignment (400-words equivalent) | N/A | N/A | No | 15 | SILO1 |
Assignment 2 - One database programming assignment (400-words equivalent) | N/A | N/A | No | 20 | SILO3 |
Mid Semester Multiple Choice Test (700-words equivalent) | N/A | N/A | No | 5 | SILO1, SILO2, SILO3 |