Examine the role of data in an organisation

Assignment Help Management Theories

Reference no: EM132916618

MIS602 Data Modelling and Database Design - Torrens University Australia

Learning Outcome 1: Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data.

Learning Outcome 2: Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.

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?

Referencing
It is essential that you use appropriate APA style.

Attachment:- Data Modelling and Database Design.rar

Reference no: EM132916618

Questions Cloud

Essential in development of young children : Communication among all stakeholders is essential in the development of young children.

Collaboration including communication with families : Describe how each school team modeled effective collaboration including communication with families.

Calculate the required sample size : Ebeco has l0,000 receivable accounts with a total book value of $1,500,000. Calculate the required sample size

Communicate with parents regarding struggling reader : How do you plan to include parents in reading and writing literacy? Explain how you will communicate with parents regarding a struggling reader.

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

Clinical field experience verification : Candidates must complete all programmatic requirements, including practicum/field experiences hours defined in their coursework.

What amount is the interest income to be recognized : The bonds are quoted at 105 on December 31, 2020 and 110 on December 31, 2021. What amount is the interest income to be recognized

How to evaluate language and literacy strategies : How to evaluate language and literacy strategies and student performance when modifying instruction and determining appropriate interventions with at-risk

MIS602 Data Modelling and Database Design Assignment : MIS602 Data Modelling and Database Design Assignment Help and Solution, Torrens University Australia - Assessment Writing Service

User Account

All Pages