This unit will introduce the concept of data management in an organisation through relational database technology. Theoretical foundation of relational model, analysis and design, implementation of relational database using SQL will be covered.
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):
FIT9003, FIT9019
Lindsay Smith
Consultation hours: To be advised
Nik Nailah
Consultation hours: To be advised
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 | Introduction | Peer Instruction Participation and Quiz Completion will be due throughout the semester. |
| 2 | Relational Data Model | |
| 3 | SQL data definition and data manipulation | |
| 4 | SQL Query 1 - single and multi-tables retrieval | |
| 5 | SQL Query 2 - aggregate function and group by clause | Assignment 1, Friday, 29th August 2014, 10 PM |
| 6 | SQL Query 3 - subquery and Oracle function | |
| 7 | Oracle Triggers | |
| 8 | Conceptual Modelling | |
| 9 | Logical data modelling | Assignment 2, Friday, 26th September 2014, 10 PM |
| 10 | Normalisation | Assignment 3 Part A, Friday, 10th October 2014, 10 PM |
| 11 | Transaction and Database maintenance | |
| 12 | Current trends in database management and exam preparation | Assignment 3 Part B, Friday, 24th October 2014, 10 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 (2 hours): 50%; In-semester assessment: 50%
| Assessment Task | Value | Due Date |
|---|---|---|
| Pre-lecture online quizzes | 5% | Weekly. The exact due date will be announced as Moodle's quiz notification. |
| Peer Instruction Participation in Lecture Sessions | 5% | Weekly. Lecture sessions in week 2-11. |
| Assignment 1 - SQL Data Definition and Data Manipulation | 10% | Friday, 29th August 2014, 10 PM |
| Assignment 2 - SQL Data Retrieval | 15% | Friday, 26th September 2014, 10 PM |
| Assignment 3 Part A - Initial Conceptual Design | Hurdle to the submission of Assignment 3 Part B | Friday, 10th October 2014, 10 PM |
| Assignment 3 Part B - Full Design | 15% | Friday, 24th October 2014, 10 PM |
| Examination 1 | 50% | 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/
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:
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 Part B.
Task Criteria:
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.
Limited copies of prescribed texts are available for you to borrow in the library.
Coronel, C and Morris, S. . (2015, 2013). Database Systems - Design, Implementation and Management 11e. (11th Edition) Cengage Learning.
This unit will make use of the Oracle 11G database running on the Monash ITS server hippo.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:
On Campus students are required to purchase a Turning Point clicker from the Campus Bookstore or directly from the Australian Distributor.
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/.