This unit extends the study from FIT1004 Data management. FIT2077 will introduce more advanced concepts in the areas of database design, SQL, query optimisation and the handling of unstructured data (XML) both externally and within a database. The issue of "Big Data" and the role played by BI technologies and data warehouses will be explored.
Minimum total expected workload equals 12 hours per week comprising:
(a.) Contact hours for on-campus students:
(b.) Additional requirements (all students):
See also Unit timetable information
CSE3000, FIT3118, FIT4038
FIT1004 or CSE2132 or equivalent
Lindsay Smith
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
In response to the last SETU of this unit, the following changes have been made:
Student feedback has highlighted the following strength(s) in this unit:
If you wish to view how previous students rated this unit, please go to
https://emuapps.monash.edu.au/unitevaluations/index.jsp
| Week | Activities | Assessment |
|---|---|---|
| 0 | Please check the Moodle site | No formal assessment or activities are undertaken in week 0 |
| 1 | Entity Relationship Model Review | |
| 2 | Advanced Data Modelling | |
| 3 | SQL Review | |
| 4 | PL/SQL Triggers | |
| 5 | PL/SQL Procedures and Functions | Lab Task 1 due (10 marks) |
| 6 | Unstructured Data - XML documents | |
| 7 | XML Schemas | |
| 8 | XML in the database | Lab Task 2 due (15 marks) |
| 9 | Relational Algebra and SQL Relational set operators | |
| 10 | File Organisation and Query Algorithms | |
| 11 | Tuning and Query Optimisation | Lab Task 3 due (15 marks) |
| 12 | Big Data and noSQL | |
| 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 |
|---|---|---|
| Lab Task 1 - EERM Design | 10% | Thursday 2nd April 2015 |
| Lab Task 2 - Advanced SQL | 15% | Thursday 30th April 2015 |
| Lab Task 3 - Unstructured Data | 15% | Thursday 21st May 2015 |
| 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/
Monash Library Unit Reading List (if applicable to the unit)
http://readinglists.lib.monash.edu/index.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
At the Chief Examiners discretion, students may be permitted to resubmit assignments where serious medical issues or other problems have impacted a students work.
Students are required to use the APA style of referencing for this unit, details are available from:
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 electronic submission). Please note that it is your responsibility to retain copies of your assessments.
If Electronic Submission has been approved for your unit, please submit your work via the learning system for this unit, which you can access via links in the my.monash portal.
Limited copies of prescribed texts are available for you to borrow in the library.
Coronel, C and Morris, S. (2015). Database Systems: Design, Implementation, and Management. (11th Edition) Cengage Learning (ISBN: 1-285-19164-7).
Students are required to check regularly check Moodle for announcements and updates to unit material. Sudents who own a laptop (Mac or Windows) may install the unit software on their own machine and may use the laptop in class.
This unit will make use of the Oracle 11G database running on the Monash ITS server hippo.its.monash.edu. All students will have an account on this server which will suffice for all database work this semester.
Although it is not required, if students wish to run a database server at home they can download Oracle XE (eXpress Edition) from the unit Moodle site or directly from the Oracle technet site:
Please note:
The client software for accessing Oracle (SQLDeveloper) will be available in the labs. It will also be available via a download from the Moodle site for installation at home. SQLDeveloper is also available, after registration (free), from the technet site:
Elmasri, R and Navathe, S. (2011). Fundamentals of Database Systems. (6th Edition) Addison-Wesley (ISBN: 0136086209).
Carey, P. (2007). XML 2nd Edition Comprehensive. (2nd Edition) Cengage Learning.
Notes, texts, resource material and calculators may be taken into the examination. Computers are not permitted.
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
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/.