Relational database management system

Reference no: EM133010860

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 library book borrowing 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: EM133010860

Questions Cloud

What is probability that sales will exceed the break-even : In order to cover fixed costs, the firm's sales must exceed the breakeven level of $1.8 million. What is the probability that sales will exceed the break-even

How the methods differ regarding the time periods : How the methods differ regarding the time periods in which Bad Debt Expense is recognized? Which method do you believe should be used and why?

Explain if the other manufacturing cost is variable or fixed : Explain if the other manufacturing cost is variable or fixed. The other manufacturing under fixed cost is allocated according to the relative volume sold.

Should joe recommend approval or rejection of the expansion : Based on the results of your NPV and IRR calculations above, should Joe recommend approval or rejection of the expansion project?

Relational database management 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

What is the manufacturing overhead for petrilli company : What is The manufacturing overhead? Petrilli Company used a predetermined overhead rate during the year just completed of $13.50 per direct labor hour

Determine the total materials variance for j sporting goods : J Sporting Goods, Determine the total materials variance and round to the nearest whole dollar. Enter a favorable variance as a positive number.

Calculate the amount of bond discount or premium : Use this information to calculate the amount of bond discount or premium that is amortized with each interest payment. Enter as a whole number (no cents).

Determine times interest earned ratio for lightning company : Determine Times Interest Earned Ratio for Lightning Company. For the FY 2018, Lightning Company had net sales of $850,000 and net income of $65,000.

User Account

All Pages