FIT1004 Data management - Semester 2, 2013

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.

Mode of Delivery

• Clayton (Day)
• Gippsland (Off-campus)
• Sunway (Day)
• South Africa (Day)

Contact Hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Workload requirements

Students will be expected to spend a total of 12 hours per week during semester on this unit as follows:

For On-campus students:

• two hours of lectures,
• two hours of laboratory/tutorial (requiring advance preparation), and
• eight hours of self directed study - this will include completing lab exercises, further reading, review, preparing assignments.

Off-campus students generally do not attend lecture and tutorial sessions, however, they should plan to spend equivalent time working through the relevant resources and participating in discussion groups each week.

Pre-lecture reading is a wise thing for all students to do. 

Unit Relationships

Prohibitions

BUS3112, CPE2005, CSE2132, CSE2138, CSE2316, CSE3180, CSE3316, FIT2010, GCO2815, IMS1907, IMS2112, MMS2801

Chief Examiner

Campus Lecturer

Tutors

Academic Overview

Learning Outcomes

• the major objectives of database technology;
• the relational model for databases and competing models;
• the phases of the database development life cycle and their correspondence to the phases of the system development lifecycle;
• the issues related to data creation and management, data rights and data curation;
• the techniques and tools to design and implement a database suitable for an information system;
• a database retrieval and manipulation language;
• methods to put in place physical structures to permit efficient operation of a database;
• the role of a database administrator.

• appreciate the privacy issues relating to storage of data in a database;
• practice ethical behaviour when developing, implementing and using a database.

Unit Schedule

*Unit Schedule details will be maintained and communicated to you via your learning system.

Assessment Summary

Examination (3 hours): 50%; In-semester assessment: 50%

Teaching Approach

Assessment Requirements

Assessment Policy

Faculty Policy - Unit Assessment Hurdles (http://intranet.monash.edu.au/infotech/resources/staff/edgov/policies/assessment-examinations/assessment-hurdles.html)

Academic Integrity - Please see the Demystifying Citing and Referencing tutorial at http://lib.monash.edu/tutorials/citing/

Assessment Tasks

Participation

• Assessment task 1

  Title:

  Assignment 1: Data Collection and Markup

  Description:

  This task, which will be carried out partially during the lab time, will involve the collection of a set of data on a specified topic. The collected data will be required to be marked up using an appropriate document standard. This task is a individual assessment task - each student will collect and markup their own data.

  Weighting:

  5%

  Criteria for assessment:

  Task criteria:

  1. Correct data researched and collected, including acknowledgement of sources
  2. Appropriate markup used to record the data

  Due date:

  4PM Friday 16 August 2013

• Assessment task 2

  Title:

  Assignment 2: Database Manipulation

  Description:

  Students will be supplied with a database design via a schema file and asked to create the database under Oracle. The created database will be populated with appropriate student generated data and then used to develop a set of SQL queries and triggers.

  Weighting:

  20%

  Criteria for assessment:

  Task criteria:

  1. Student data must insert correctly and result in a consistent database state
  2. SQL queries must execute correctly and produce correct visible output
  3. Coded PL/SQL triggers must compile and meet the problem specifications
  4. Design modifications must execute correctly and meet the problem specifications

  Due date:

  4PM Friday 20 September 2013

• Assessment task 3

  Title:

  Assignment 3 Part A: Conceptual Design

  Description:

  Students will be supplied with a case study and asked to model this using Entity Relationship modelling. This part of assignment 3 will require the submission of a "beginning" conceptual design.

  Weighting:

  Hurdle to the submission of Assignment 3B

  Criteria for assessment:

  Task Criteria:

  • Correct application of SQL statements to create table according to a given database design.
  • Correct application of SQL statements to populate the tables using some sample data.

  Due date:

  10AM Tuesday 8 October 2013

• Assessment task 4

  Title:

  Assignment 3 Part B: Full Database Design

  Description:

  Based on the feedback from assignment 3A and the supplied case study, students will be required to complete the database design and produce a logical model. The final design will be tested by implementing the logical ERD in Oracle via a set of 'create table' statements.
  
  Please note that this assignment will not be available unless you have already submitted assignment 3A.

  Weighting:

  20%

  Criteria for assessment:

  Task Criteria:

  • Correct application of normalisation process with use of dependency diagrams at each normal form
  • Correct Logical ERD model created including - entities, PK's, attributes, relationships (connectivity and participation)
  • Generated Oracle schema file executes correctly against Oracle to produce valid database structure

  Due date:

  4PM Friday 25 October 2013

• Assessment task 5

  Title:

  Tutorial Participation and Quiz Completion

  Description:

  Students will be assessed on participation in tutorial activities and on completion of five topic quizzes which will be made available via the Moodle site during the semester.

  Weighting:

  5%

  Criteria for assessment:

  Participation will be assessed in terms of contributions to group discussions and the level of engagement in tutorial activities.

  Due date:

  Throughout the semester

Examinations

• Examination 1

  Weighting:

  50%

  Length:

  3 hours

  Type (open/closed book):

  Closed book

  Electronic devices allowed in the exam:

  None

Learning resources

Feedback to you

• Informal feedback on progress in labs/tutes
• Graded assignments without comments
• Quiz results
• Solutions to tutes, labs and assignments

Extensions and penalties

Returning assignments

Resubmission of assignments

At the Chief Examiners discretion, students may be permitted to resubmit assignments where serious medical issues or problems have impacted a students work.

Referencing requirements

Students are required to use the APA style of referencing for this unit - details are available from:

• http://www.lib.monash.edu.au/tutorials/citing/apa.html
• http://guides.lib.monash.edu/content.php?pid=88267&sid=656564
• Chapter 10 of the Faculty of Business and Economics Q Manual (http://www.buseco.monash.edu.au/publications/qmanual/qmanual.pdf)

Assignment submission

Online submission

Please submit your work via the learning system for this unit, which you can access via links in the my.monash portal.

Unless informed otherwise, students will submit their assignments in 2 places online (Moodle and Damocles) and also in printed hard copy.

Required Resources

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 Edition, 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

Recommended Resources

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:

• http://www.oracle.com/technology/software/products/database/xe/index.html

Please note:

1. for technet, registration (free) is required, and
2. this is a large download (around 200Mb) and should not be attempted without first consulting your campus lecturer.

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:

• http://www.oracle.com/technology/software/products/sql/index.html

For database Design we will be making use of the community edition of Power*Architect (version 1.06) developed by SQLPower:

• http://code.google.com/p/power-architect/

Power*Architect will also be available in the labs, for download from the Moodle site and can be downloaded directly from the link above.

Other Information

Policies

Graduate Attributes Policy

Student services

Monash University Library

Disability Liaison Unit

Your feedback to Us

Previous Student Evaluations of this Unit

Based on previous student feedback this unit is considered to be well structured and no changes have been made for this semester.

Other

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:

• Prior to the lecture
  • reading the study guide for the appropriate week, and
  • downloading and reading the lecture slides,
• During the lecture
  
  • annotate a set of lecture slides as the lecture proceeds, and
  • participate, question, seek clarification 
    
• After the lecture
  • read over your notes and make sure you understand the concepts
  • seek help if you are unsure

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.