Translation from erd to the relational model

Assignment Help Database Management System

Reference no: EM1348056

Q1) Depts(dID, dName, budget)

d stands for department. Gives the departments, their ID, name and budget.
Employees(eID, dID, eName, eSalary)

e stands for employee Gives the employees, their IDs, where they work, their names and salaries.
Suppliers(sID, sName, sCity, sState, eID)

s stands for supplier. Gives the suppliers, their IDs, their names, and where they are located (city and state). Also tells which employees are contact persons for the suppliers.
Items(sID, siCode, dID, iName, MSRP)

i stands for item, siCode stands for supplier-assigned item code. Gives the items and the departments that sell the items. MSRP=manufacturer suggested retail price.

Primary keys are underlined. Each relation schema has one candidate key (therefore, it's the primary key), it may be missing candidate (unique) keys and foreign keys.
Do the following (3 steps):

1. Complete (i.e., reverse engineering) ER diagram below such that 4 relation schemas above are exactly result of a translation from the ERD to the relational model. You are NOT allowed to add any additional entity set.

Reference no: EM1348056

Questions Cloud

Estimate the stocks current market value : Nachman just paid a dividend of $1.32. Analysts expect firm dividend to increase by 30 percent this year, by 10 percent in Year second, and at a constant rate of 5% in Year 3 and thereafter.

Explain why paul collier seems industrialization or trade : Explain why Paul Collier seems to argue that export oriented industrialization or trade liberalization policies enacted by African countries would not help Africa develop.

Income statement-balance sheet of purchases : Make an income statement for Packer, Inc. for 2013, and the balance sheet as of December 31, 2013. Case study is given below:

Find an article on internet involving annuities : Find an article on internet involving annuities to find interesting and informative. Present this article and describe why you select the example.

Translation from erd to the relational model : Complete (i.e., reverse engineering) ER diagram below such that 4 relation schemas above are exactly result of a translation from the ERD to the relational model.

Regulate the two tests that you consider the most important : Appraise the types of employee testing that companies may need that are discussed in the text. Regulate the two tests that you consider the most important

Elucidate why the equilibria found short-run equilibria : Elucidate why the equilibria found in part (a) are only short-run equilibria. What will happen in the long run.

Explain why would a country currency relatively pegged : Explain why would a country (for example China) choose to keep their currency relatively pegged to the U.S. dollar.

Writing script for fahrenheit in celsius temperature : Use functions to write script which enables user to enter either Fahrenheit temperature and display Celsius equivalent or enter Celsius temperature.

User Account

All Pages