DATABASE MANAGEMENT SYSTEMS

CSE3DMS

2021

Credit points: 15

Subject outline

This subject covers the important knowledge and concepts of database management systems. The techniques of various indexes including B+Trees, Bitmap, static and dynamic hashing indexes used for database organisations are studied. The algorithms for query processing and optimisation to improve performance of the database systems are detailed. Principles and theories of database management such as transaction management, serializability, recoverability, concurrency control algorithms and recovery techniques are covered. This subject is also including the advanced database programming SQL such as advanced procedures, functions, transactions, Oracle optimizer, execution plans for query optimization, hint, auto-trace and indexes etc. Physical database design issues and tuning techniques are extensively studied and discussed.

SchoolEngineering and Mathematical Sciences

Credit points15

Subject Co-ordinatorJinli Cao

Available to Study Abroad/Exchange StudentsYes

Subject year levelYear Level 3 - UG

Available as ElectiveNo

Learning ActivitiesN/A

Capstone subjectNo

Subject particulars

Subject rules

PrerequisitesCSE2DBF

Co-requisitesN/A

Incompatible subjectsN/A

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. Explain the steps for developing database applications and Advance SQL programming under Oracle DB environment.
02. Explain database management systems, file organisations and Index techniques
03. Improve database performance through database design tuning and the database queries tuning
04. Perform the analysis of optimisation on database queries
05. Explain the principle of transaction management design for concurrency control and recovery algorithms
06. Develop effective high quality database queries using knowledge and skills learned in this unit

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-ordinatorJinli Cao

Class requirements

Computer LaboratoryWeek: 11 - 22
One 2.00 h computer laboratory per week on weekdays during the day from week 11 to week 22 and delivered via face-to-face.

LectureWeek: 10 - 22
One 2.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 2-hour examinationHurdle Requirement: To pass the subject, a pass in the examination is mandatory.

N/ACentral examIndividualYes50 SILO2, SILO3, SILO4, SILO5

One assignment - Database query performance analysis (equivalent to 1000 words)

N/AAssignmentIndividualNo30 SILO1, SILO2, SILO3, SILO4, SILO6

Ten short written answers to set questions (equivalent to 1000 words in total)

N/AN/AIndividualNo20 SILO1, SILO2, SILO3, SILO4, SILO5, SILO6

Chisholm 311 (Chisholm Institute), 2021, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer LaboratoryWeek: 10 - 22
One 2.00 h computer laboratory per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.

LectureWeek: 10 - 22
One 2.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 2-hour examinationHurdle Requirement: To pass the subject, a pass in the examination is mandatory.

N/ACentral examIndividualYes50 SILO2, SILO3, SILO4, SILO5

One assignment - Database query performance analysis (equivalent to 1000 words)

N/AAssignmentIndividualNo30 SILO1, SILO2, SILO3, SILO4, SILO6

Ten short written answers to set questions (equivalent to 1000 words in total)

N/AN/AIndividualNo20 SILO1, SILO2, SILO3, SILO4, SILO5, SILO6

Dandenong (Chisholm Institute), 2021, Semester 1, Day

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer LaboratoryWeek: 11 - 22
One 2.00 h computer laboratory per week on weekdays during the day from week 11 to week 22 and delivered via face-to-face.

LectureWeek: 10 - 22
One 2.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 2-hour examinationHurdle Requirement: To pass the subject, a pass in the examination is mandatory.

N/ACentral examIndividualYes50 SILO2, SILO3, SILO4, SILO5

One assignment - Database query performance analysis (equivalent to 1000 words)

N/AAssignmentIndividualNo30 SILO1, SILO2, SILO3, SILO4, SILO6

Ten short written answers to set questions (equivalent to 1000 words in total)

N/AN/AIndividualNo20 SILO1, SILO2, SILO3, SILO4, SILO5, SILO6

On-Line, 2021, Semester 1, Online

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer LaboratoryWeek: 10 - 22
One 2.00 h computer laboratory per week on weekdays during the day from week 10 to week 22 and delivered via online.

LectureWeek: 11 - 22
One 2.00 h lecture per week on weekdays during the day from week 11 to week 22 and delivered via online.

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Weekly lab assessment for 10 weeks (equivalent to 1000 words in total)

N/AAssignmentIndividualNo20 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment (equivalent to 1000 words)

N/AAssignmentIndividualNo30 SILO1, SILO2, SILO3, SILO4, SILO6

Final centrally scheduled exam (2.5 Hours) (equivalent to 2000 words in total)

N/ACentral examIndividualNo50 SILO2, SILO3, SILO4, SILO5

On-Line, 2021, Semester 2, Online

Overview

Online enrolmentYes

Maximum enrolment sizeN/A

Subject Instance Co-ordinatorJinli Cao

Class requirements

Computer LaboratoryWeek: 31 - 42
One 2.00 h computer laboratory per week on weekdays during the day from week 31 to week 42 and delivered via online.

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

Assessments

Assessment elementCommentsCategoryContributionHurdle% ILO*

Weekly lab assessment for 10 weeks (equivalent to 1000 words in total)

N/AAssignmentIndividualNo20 SILO1, SILO2, SILO3, SILO4, SILO5

Assignment (equivalent to 1000 words)

N/AAssignmentIndividualNo30 SILO1, SILO2, SILO3, SILO4, SILO6

Final centrally scheduled exam (2.5 Hours) (equivalent to 2000 words in total)

N/ACentral examIndividualNo50 SILO2, SILO3, SILO4, SILO5