# The Grace

2437 Words10 Pages
http://www.oppapers.com/essays/Value-Chain-Analysis-Ba/689012

http://www.oppapers.com/essays/Value-Chain-Analysis-Ba/689012
Problem A

Use the database shown in Figure P3.1 to work Problems 1-7. Note that the database is composed of four tables that reflect these relationships:
• An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs.
• An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs.

Note also that the *:* relationship has been broken down into two 1:* relationships for which the BENEFIT table serves as the composite or bridge entity.
Database name: Ch03_BeneCo Table name: EMPLOYEE
EMP_CODE EMP_LNAME JOB_CODE
14 Rudell 2
16 Ruellardo 1
17
(Hint: Each store employs many employees, one of whom manages the store.)

12. Draw the ERD to show the relationships among EMPLOYEE, STORE, and REGION.

Problem C

Use the database Ch03_TransCo to answer Problems 19-24
Database name: Ch03_TransCo
Table name: TRUCK
TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATE TRUCK_SERIAL_NUM
1001 501 1 32,123.50 23-Sep-03 AA-322-12212-W11
1002 502 1 76,984.30 05-Feb-02 AC-342-22134-Q23
1003 501 2 12,346.60 11-Nov-03 AC-445-78656-Z99
1004 1 2,894.30 06-Jan-04 WQ-112-23144-T34
1005 503 2 45,673.10 01-Mar-03 FR-998-32245-W12
1006 501 2 193,245.70 15-Jul-00 AD-456-00845-R45
1007 502 3 32,012.30 17-Oct-01 AA-341-96573-Z84
1008 502 3 44,213.60 07-Aug-02 DR-559-22189-D33
1009 503 2 10,932.90 12-Feb-04 DE-887-98456-E94
Table name: BASE
BASE_CODE BASE_CITY BASE_COUNTY BASE_AREA_CODE BASE_PHONE BASE_MANAGER
501 London Buckinghamshire 0181 123-4567 Andrea D. Gallager
502 Edingburgh Edingburgh City 0117 234-5678 George H. Delarosa
503 Best North Brabant 4567 345-6789 Maria J. Talindo
504 Blackrock Cork 3531 456-7890 Peter F. McAvee
Table name: TYPE
TYPE_CODE TYPE_DESCRIPTION
1 Single box, double-axle
2 Single box, single-axle
3 Tandem trailer, single-axle
13. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.

TABLE PRIMARY KEY FOREIGN KEY(S)
TRUCK TRUCK_NUM BASE_CODE,TYPE_CODE