The purpose of this assignment

Assessment Details and Submission Guidelines
Unit Code	MN405
Unit Title	Data and Information Management
Assessment Type	Assignment 1 (T2 2018)
Assessment Title	Managing Data in Databases
Purpose of the assessment (with ULO Mapping)	The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially available database management system development tool. On completion of this assignment students will be able to: Model organisational information requirements using conceptual data modelling techniques. Convert the conceptual data models into relational data model and verify their structural characteristics with normalisation techniques.
Weight	20% of total assessment for the unit
Total Marks	100 = 30 (for online quiz- Part A) + 70 (for Part B)
Word limit	No specific word limit
Due Date	Lab class week 8
Description of this assignment:	This assignment consists of two parts: Part A: An online quiz on Moodle, comprising 30 questions. This quiz covers basic concepts of the relational data models. Students may have up to 3 attempts to answer this quiz. The system will keep the highest score. Part B: Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.
Submission Guidelines	All work must be submitted on Moodle by the due date. Download this assignment, write your answers and save it on Moodle link as “MN405_T2_2018_Assigment1_your_name.doc” The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings. Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style.
Extension	If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School’s Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7. You must submit this application three working days prior to the due date of the assignment. Further information is available at: http://www.mit.edu.au/about –mit/institute –publications/policies –procedures –and –guidelines/special considerationdeferment
Academic Misconduct	Academic Misconduct is a serious offence. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and procedure available at: http://www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/Plagiarism-Academic-Misconduct-Policy-Procedure. For further information, please refer to the Academic Integrity Section in your Unit Description.