Reference no: EM132928083
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.
Assessment Modelling Report - Case Study
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:- Case Study_Modelling Report.rar
|
Compute the net present value of the new machine
: The old equipment has a book value of $100,000. However, it can be sold for only $20,000 if it is replaced. Compute the net present value of the new machine
|
|
Discuss features of corporatist theory of industrial
: Briefly discuss features of the 'Corporatist theory' of industrial/ employment relations and explain the main argument of corporatist theory?
|
|
Prepare the required December year-end adjusting entries
: Depreciation on the company's wind turbine equipment for the year is $5,600. Prepare the required December year-end adjusting entries
|
|
Describe the key objective of occupational health
: 1) Describe the key objective of occupational health and safety legislation?
|
|
Develop solutions related to the creation
: An entity relationship diagram including significant attributes against each entity - List any assumptions/business rules you have made
|
|
What percent of total sales was spent on delivery costs
: Thompson's Hardware spent $50,740 this year on delivery costs alone. If total sales were $630,400, what percent of total sales was spent on delivery costs
|
|
What does rewriting history really mean
: What does rewriting history really mean?
|
|
What is hulakon roi
: The following data shows turnover costs for the 4,000 employees of Hulakon Inc., for one year. In any given year, 12 percent of the employees can be expected to
|
|
How much do you need to save per year to reach your goal
: You plan to put the money in your money market account earning 4%. How much do you need to save per year to reach your goal
|