Reference no: EM132826941
MIS602 Data Modelling and Database Design - Laureate International Universities
Design Assessment 1 Modelling Report - Case Study
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
|
How have price and variety competition changed
: How have price and variety competition changed McDonald's basic formula for success? A customer call center is evaluating customer satisfaction surveys.
|
|
Explain the relationship between the use of tracking signal
: Explain the relationship between the use of a tracking signal and statistical control limits for forecast control. You should use some illustration
|
|
How much is goods sent on consignment in transaction made
: How much is the goods sent on consignment in transaction made on January 1, 2017? What is the amount of the goods consigned that remained unsold?
|
|
Challenges and potential solutions
: Highlight 1-2 challenges and potential solutions. Consider course readings, materials, class discussions, and external references to defend your assertion.
|
|
Implement a new information system
: Prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational
|
|
Describe the family structure and language
: Create a matrix of 10 possible family structures, traditions, cultures, languages, and/or religious practices that you may encounter in a classroom.
|
|
Find and provide journal entries to account for revaluation
: Provide journal entries to account for the revaluation. when you think the revaluation increment should be included as part of the profit or loss?
|
|
Briefly explain what is marketing research
: Briefly explain what is marketing research and the importance of this to businesses.
|
|
Develop and implement a standards-based lesson plan
: Develop and implement a standards-based lesson plan that incorporates differentiated strategies, materials, technology, and culturally responsive assessments.
|