This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. Students will develop skills in planning, designing, and implementing a data model using an enterprise-scale relational database system (Oracle). Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.
Manipulation of a database necessarily raises issues of data collection/creation and management, data rights (ownership, copyright, access, privacy etc) and data curation, which this unit will also address.
2 hrs lectures/wk, 2 hrs laboratories/wk
Students will be expected to spend a total of 12 hours per week during semester on this unit as follows:
The pre-lecture reading and answering online quizzes are very important in this unit due to the adoption of peer instruction method in the lecture for this unit.
BUS3112, CPE2005, CSE2132, CSE2138, CSE2316, CSE3180, CSE3316, FIT2010, GCO2815, IMS1907, IMS2112, MMS2801
Maria Indrawan-Santiago
| Week | Activities | Assessment |
|---|---|---|
| 0 | Please check the Moodle 2 site: http://moodle.vle.monash.edu/ | No formal assessment is undertaken in week 0 |
| 1 | Introduction to Data Management and Peer Instruction | Assessment task 1: Peer instruction participation and Quiz Completion will be due throughout the semester |
| 2 | Data Quality and Metadata | |
| 3 | Relational Database | |
| 4 | SQL 1 - Data Definition And Populating Database | |
| 5 | SQL 2 - Basic Method Of Retrieving Data From Database | |
| 6 | SQL 3 - Advanced Method Of Retrieving Data From Database | Unit test based on week 4, 10%, at tutorial classes. |
| 7 | No lecture - ANZAC day | |
| 8 | Conceptual Design | Unit test based on week 5, 5%, at tutorial classes. |
| 9 | Logical And Physical Design | Unit test based on week 6, 10%, at tutorial classes. |
| 10 | Normalisation | Assignment 1A Due, Monday 13th May 2013, 11 PM. |
| 11 | Transaction Management 1 | |
| 12 | Transaction Management 2 | Assignment 1B Due. Friday 31st May 2013, 11 PM. |
| 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): 50%; In-semester assessment: 50%
| Assessment Task | Value | Due Date |
|---|---|---|
| Pre-lecture online quizzes | 5% | Every Wednesday prior to lecture day, 11 PM. |
| Peer Instruction Participation in Lecture Sessions | 5% | Every lecture session |
| Unit Test 1 - SQL Data definition and populating database | 10% | Tutorial classes in week 6. |
| Unit Test 2 - SQL Basic method of retrieving data from database. | 5% | Tutorial classes in week 8. |
| Unit Test 3 - SQL Advanced method of retrieving data from database. | 10% | Tutorial classes in week 9. |
| Assignment 1 Part A: Initial Conceptual Design | Hurdle to the submission of Assignment 1B | Monday, 13th May 2013, 11 PM |
| Assignment 1 Part B: Full Database Design | 15% | Friday, 31st may 2013, 11 PM |
| Examination 1 | 50% | To be advised |
Faculty Policy - Unit Assessment Hurdles (http://www.infotech.monash.edu.au/resources/staff/edgov/policies/assessment-examinations/unit-assessment-hurdles.html)
Academic Integrity - Please see the Demystifying Citing and Referencing tutorial at http://lib.monash.edu/tutorials/citing/
The average marks across a number of quizzes from week 2 to week 12.
Student's answer during the peer instruciton session will not be graded based on correctly answering questions. The grade will be based on participation. A full mark will be awarded if student answers at least 80% of the questions throughout the semester. 0 mark will be awarded if student answers less than 80% of total questions presented in the semester during lecture.
Task Criteria:
Task Criteria:
Task Criteria:
Student designs will not be graded. Tutors will discuss with each student individually during tutorials their submitted design, against the case study, as a first stage of the database design task. This task is a hurdle requirement, students who do not submit this task will not be able to submit assignment 3.
Task Criteria:
Monash Library Unit Reading List
http://readinglists.lib.monash.edu/index.html
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.infotech.monash.edu.au/resources/student/equity/special-consideration.html.
At the Chief Examiners discretion, students may be permitted to resubmit assignments where serious medical issues or 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/plagiarism-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 submit your work via the learning system for this unit, which you can access via links in the my.monash portal.
Please check with your lecturer before purchasing any Required Resources. Limited copies of prescribed texts are available for you to borrow in the library, and prescribed software is available in student labs.
If students wish to work on this unit from home, you will require a copy of SQL Developer and Power*Architect please see the links below in Recommended Resources. Both items of software are readily available and free of charge (it is suggested you obtain a copy from the Moodle unit web site).
TEXTBOOK
Rob, P., Morris, S. and Coronel, C., Database Systems 10th Edn., Cengage Learning, 2013
This text is available from the Monash University Book Shops. Availability from other suppliers cannot be assured. The Bookshop orders texts in specifically for this unit. You are advised to purchase your text book early.
The text is also available as an eBook from Cengage Learning. The URL to the eBook version on the Cengage site is: http://www.cengagebrain.com.au/. The Cengage (CourseSmart) book format is HTML5 and thus can be read on a range of devices, markup (notes and highlighting) and a number of other functions are possible. The eReader FAQ is available from:http://www.cengagebrain.com.au/shop/FAQ.html
This unit will make use of the Oracle 11G database running on the Monash ITS server zebra.its.monash.edu.au. 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:
For database Design we will be making use of the community edition of Power*Architect (version 1.06) developed by SQLPower:
Power*Architect will also be available in the labs, for download from the Moodle site and can be downloaded directly from the link above.
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:
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 Sunway 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 Sunway, visit the Library and Learning Commons at http://www.lib.monash.edu.my/. At South Africa visit http://www.lib.monash.ac.za/.
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
Student feedback from the semester 2 2011 offering indicated some difficulties with the management of groups for the group assignment tasks (assignments 2 and 3). For this offering we will be trialling individual assignments for assignments 2 and 3 in response to these comments. The tasks for the two assignments will be adjusted to take into consideration this change.
In addition for this offering the ordering of the two major sections of the unit have been adjusted to allow students longer to gain familiarity with SQL.
If you wish to view how previous students rated this unit, please go to
https://emuapps.monash.edu.au/unitevaluations/index.jsp
Getting the most from your studies in this unit:
Lecture: During the lecture, your lecturer will introduce key theoretical concepts and demonstrate various approaches to data management tasks. The time in lectures is quite brief, please ensure you gain the best advantage from this time by:
Laboratory/Tutorials: The labs consist of a set of graded exercises which allow you to put the theory presented in the lecture to work in creating, designing and using data and databases. The labs will also include issues that you will need to discuss with your fellow classmates and tutors. Before the lab you should carefully read through the lab activities. The teaching staff will presume that you have completed all the posted lab tasks each week and build subsequent activities on this assumption. For this reason it is very important that you complete all the posted tasks (please note you will not be able to complete them in the allocated 2 hours, these will be completed in your self study 8 hours). Given the cumulative nature of the learning, it is easy to fall behind if either you do not complete the required work or fail to understand key tasks/concepts. If you are having problems with lab exercises, please ensure you speak to your tutor and gain some assistance.
Off Campus students: Off campus students should pay particular attention to the Moodle OCL discussion forum for matters specifically related to them.