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.
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):
See also Unit timetable information
Pre-lecture reading and attempting exercises is a wise thing for all students to do. Students can expect this to be assessed.
Important: Please see the "Other" section at the end of this Unit Guide for more details.
BUS3112, CPE2005, CSE2132, CSE2138, CSE2316, CSE3180, CSE3316, FIT2010, GCO2815, IMS1907, IMS2112, MMS2801
Deepti Mishra
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
Based on previous student feedback this unit is considered to be well structured and no significant changes have been made for this semester.
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: http://moodle.vle.monash.edu/ | No formal assessment or activities are undertaken in week 0 |
| 1 | Introduction to Data Management (and Peer Instruction) | Peer Instruction Participation is assessed weekly during lectures |
| 2 | Relational Model | Pre-lecture Quiz Questions due weekly prior to the lecture (Weeks 2 to 11), Peer Instruction Participation due weekly (Weeks 2 to 11) |
| 3 | SQL Data Definition | |
| 4 | SQL Query 1 - single and multiple tables retrieval | |
| 5 | SQL Query 2 - aggregate function and group by clause | |
| 6 | SQL Query 3 - subquery and Oracle function | Unit Test 1 (in the tutorial timeslots) |
| 7 | Oracle Triggers | |
| 8 | Database Design 1 - Design Process and Conceptual Modeling | Unit Test 2 (in the tutorial timeslots) |
| 9 | Database Design 2 - Logical Modelling | |
| 10 | Databaase Design 3 - Normalisation | Assignment 1 (Part A): Initial Conceptual Design. |
| 11 | Transactions Management and Database Maintenance | |
| 12 | Current trends in database management and exam preparation | Assignment 1 (Part B): Full Database Design |
| 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% | Weekly. The exact due date will be announced as Moodle's quiz notification. |
| Peer Instruction Participation | 5% | On campus: during weekly lectures (Weeks 2 to 11), off campus: weekly on Tuesday (Weeks 2 to 11) |
| Unit Test 1 | 10 % | Conducted in the tutorials in Week 6 |
| Unit Test 2 | 10 % | Conducted in the tutorials in Week 8 |
| Assignment 1 (Part A): Initial Conceptual Design | Hurdle to the submission of Assignment 1 (Part B) | Week 10 |
| Assignment 1 (Part B): Full Database Design | 20% | Week 12 |
| 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/
Correctness of the answers. The mark is the average mark of all the quizzes.
Active participation in lecture sessions using the response systems is expected. 5% of the final marks is allocated for this participation. The mark will be allocated based on the percentage of attended lecture sessions from week 2 to 11 (10 weeks). A student is considered attending the lecture if he/she provided responses at least 50% to the available questions on that session.
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 1 (Part B).
Task Criteria:
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 Examiner's discretion, students may be permitted to resubmit assignments where serious medical issues or problems have impacted a student's 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.
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.
Software
If students wish to work on this unit from home, you will require a copy of SQL Developer. Please see the links below in Recommended Resources. Both items of software should be both readily available and free of charge - and it is suggested you obtain a copy from the Moodle unit web site.
Textbook
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 .
Limited copies of prescribed texts are available for you to borrow in the library.
Coronel, C. and Morris, S. (2014). Database Systems. (11th Edition) Cengage Learning.
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:
Additional Recommended Learning Materials will be listed on the unit's Moodle site.
On-Campus (Clayton, Caulfield) 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
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/.
Getting the most from your studies in this unit:
Lecture: During the lecture, your lecturer will conduct the peer instruction session.
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.
This unit is a core unit in the Bachelor of Software Engineering accredited by Engineers Australia. Engineers Australia Accreditation Policy of Professional Engineering Programs requires that programs demonstrate how engineering graduates are prepared for entry to the profession and achieve Stage 1 competencies. The following information describes how this unit contributes to the development of these competencies for the Bachelor of Software Engineering. (Note: not all competencies may be emphasised in this unit).
| Stage 1 competency | How the compency is developed in this unit |
| 1. Knowledge and Skills base | |
| 1.1. Comprehension, theory based understanding of the underpinning natural and physical sciences and the engineering fundamentals applicable to the engineering discipline. | Theoretical lecture materials, prescribed texts and recommended readings, tutorials and assignment tasks to cover the fundamental knowledge of database as part of the required Software Engineering Body of Knowledge (SWEBOK). |
| 1.2. Conceptual understanding of the mathematics, numerical analysis, statistics, and computer and information sciences, which underpin the engineering discipline. | Theoretical materials covered in lectures, lab exercises and assignment to construct and develop databases logically. |
| 1.3. In-depth understanding of specialist bodies of knowledge within the engineering discipline. | Applies database techniques in lab exercises and assignment to construct databases. |
| 1.4. Discernment of knowledge development and research directions within th engineering discipline. | Not covered in this unit. |
|
1.5. Knowledge of engineering design practice and contextual factors impacting the engineering discipline. |
Using lecture material, lab exercises and assignment to understand the motivation of learning and using databases in the context of software development and software engineering. |
| 1.6. Understanding of the scope, principles, norms, accountabilities and bounds of sustainable engineering practice in the specific discipline. | Not covered in this unit. |
| 2. Engineering application ability | |
| 2.1. Application of established engineering methods to complex engineering problem solving. | Not covered in this unit. |
| 2.2 Fluent application of engineering techniques, tools and resources. | Not covered in this unit. |
| 2.3. Application of systematic engineering synthesis and design processes. | Not covered in this unit. |
| 2.4. Application of systematic approaches to the conduct and management of engineering projects. | Not covered in this unit. |
| 3. Professional and personal attributes | |
| 3.1. Ethical conduct and professional accountability. | Not covered in this unit. |
| 3.2. Effective oral and written communication in professional and lay domains. | Assignment and lab exercises require students to produce written work. They are interviewed and asked questions about their submissions requiring them to provide answers verbally to the tutor’s questions. |
| 3.3. Creative, innovative and proactive demeanour. | Analyse the database requirements and then design the databases in lab classes and in their assignment. The exercises’ focus is inherently a creative activity and this aspect is reinforced in lectures, lab classes and assignment. |
| 3.4. Professional use and management of information. | Not covered in this unit. |
| 3.5. Orderly management of self, and professional conduct. | Acting and behaving in an ethical way as a student during lab classes and assignment while developing the solutions. |
| 3.6. Effective team membership and team leadership. | Not covered in this unit. |
| No. | CO 1 | CO 2 | CO 3 | CO 4 | CO 5 | CO 6 | CO 7 | C0 8 | CO 9 | CO 10 | CO 11 | CO 12 | CO 13 |
| 1 | X | X | |||||||||||
| 2 | X | X | X | X | X | X | |||||||
| 3 | X | X | X | X | X | ||||||||
| 4 | X | X | X | X | X | X | |||||||
| 5 | X | X | X | X | X | X | |||||||
| No. | Assignments | Tests | Practical Exercises | Exam |
| 1 | X | X | X | |
| 2 | X | X | X | X |
| 3 | X | X | ||
| 4 | X | X | X | |
| 5 | X | X | X | X |