DATABASE FUNDAMENTALS

CSE2DBF

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

SchoolEngineering and Mathematical Sciences

Credit points15

Subject Co-ordinatorLianhua Chi

Available to Study Abroad/Exchange StudentsYes

Subject year levelYear Level 2 - UG

Available as ElectiveNo

Learning ActivitiesN/A

Capstone subjectNo

Subject particulars

Subject rules

PrerequisitesCSE1OOF OR CSE1PE

Co-requisitesN/A

Incompatible subjects CSE4DBF AND students admitted in any Graduate Diploma or Masters by Coursework course

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. Apply a database modelling technique using an ER and EER diagram, and use a transformation process to change these to a relational database design.
02. Identify the appropriate normalization techniques for database design.
03. Implement a database system using SQL and apply the relevant knowledge in database management and administration.
04. Define the underlying model of relational database operations using relational algebra.
05. Identify the possible risks and ethical and social considerations relevant to a designed system.

Subject options

Select to view your study options…

Start date between: and    Key dates

Melbourne (Bundoora), 2021, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

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

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3

On-Line, 2021, Semester 1, Online

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 10 - 22
One 2.00 h laboratory class per week on weekdays during the day from week 10 to week 22 and delivered via online.

LectureWeek: 10 - 22
Two 1.00 h lecture per week on weekends during the day from week 10 to week 22 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Assignment 1_Part 1 (200 words equivalent)

N/AAssignmentIndividualNo10 SILO1

Assignment 1_Part 2 (200 words equivalent)

N/AAssignmentIndividualNo10 SILO1

Assignment 2 (400 words equivalent)

N/AAssignmentIndividualNo20 SILO3

Final centrally scheduled exam (5 Hours) (3000 words equivalent)

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Sydney, 2021, Semester 1, Day

Overview

Online enrolmentNo

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

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

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3

Bendigo, 2021, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorRichard Skarbez

Class requirements

Laboratory ClassWeek: 30 - 42
One 2.00 h laboratory class per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

LectureWeek: 30 - 42
One 2.00 h lecture per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3

Melbourne (Bundoora), 2021, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 30 - 42
One 2.00 h laboratory class 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 h lecture per week on weekdays during the day from week 30 to week 42 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3

On-Line, 2021, Semester 2, Online

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 30 - 42
One 2.00 h laboratory class per week on weekdays during the day from week 30 to week 42 and delivered via online.

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

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Assignment 1_Part 1 (200 words equivalent)

N/AAssignmentIndividualNo10 SILO1

Assignment 1_Part 2 (200 words equivalent)

N/AAssignmentIndividualNo10 SILO1

Assignment 2 (400 words equivalent)

N/AAssignmentIndividualNo20 SILO3

Final centrally scheduled exam (5 Hours) (3000 words equivalent)

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Sydney, 2021, Semester 2, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 31 - 42
One 2.00 h 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 h lecture per week on weekdays during the day from week 31 to week 42 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3

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

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorRichard Skarbez

Class requirements

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

LectureWeek: 2 - 7
Four 1.00 h lecture per week on weekdays during the day from week 2 to week 7 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3

Sydney, 2021, Summer, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorLianhua Chi

Class requirements

Laboratory ClassWeek: 46 - 6
One 2.00 h laboratory class per week on weekdays during the day from week 46 to week 6 and delivered via face-to-face.

LectureWeek: 46 - 6
Two 1.00 h lecture per week on weekdays during the day from week 46 to week 6 and delivered via face-to-face.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

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

N/ACentral examIndividualYes60 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment 1 - One database design assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO1

Assignment 2 - One database programming assignment (400-words equivalent)

N/AAssignmentIndividualNo20 SILO3