Apply contemporary database modelling

Reference no: EM132922606

MIS602 Data Modelling and Database Design - Torrens University Australia

Assessment - Modelling Report

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:- Modelling Report.rar

Reference no: EM132922606

Questions Cloud

What extent do think the research methods used : To what extent do you think the research methods used by psychologists adequately explain human behavior in the real world?

What criteria meets the depression diagnosis : Develop a detailed treatment plan for the client, include short term and long term goals. Using the DSM, what criteria meets the Depression diagnosis?

Prepare the direct materials purchases budget : The desired raw materials ending inventory is 40% of the next month's production needs, Prepare the direct materials purchases budget

List the symptoms of social anxiety that observed in client : List the symptoms of Social Anxiety that you observed in the client. Develop a detailed treatment plan for the client., include short term and long term goals.

Apply contemporary database modelling : Apply contemporary database modelling to identify and address anomalies in data and recommend solutions - demonstrates your ability to assess business

Why is important for psychology professionals to develop : Why is it important for psychology professionals to develop empathy around cultural differences, lifestyle differences, and diversity?

Would groupthink be considered a supported : Would groupthink be considered a supported or unsupported strategy for resolving ethical conflicts? Review the resource on groupthink located

How the characteristic symptoms of a mental disorder : How the characteristic symptoms of a mental disorder predominate due to another medical condition that cause clinically significant discomfort

Identify an organization in location : Identify an organization in your location that complements the knowledge and skills you have developed during your program. (May be hypothetical.)

User Account

All Pages