Databases Reference
In-Depth Information
(a)
vendor name (primary key), alternate vendor, PO Box, city, state,
postal code
(b)
employee number (primary key), last name, first name, department
number, department name, e-mail address, cubicle location, manager ID
(c)
product SKU (primary key), description, warehouse location, quantity
on hand, quantity on order, vendor
(d)
order number (primary key), line item number (primary key), prod-
uct SKU, quantity, selling price
Applying This Chapter
1.
You can order multiple products from any vendor. A product can be
ordered from multiple vendors. The identifier for the PRODUCT entity is
SKU. The identifier for the VENDOR entity is Vendor Number. What kind
of relationship does this describe? List the tables that would result from con-
version to relational tables. Include the primary key for each of the tables.
2.
You are designing relational tables for the E-R diagram shown in Figure
4-32. What foreign keys would be added during conversion (list by table)?
What tables not currently identified by an entity would be added (if any)?
What are the primary key attributes in the first normal form for this model?
Figure 4-32
ORCHESTRA
MUSICIAN
DEGREE
*Orchestra
Name
City
Country
Music Director
*Musician
Number
Musician Name
Instrument
Annual Salary
*Degree
University
Year
Works for
Earned
Ye a r
Price
Recorded
COMPOSITION
COMPOSER
*Composition
Name
Ye a r
*Composer
Name
Country
Date of Birth
Wrote
Sample E-R diagram.
