FIT1004 Data management - Semester 2, 2015

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

• Caulfield (Day)
• Clayton (Day)
• Clayton (Online)
• Malaysia (Day)
• South Africa (Day)

Workload Requirements

Minimum total expected workload equals 12 hours per week comprising:

(a.) Contact hours for on-campus students:

• Two hours lectures
• Two hours laboratories

(b.) Study schedule for off-campus students:

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

(c.) Additional requirements (all students):

• A minimum of 8 hours independent study per week for completing lab and project work, private study and revision.

See also Unit timetable information

Additional workload requirements

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.

Unit Relationships

Prohibitions

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

Chief Examiner

Campus Lecturer

Tutors

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 significant changes have been made for this semester.

Academic Overview

Learning Outcomes

1. explain the motivations behind the development of database management systems;
2. describe the underlying theoretical basis of the relational database model and apply the theories into practice;
3. develop a sound database design;
4. develop a database based on a sound database design;
5. construct queries that meet user requirements;
6. use data modelling and database development tools effectively.

Unit Schedule

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

Teaching Approach

• Lecture and tutorials or problem classes
  This teaching and learning approach helps students to initially encounter information at lectures, discuss and explore the information during tutorials, and practice in a hands-on lab environment.
• Peer assisted learning
  In this unit, we will use the Peer Assisted learning approach. To maximise the learning experience for students in this approach, students are expected to read the suggested sections from the textbook prior to attending the lecture sessions. The preparation prior to the lecture is CRUCIAL to the successfull participation of students in peer assisted learning during the lecture sessions and getting most of the learning that happens during the lecture.
  
  The concepts and knowledge learnt through self-study prior to the lecture and the lecture sessions will be emphasized and put into practise during the tutorial classes. Students are expected to complete a number of questions and practical exercises during tutorial classes.

Assessment Summary

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

Assessment Requirements

Assessment Policy

Assessment Tasks

Participation

• Assessment task 1

  Title:

  Pre-lecture online quizzes

  Description:

  Learning Outcomes: 1, 2, 3, 4, 5
  
  Students will be asked to complete online quizzes in Moodle based on the prescribed reading of the week from weeks 2 to 11. The due date and time will be posted in Moodle.
  
  

  Weighting:

  5%

  Criteria for assessment:

  Correctness of the answers. The mark is the average mark of all the quizzes.

  Due date:

  Weekly. The exact due date will be announced as Moodle's quiz notification.

• Assessment task 2

  Title:

  Peer Instruction Participation

  Description:

  Learning Outcomes: 1, 2, 3, 4, 5
  
  Participation will be marked during lectures.

  Weighting:

  5%

  Criteria for assessment:

  On campus students:
  
  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. 
  
  Off campus (ONLINE) students:
  
  Throughout the semester, students are expected to submit their answer to a selected weekly (from week 2 to 11) tutorial question to the discussion forum. The weekly due date will be announced in Moodle. 5% of the final marks is allocated for this participation. The mark will be allocated based on the number of submitted work and to certain degree the quality of the attempt.

  Due date:

  On campus: during weekly lectures (Weeks 2 to 11), off campus: weekly on Tuesday (Weeks 2 to 11)

• Assessment task 3

  Title:

  Unit Test 1

  Description:

  Learning Outcomes: 1, 2, 3, 4, 5
  
  This test covers all the topics from week 1 till end of week 4.

  Weighting:

  10 %

  Criteria for assessment:

  Due date:

  Conducted in the tutorials in Week 6

  Remarks:

  On Campus Student:
  
  There will be a number of versions of the unit test, a student may get any one of these version to work on
  
  Off campus (ONLINE) students:
  
  There will be an assignment on  Data Definition and Data Manipulation to be submitted online:
  
  Task Description:Given a database and sample data, students will be required to use Oracle to create tables and populating the tables using appropriate SQL statements.
  
  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.
  • Correct application of SQL statements to make changes to the data according to specification.

• Assessment task 4

  Title:

  Unit Test 2

  Description:

  Learning Outcomes: 1, 2, 3, 4, 5
  
  This test covers all the topics in Week 5 and Week 6.

  Weighting:

  10 %

  Criteria for assessment:

  Due date:

  Conducted in the tutorials in Week 8

  Remarks:

  On Campus Student:
  
  There will be a number of versions of the unit test, a student may get any one of these version to work on
  
  Off campus (ONLINE) students:
  
  There will be an assignment on SQL Data Retrieval to be submitted online
  
  Task Description:Given a database and sample data, students will be required to use Oracle to create tables and populating the tables using appropriate SQL statements.
  
  Task Criteria:

  • Correctness of the SQL statement in retrieving the required data.
  • Appropriate use of SQL constructs.

• Assessment task 5

  Title:

  Assignment 1 (Part A): Initial Conceptual Design

  Description:

  Learning Outcomes: 3, 4, 5, 6
  
  Students will be supplied with a case study and asked to model this using Entity Relationship modelling. This part of Assignment 1 will require the submission of a "beginning" conceptual design.

  Weighting:

  Hurdle to the submission of Assignment 1 (Part B)

  Criteria for assessment:

  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).

  Due date:

  Week 10 Monday 5 October 2015 on Moodle

• Assessment task 6

  Title:

  Assignment 1 (Part B): Full Database Design

  Description:

  Learning Outcomes: 3, 4, 5, 6
  
  Based on the feedback from Assignment 1 (Part A) 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 Entity-Relationship Diagram (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 1 (Part A).

  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

  Hurdle requirements:

  Satisfactory completion of Assignment 1 (Part A): Initial Conceptual Design

  Due date:

  Week 12 on Friday 23 October 2015 on Moodle

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 with comments
• Test results and feedback
• Quiz results
• Solutions to tutes, labs and assignments

Extensions and penalties

Returning assignments

Resubmission of assignments

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.

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.

Required Resources

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 .

Prescribed text(s)

Coronel, C. and Morris, S. (2014). Database Systems. (11th Edition) Cengage Learning.

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

Additional Recommended Learning Materials will be listed on the unit's Moodle site.

Additional subject costs

On-Campus (Clayton, Caulfield) students are required to purchase a Turning Point clicker from the Campus Bookstore or directly from the Australian Distributor.

Other Information

Policies

Graduate Attributes Policy

Student Charter

Student services

Monash University Library

Disability Liaison Unit

Other

Getting the most from your studies in this unit:

Lecture: During the lecture, your lecturer will conduct the peer instruction session. 

• Prior to the lecture
  • reading the precribed reading from the textbook
  • complete the pre-lecture quiz in Moodle,
• During the lecture
  • participate by asking question and seeking 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.

Engineers Australia Stage 1 competencies

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).

Relationship between Unit Learning Outcomes and BSE Course Outcomes

Relationship between Unit Learning Outcomes and Assessments