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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explaining content of document in natural language

Explain the content of this document in natural language;Design the graph representation of document;

  Explaining weak relationship and weak entity

What is meant by a weak relationship? Provide an example. What is meant by weak entity? What do you understand by relationship degree?

  Show the rea diagram using microsoft word

Show the REA diagram using Microsoft Word

  Create a database from scratch

Create a database from scratch that contains, at a minimum, the elements listed below

  Kinds of joins

It is not uncommon to have to access the data which reside in different tables, especially when formulating a report.

  Creating use case to describe typical sales process

Create use case to describe a typical sales process. Then make a sequence diagram for use case.

  Explaining valid host addresses of wan links

Start with LAN on RTA and proceed clockwise. Determine the number that how many total valid host addresses will be wasted on WAN links?

  Design a set of 3nf tables for database scenario

Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.

  Explain the security mechanisms available for a database

Use technology and information resources to research issues in database systems. Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  Create and run the following sql queries

Create and run the following  sql  queries and submit the screen shot of your result. Also submit the file lab_06_03. sql

  Write a recursive sql query

MCIS 630 Database Systems: -  Write a recursive SQL query that outputs the names of all subparts of the part with part-id “P- 100”.

  Relational algebra expressions for names of salespeople

Illustrate relational algebra expressions for names of all salespeople, names of all salespeople having ORDER row and names of salespeople not having ORDER row.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd