1. Give the business rules for the tables 2. Give relational schema for all the tables...

  

Transcribed Image Text:

1. Give the business rules for the tables 2. Give relational schema for all the tables 3. Create Relational diagram for the database. 4. Identify the TRUCK table's any two [2] candidate keys 5. For BASE table, identify any two [2] super keys Table name: TRUCK Primary key: TRUCK_NUM Foreign keys: BASE_CODE, TYPE_CODE TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK_BUY DATE TRUCK_SERIAL_NUM Database name: Ch03_TransCo 1001 501 32123.5 23-Sep-07 AA-322-12212-W11 76984.3 1002 1003 502 05-Feb-06 AC-342-22134-Q23 501 2 12346.6 11-Nov-06 AC-445-78656-Z99 1004 2894.3 06-Jan-07 WQ-112-23144-T34 1005 1006 1007 1008 1009 503 2 45673.1 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 193245.7 32012.3 44213.6 501 2 502 3 17-Oct-04 AA-341-96573-Z84 07-Aug-05 DR-559-22189-D33 12-Feb-08 DE-887-98456-E94 502 3 503 10932.9 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE CITY BASE STATE BASE AREA_CODE BASE PHONE BASE_MANAGER 123-4567 TN 615 Andrea D. Gallager 501 Murfreesboro 502 Lexington 503 Cape Girardeau MO 504 Dalton KY 568 234-5678 George H. Delarosa 456 345-6789 Maria J. Talindo GA 901 456-7890 Peter F. MCAvee Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE CODE TYPE DESCRIPTION 1 Single box, double-axde 2 Single box, single-axle 3 Tandem trailer, single-axle 1. Give the business rules for the tables 2. Give relational schema for all the tables 3. Create Relational diagram for the database. 4. Identify the TRUCK table's any two [2] candidate keys 5. For BASE table, identify any two [2] super keys Table name: TRUCK Primary key: TRUCK_NUM Foreign keys: BASE_CODE, TYPE_CODE TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK_BUY DATE TRUCK_SERIAL_NUM Database name: Ch03_TransCo 1001 501 32123.5 23-Sep-07 AA-322-12212-W11 76984.3 1002 1003 502 05-Feb-06 AC-342-22134-Q23 501 2 12346.6 11-Nov-06 AC-445-78656-Z99 1004 2894.3 06-Jan-07 WQ-112-23144-T34 1005 1006 1007 1008 1009 503 2 45673.1 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 193245.7 32012.3 44213.6 501 2 502 3 17-Oct-04 AA-341-96573-Z84 07-Aug-05 DR-559-22189-D33 12-Feb-08 DE-887-98456-E94 502 3 503 10932.9 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE CITY BASE STATE BASE AREA_CODE BASE PHONE BASE_MANAGER 123-4567 TN 615 Andrea D. Gallager 501 Murfreesboro 502 Lexington 503 Cape Girardeau MO 504 Dalton KY 568 234-5678 George H. Delarosa 456 345-6789 Maria J. Talindo GA 901 456-7890 Peter F. MCAvee Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE CODE TYPE DESCRIPTION 1 Single box, double-axde 2 Single box, single-axle 3 Tandem trailer, single-axle

Answer rating: 100% (QA)

Truck a Every Base code present in the Truck table must be present in the Base table b Every Type nu... View the full answer