Question: Table name: TRUCK Primary key: TRUCK NUM Database name: Ch03_TransCo Foreign keys: BASE_CODE, TYPE_CODE TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATE TRUCK_SERIAL_NUM 1001 501 1 321235 23-Sep-07

Table name: TRUCK Primary key: TRUCK NUM Database

Table name: TRUCK Primary key: TRUCK NUM Database name: Ch03_TransCo Foreign keys: BASE_CODE, TYPE_CODE TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATE TRUCK_SERIAL_NUM 1001 501 1 321235 23-Sep-07 AA-322-12212-W11 1002 502 1 769843 05-Feb-06 AC-342-22134-023 1003 501 2 123466 11-Nov-06 AC-445-78656-799 1004 1 28943 06-Jan-07 WVQ-112-23144-T34 1005 503 2 45673.1 01-Mar-06 FR-998-32245-W12 1006 501 2 193245.7 15-Jul-03 AD-456-00845-R45 1007 502 3 320123 17-Oct-04 AA-341-96573-784 1008 502 3 44213.6 07-Aug-05 DR-559-22189-033 1009 503 2 10932.9 12-Feb-08 DE-887-98456-E94 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE_CODE BASE_CITY BASE STATE BASE AREA_CODE BASE PHONE BASE MANAGER 501 Murfreesboro TN 615 123-4567 Andrea D. Gallager 502 Lexington KY 568 234-5678 George H. Delarosa 503 Cape Girardeau MO 456 345-6789 Maria J. Talindo 504 Dalton 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-ade 2 Single box, single-axde 3 Tandem trailer, single-axe 9. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 10. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. 11. Identify the TRUCK table's candidate key(s). 12. For each table, identify a superkey and a secondary key

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

During a winter day, the window of a patio door with a height of 1.8 m and width of 1.0 m shows a frost line near its base. The room wall and air temperatures are 15C. (a) Explain why the window...

Table name: TRUCK Primary key: TRUCK NUM Database name: Ch03_TransCo Foreign keys: BASE_CODE, TYPE_CODE TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATE TRUCK_SERIAL_NUM 1001 501 1 321235...

FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUM 1001 32123.5...

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...

18. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 20. Identify the TRUCK table's candidate key(s). 22. Create the ERD for this database. 23. Create the...

106 Problems Use the database shown in Figure P3.1 to answer Problems 1, 2, 3, 4, 5, 6, 7, 8 and 9. Figure P3.1 The CH03_Storeco Database Tables Table name: EMPLOYEE Database name: Ch03_StoreCo EMP...

Create the ERD for this database using Crow s foot notation. Thank you to anyone reviewing it! 2. Given the following database: Table name: TRUCK Primary key: TRUCK_NUM Foreign keys: BASE_CODE,...

MIS 560 Database Management Systems-Assignment Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does...

MIS 560 Database Management Systems- Assignment Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key{s). If a table does...

To create the ERD for this database FIGURE P3.17 THE CHO3_TRANSCO DATABASE TABLES Table name: TRUCK Database name: Ch03_TransCo Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK_NUM...

For a given delivery trip, A trucking company has many different trucks and many to drivers. As time passes, a driver will make trips with many different trucks and any given different drivers. The...

Repeat the previous problem with = 0.5. Discuss also the appearance of the limit cycle, x(t), and x(t).

Characteristic Equations Q1.Reduce the following PDE equation to ODES(No need to solve them) in terms of y=y(x), u=u(x) and u=u(y) (a) (i) (iii) (iv) 3ux + 4 uy - 0 2ux + 5uy = 0 3ux + 2Uy = 0 1 5ux...

Question 1 On the \ ( 1 ^ { \ text { st } } \ ) September, 2 0 2 0 Jack Co entered into an agreement to lease a machine that had an estimated life of four years. The lease period is also four years,...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...