cse3dms database management systems
DATABASE MANAGEMENT SYSTEMS
CSE3DMS
2020
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
Subject options
Select to view your study options…
Melbourne (Bundoora), 2020, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorJinli Cao
Class requirements
Computer LaboratoryWeek: 11 - 22
One 2.00 hours 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 hours 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 2-hour examination Hurdle requirement: To pass the subject, a pass in the examination is mandatory. | N/A | N/A | Yes | 50 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
| One assignment - database query performance analysis (equivalent to 1000 words) | N/A | N/A | No | 30 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
| Ten short written answers to set questions (equivalent to 1000 words in total) | N/A | N/A | No | 20 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
Chisholm 311 (Chisholm Institute), 2020, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorJinli Cao
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
One 2.00 hours 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 2-hour examination Hurdle requirement: To pass the subject, a pass in the examination is mandatory. | N/A | N/A | Yes | 50 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
| One assignment - database query performance analysis (equivalent to 1000 words) | N/A | N/A | No | 30 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
| Ten short written answers to set questions (equivalent to 1000 words in total) | N/A | N/A | No | 20 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
Dandenong (Chisholm Institute), 2020, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Subject Instance Co-ordinatorJinli Cao
Class requirements
Computer LaboratoryWeek: 11 - 22
One 2.00 hours 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 hours 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 2-hour examination Hurdle requirement: To pass the subject, a pass in the examination is mandatory. | N/A | N/A | Yes | 50 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
| One assignment - database query performance analysis (equivalent to 1000 words) | N/A | N/A | No | 30 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |
| Ten short written answers to set questions (equivalent to 1000 words in total) | N/A | N/A | No | 20 | SILO1, SILO2, SILO3, SILO4, SILO5, SILO6 |