Question: 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,

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 BASE_CODE TYPE_CODE |TRUCK_MILES |TRUCK_SERIAL_NUM 1001 501 32123.5 AA-322-12212-W11 1002 502 76984.3 AC-342-22134-Q23 1003 501 12346.6 AC-445-78656-799 1004 2894.3 WQ-112-23144-T34 1005 503 45673.1 FR-998-32245-W12 NN 1006 501 193245.7 AD-456-00845-R45 1007 502 3 32012.3 AA-341-96573-284 1008 502 3 44213.6 DR-559-22189-D33 1009 503 2 10932.9 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-axle 2 Single box, single-axle 3 Tandem trailer, single-axle

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 Finance Questions!

Based on the figure below, what do you think is the possible relationship between BASE and TYPE tables? Table name: TRUCK Database name: Ch 0 3 _ TransCo Primary key: TRUCK _ NUM Foreign key: BASE _...

Table name: TRUCK Database name: Ch03_TransCo Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE Table name: BASE Primary key: BASE_CODE Foreign key: none Table name: TYPE Primary key:...

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

Table nams: TRUCK Database name: Cho3_TransCo Primary key: TRUCK_NUM Foreigh hey: BASE CODE, TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign kevi hone: Table name: TYPE Primary key: TYPE...

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

Use the database shown in Figure 3 to answer Problems 8-11. Table name: TRUCK Primary key: TRUCK_NUM Database name: Ch03_TransCo Foreian kevs: BASE CODE. TYPE CODE Table name: BASE Primary key:...

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

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

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

Primary key: TRUCK_NUM Database name: Ch03_TransCo Foreian kevs: RASE CODE. TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign key: none Table name: TYPE Primary key: TYPE_CODE Foreign key:...

S ( + 12x 36+ x - 12x - 36 dx If the definite integral above can be expressed as ab where a, b are positive integers with b square free, then what is the value of ab?

Assume you are the CEO of your own company. The board and you are discussing the option of going public. Before a final decision is made, you decide to little research on your own, prior to a final...

Barnes Company reports the following for its product for its first year of operations. Direct materials$ 3 6 per unitDirect labor$ 2 6 per unitVariable overhead$ 1 2 per unitFixed overhead$ 7 0 , 0 0...

please answer the questions within 30 minutes. make sure the answer and calculations are explained in very detailed manner. answer should not be copied from somewhere else i will give negative...