This unit looks at the design and implementation issues of database management systems. Advanced database design using multi-dimensional database design and semi-structured database design are explored. Online analytical query language will be explored in the context of multi-dimensional database design. Query optimisation and tuning will be explored, as well as semi-structure database design and query processing.
Minimum total expected workload equals 12 hours per week comprising:
(a.) Contact hours for on-campus students:
(b.) Study schedule for off-campus students:
(c.) Additional requirements (all students):
FIT4038
(FIT5132 or FIT9003 or FIT9019) or equivalent
Knowledge of relational database principles, including SQL.
Associate Professor David Taniar
Jessica Sin
Kefeng Xuan
Monash is committed to excellence in education and regularly seeks feedback from students, employers and staff. One of the key formal ways students have to provide feedback is through the Student Evaluation of Teaching and Units (SETU) survey. The University’s student evaluation policy requires that every unit is evaluated each year. Students are strongly encouraged to complete the surveys. The feedback is anonymous and provides the Faculty with evidence of aspects that students are satisfied and areas for improvement.
For more information on Monash’s educational strategy, see:
www.monash.edu.au/about/monash-directions/ and on student evaluations, see: www.policy.monash.edu/policy-bank/academic/education/quality/student-evaluation-policy.html
| Week | Activities | Assessment |
|---|---|---|
| 0 | No formal assessment or activities are undertaken in week 0 | |
| 1 | Multidimensional Database Design: Introduction | |
| 2 | Multidimensional Database Design: Modelling | |
| 3 | Multidimensional Database Design: Modelling (Advanced) | |
| 4 | Multidimensional Database Design: Queries | |
| 5 | Multidimensional Database Design: Dimension Modelling | |
| 6 | Multidimensional Database Design: Bridge Tables and Temporal | |
| 7 | Multidimensional Database Design: Bridge Tables and Temporal | Class Test: Wednesday 16-Apr-2014, 6-8pm |
| 8 | Multidimensional Database Design: Bridge Tables and Temporal | |
| 9 | Physical Database Design: Query Processing | |
| 10 | Physical Database Design: Query Tuning | |
| 11 | Semi-structured Database Design | |
| 12 | Semi-structured Database Design | Assignment due date: Tuesday 27-May-2014, 6pm |
| SWOT VAC | No formal assessment is undertaken in SWOT VAC | |
| Examination period | LINK to Assessment Policy: http://policy.monash.edu.au/policy-bank/ academic/education/assessment/ assessment-in-coursework-policy.html |
*Unit Schedule details will be maintained and communicated to you via your learning system.
Examination (3 hours): 60%; In-semester assessment: 40%
| Assessment Task | Value | Due Date |
|---|---|---|
| Class Test | 10% | Wednesday 16-Apr-2014, 6-8pm |
| Assignment | 30% | Tuesday 27-May-2014, 6pm |
| Examination 1 | 60% | To be advised |
Faculty Policy - Unit Assessment Hurdles (http://intranet.monash.edu.au/infotech/resources/staff/edgov/policies/assessment-examinations/assessment-hurdles.html)
Academic Integrity - Please see resources and tutorials at http://www.monash.edu/library/skills/resources/tutorials/academic-integrity/
Students will be assessed on their understanding of multidimensional design, object-relational design, and physical database design.
Students will be assessed on their understanding of multidimensional design, and physical database design.
Database Systems: Design, Implementation and Management, Rob, and Coronel, 8th Edition, Course Technology, 2007, chapter on Data Warehousing
Fundamentals of Database Systems, Elmasri, and Navathe, 5th Edition, Addison Wesley, 2007, chapter on Indexing
Monash Library Unit Reading List (if applicable to the unit)
http://readinglists.lib.monash.edu/index.html
Faculty of Information Technology Style Guide
Examination/other end-of-semester assessment feedback may take the form of feedback classes, provision of sample answers or other group feedback after official results have been published. Please check with your lecturer on the feedback provided and take advantage of this prior to requesting individual consultations with staff. If your unit has an examination, you may request to view your examination script booklet, see http://intranet.monash.edu.au/infotech/resources/students/procedures/request-to-view-exam-scripts.html
Types of feedback you can expect to receive in this unit are:
Submission must be made by the due date otherwise penalties will be enforced.
You must negotiate any extensions formally with your campus unit leader via the in-semester special consideration process: http://www.monash.edu.au/exams/special-consideration.html
It is a University requirement (http://www.policy.monash.edu/policy-bank/academic/education/conduct/student-academic-integrity-managing-plagiarism-collusion-procedures.html) for students to submit an assignment coversheet for each assessment item. Faculty Assignment coversheets can be found at http://www.infotech.monash.edu.au/resources/student/forms/. Please check with your Lecturer on the submission method for your assignment coversheet (e.g. attach a file to the online assignment submission, hand-in a hard copy, or use an online quiz). Please note that it is your responsibility to retain copies of your assessments.
Monash has educational policies, procedures and guidelines, which are designed to ensure that staff and students are aware of the University’s academic standards, and to provide advice on how they might uphold them. You can find Monash’s Education Policies at: www.policy.monash.edu.au/policy-bank/academic/education/index.html
Key educational policies include:
Important student resources including Faculty policies are located at http://intranet.monash.edu.au/infotech/resources/students/
The University provides many different kinds of support services for you. Contact your tutor if you need advice and see the range of services available at http://www.monash.edu.au/students. For Malaysia see http://www.monash.edu.my/Student-services, and for South Africa see http://www.monash.ac.za/current/.
The Monash University Library provides a range of services, resources and programs that enable you to save time and be more effective in your learning and research. Go to www.lib.monash.edu.au or the library tab in my.monash portal for more information. At Malaysia, visit the Library and Learning Commons at http://www.lib.monash.edu.my/. At South Africa visit http://www.lib.monash.ac.za/.