Question: Task 1 Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent the information requirements of company you are

Task 1

Entity-relationship data model (ERD)-Business rule, assumptions

You are required to develop an ER model to represent the information requirements of company you are working for.

The diagram of your ER model must:

  • show all necessary entities, attributes and relationships
  • show unique identifiers
  • show maximum and minimum cardinalities

You also need to write business rules and assumptions.

Task 2: Create the Data Dictionary base on your ERD diagram.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Intro to Database Management Project 3 Start Assignment Due Thursday by 11:59pm Points 100 Submitting a file upload File Types vsdx, pdf, xlsx, and docx Attempts 0 Allowed Attempts 3 Available Dec 6...

Q:

From the case study below answer Tasks 1-3 Whenever a customer makes a booking on the web page, they must enter their customer details. A new customer will automatically be assigned an account...

Q:

Overview Rick and Morty is an animated, comedic, science-fiction television series that premiered in the United States in December of 2013. Rick and Morty has received near-universal critical acclaim...

Q:

Overview Silicon Valley is a comedic television series that premiered in the United States in April of 2014. Critical response to Silicon Valley has been overwhelmingly positive since its inception,...

Q:

A. Lab # : BSBA BIS245A-2 B. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database C. Lab Overview Scenario / Summary COs: 1. Given a business situation in which managers require...

Q:

Page 1 of 6 A. Lab # : BSBA BIS245A - 3 B. Lab 3 of 7: Database Design Using Visio and Based on Data Requirements and Business R ules C. Lab Overview -- Scenario/Summary TCOs: 2. Given a situation...

Q:

Page 1 of 6 A. Lab # : BSBA BIS245A - 3 B. Lab 3 of 7: Database Design Using Visio and Based on Data Requirements and Business R ules C. Lab Overview -- Scenario/Summary TCOs: 2. Given a situation...

Q:

database ! Project Description You have been asked to design a database for Healthway Hospital. Healthway depends on a large number of persons for its continued success. There are four groups of...

Q:

PART A: KNOWLEDGE EVIDENCE INSTRUCTIONS Question 1. Research within the Australian workplace context and outline at least TWO workplace relevant legislations that are essential for managing effective...

Q:

* * PLEASE USE VISUAL PARADIGM OR SOMETHING SIMILAR FOR THE ERD * * Task 2 Construct a logical Entity Relationship Diagram ( ERD ) Based on the business rules developed in Task 1 , construct a...

Q:

Consider gravity loading under complete lateral restraint in flat, stratified ground where each stratum is homogeneous, isotropic, and linearly elastic. Assume compression is positive, is Poissons...

Q:

Wacky Wintersports Inc. can produce snowboards according to the following schedule. a. Complete the table by calculating the marginal and average products. b. Plot the AP and MP curves on a single...

Q:

______refers to an employee's attachment to the organization, whereas ______refers to the way an employee feels when working on the tasks themselves. Group of answer choices Work engagement; job...

Q:

The umbrella of ozone in the upper atmosphere is formed from the photolysis of O 2 molecules by solar radiation according to the following reaction: Calculate the cutoff wavelength above which this...

Q:

What are the solutions of : y + 4y 4y = 0 a) y(x)=Ae2x+Bxe2x b) y(x)=Ae6x+Be2x c) y(x)=Ae2x+Be2x d) y(x)=Ae(222)x+Be(2+22)x

Q:

If you draw a card with a value of four or less from a standard deck of cards, I will pay you $5. If not, you pay me $5. (Aces are considered the highest card in the deck.) Step 1 of 2 : Find the...

Q:

A truck was purchased 3 years ago for $45,000 and can be sold today for $24,000. The operating costs are $9,000 per year, and it is expected to last 4 more years with a $5,000 salvage value. A new...

Q:

What was the most significant impact on the development of the United States during the late nineteenth century?

Q:

2. 35 following LP: Use the Branch-and-Bound Algorithm, graphic solution to obtain optimal solution to the 2 4 min Z = -x + X2 5 8x + 3x, > 2 4x + 9x, > 3 X1, X, 20 and integer

Q:

2. Ask questions, listen rather than attempt to persuade.

Q:

9. How much of the information collected will be used in decision-making?

Q:

1. Background knowledge of the subject and