ASSESSMENT 1 BRIEFSubject Code and Title MIS602 Data Modelling and Database DesignAssessment Modelling ReportIndividual/Group IndividualLength N/ALearning Outcomes The Subject Learning Outcomes demonstrated…

ASSESSMENT 1 BRIEF

Subject Code and Title MIS602 Data Modelling and Database Design

Assessment Modelling Report

Individual/Group Individual

Length N/A

Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:

a) Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data.

c) Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.

Submission Due by 11:55pm AEST/AEDT Sunday end of Module 2.2

Weighting 30%

Total Marks 100 Marks

Task Summary

This assessment requires you to prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational database management system.

Context

When preparing to implement a new information system, it is essential that the initial design is well thought out from the outset. Modifying the database after implementation can often be an expensive process in terms of time, effort and cost. Often the first engagement step is to conduct interviews and workshops with end users and business subject matter experts to get a better understand of how the business runs. The output of these workshops becomes the foundation for the database design.

Task Instructions

1. Please read the attached MIS602_Assessment 1_Case Study.

2. Based on the information provided in the case study, prepare a modelling report to answer the following questions:

• An entity relationship diagram including significant attributes against each entity.

• A relational model showing all fields, primary keys, foreign keys and concatenated keys. Your relational model should be in third normal form. List any assumptions/business rules you have made.

• A sample screen of what you think your online order form might look like. You may use any tool you like to create this sample screen. Write a brief paragraph discussing the following:

o Does your database design allow the storage of all the required information?

o What changes, if any, did you make to your initial ER diagram and relational model after you created the sample input screen?

MIS602_Assessment 1_Brief_Modelling Report_Module 2.2 Page 1 of 3

Referencing

It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing

Submission Instructions

Submit Assessment 1 via the Assessment link in the main navigation menu in MIS602 Database Modelling and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.

Academic Integrity Declaration

I declare that except where I have referenced, the work I am submitting for this assessment task is my own work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure viewable online at http://www.torrens.edu.au/policies-and-forms

I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.

MIS602_Assessment 1_Brief_Modelling Report_Module 2.2 Page 2 of 3

Assessment Rubric

Assessment Attributes Fail

(Unacceptable) 0-49% Pass

(Functional)

50-64% Credit

(Proficient) 65-74% Distinction

(Advanced)

75 -84% High Distinction

(Exceptional)

85-100%

Entity relationship diagram

The ER diagram does not have to be in 3NF. i.e. it can contain many

to many relationships

40%

Only a few entities identified and labelled. No relationships identified. Most entities identified and labelled. Most relationships identified. All entities identified and labelled.

All relationships identified.

Most cardinality is correct. Most Participation is correct. All Relationships meaningfully labelled. Primary key labelled for entities.

All cardinality is correct.

All participation is correct. Primary keys labelled for

many-to-many relationships. Some non-key fields labelled.

Overall, a well-presented entity relationship diagram.

Relational model

The relational model needs to be in

3NF and free from anomalies

40%

Only a few entities converted to tables. Design is not in third normal form.

No list of assumptions/ business rules. Most entities converted to tables. Most fields listed. Design is in third normal form. List of assumptions/business rules provided.

All entities converted to tables. All fields listed.

Most many-to-many relationships deconstructed into new tables. Primary keys correctly underlined. All many-to-many relationships deconstructed into new tables. Foreign key correctly underlined. Any multi-valued attributes deconstructed into new tables. Any selfjoins identified. A wellpresented relational model.

Sample screen

Sample screen of the online order form.

Discuss how the database design allow the storage of all the required information and the changes made to the initial ER

diagram and relational model

20% Sample screen does not capture the requirements of the order.

No discussion paragraph provided. Screen captures most of the requirements for the order.

Discussion paragraph does not address the key points. Screen captures all of the requirements for the order. Discussion paragraph is provided. All screen fields correctly mapped to a field in the relational model. Discussion paragraph is well written and addresses the key points.

All screen fields correctly and accurately map to a field in the relational model.

Well-presented sample screen along with a discussion paragraph that addresses the key points with clarity and detail.

MIS602_Assessment 1_ Brief_Modelling Report_Module 2.2 Page 3 of 3