Map this ER diagram to a Relational Model and normalize it if needed. employee EMP_ID INT EMP_Frame
Fantastic news! We've Found the answer you've been seeking!
Question:
Map this ER diagram to a Relational Model and normalize it if needed.
Transcribed Image Text:
employee EMP_ID INT EMP_Frame VARCHAR(40) EMP_Lname VARCHAR(40) EMP_Sex VARCHAR(1) EMP_Birthdate DATE EMP_Salary INT Indexes distributor ?DIST_ID INT RETAIL_ID INT Indexes orders ORDER_ID INT CLI_ID INT ORDER_Date DATE SHIPPING_Dur DATE ORDER_Total DECIMAL (13,2) Indexes # retailer RETAIL_ID INT DIST_ID INT PART_MSRP DECIMAL(13,2) PART_Discount DECIMAL(5,2) PART_Cost DECIMAL(13,2) Indexes - client CLI_ID INT ORDER_ID INT CLI_Fname VARCHAR(40) CLI_Lname VARCHAR(40) CLI_Address VARCHAR(100) CLI_Zip INT CLI_Membership VARCHAR(1) Indexes manufacturer MANU_ID INT DIST_ID INT Indexes employee EMP_ID INT EMP_Frame VARCHAR(40) EMP_Lname VARCHAR(40) EMP_Sex VARCHAR(1) EMP_Birthdate DATE EMP_Salary INT Indexes distributor ?DIST_ID INT RETAIL_ID INT Indexes orders ORDER_ID INT CLI_ID INT ORDER_Date DATE SHIPPING_Dur DATE ORDER_Total DECIMAL (13,2) Indexes # retailer RETAIL_ID INT DIST_ID INT PART_MSRP DECIMAL(13,2) PART_Discount DECIMAL(5,2) PART_Cost DECIMAL(13,2) Indexes - client CLI_ID INT ORDER_ID INT CLI_Fname VARCHAR(40) CLI_Lname VARCHAR(40) CLI_Address VARCHAR(100) CLI_Zip INT CLI_Membership VARCHAR(1) Indexes manufacturer MANU_ID INT DIST_ID INT Indexes
Expert Answer:
Related Book For
Database Design Using Entity Relationship Diagrams
ISBN: 9781032017181
3rd Edition
Authors: Sikha Saha Bagui, Richard Walsh Earp
Posted Date:
Students also viewed these databases questions
-
One of the most notable cases of financial statement fraud involving a public company in the last five years is the case of Wirecard AG, a German payment processor and financial services provider....
-
Model ER Consider the following information about the Bank database. - Each bank has a unique name. - Each bank can have many branches. - Each branch has a number, name, address composed by number,...
-
Corporation is a company which handles the auction of the different antiques. The company wants to shift from the offline system to the online auction system. For this they have consulted a database...
-
You are the manager of Fun World, a small amusement park. The accompanying diagram shows the demand curve of a typical customer at Fun World. a. Suppose that the price of each ride is $5. At that...
-
In most incentive wage plans, does production above standard reduce the labor cost per unit of output? Discuss.
-
You select a person at random from a large group at a conference. What is the probability that the person selected has a birthday in July? Assume 365 days in a year.
-
On January 1, 2008, Pitt Company purchased an 80% investment in Saxe Company. The acquisition cost was equal to Pitts equity in Saxes net assets at that date. On January 1, 2008, Pitt and Saxe had...
-
Garlington Technologies Inc.'s 2010 financial statements are shown below: Balance Sheet as of December 31, 2010 Suppose that in 2011 sales increase by 10% over 2010 sales and that 2011 dividends will...
-
Richmond Lobster Inc. is planning on paying annual dividends of $1.20, $1.35, and $1.50 over the next 3 years, respectively. After that, the company plans to pay a constant dividend of $1.75 per...
-
The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many...
-
17. A sleeve bearing refers to a bearing that A. has a bore size of less than 6 inches. O B. is larger than 1 inch in outside diameter. C. is smaller than 1 inch in outside diameter. D. contains...
-
At the consulting agency, water/wastewater customers fall under two categories: commercial and residential customers. The commercial customers have a demand curve of d1 = 2,750 - 85p1. While...
-
The dominant allele B produces black coat color in dogs. Dogsthat are homozygous recessive, bb, are brown. Curly hair in dogs iscontrolled by a dominant allele C and dogs that are...
-
Description: Content Marketing Development Assignment Overview The goal of this is to develop 3 separate Content Marketing pieces for the organization of your choice. You must identify the company...
-
Wawa, Inc is an American chain ofconvenience stores and gas stations located along the East Coast ofthe United States, operating in Pennsylvania, New Jersey, Delaware,Maryland, Virginia, Washington,...
-
A manufacturing cell within a value stream is structured with four processes. The processes and their associated unit processing times are as follows: Cutting 12 minutes Drilling and insertion 8...
-
This thesis given below is a bit vague could you change it up to be more specific, for example it says courts have been essential but say how? Also, the arguments given "the impact of the legal...
-
The executor of Gina Purcells estate has recorded the following information: Assets discovered at death (at fair value): Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
Which data model is mostly used today? Why?
-
In the following table, does all the data conform to empno name?
-
What are attributes? List attributes of the entities you found in question 1? Question 1: Of the following items, determine which could be an entity and state why: automobile, college class, student,...
-
The ratio times interest earned can be used to evaluate: a. The amount of debt versus equity financing. b. The extent to which interest income exceeds in terest expense. c. The extent to which...
-
Days sales in inventory is equal to: a. 365/inventory turnover. b. Sales/inventory turnover. c. 365 X inventory/sales. d. 365 X sales/inventory.
-
Default risk Consider the following basic data on a one-year Ecuadorian Brady Bond (dollar denominated sovereign obligation). It has a face value of \($100\) payable at maturity, but no coupon. Today...
Study smarter with the SolutionInn App