I am not sure what this is asking to be done. FIGURE P3.17 The Ch03_TransCo Database TablesTable name: TRUCKDatabase name: Cho03_TransCoPrimary key: TRUCK_NUMForeign keys: BASE_CODE, TYPE_CODETRUCK NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK_SERIAL NUM100110021003100450132123.523-Sep-07 AA-322-12212WI1502176984.305-Feb-06 AC-342-22134-023501212346611-Nov-06 AC-445-70656-2992894306-Jan-07 WO-112-23144-T341005100610071008100950345673.101-Mar-06 FR-998-32245W125012193245.715-Ju-03 AD-456-00645-R45502332012317-Oct-04 AA-341-98573-284502344213.607-Aug-05 DR-s59-22189-D33503210932912-Feb-08 DE-S87-98456-E94Table name: BASEPrimary key: BASE_CODEForeign key: noneBASE CODEBASE STATE BASE AREA_CODE BASE_PHONE BASE MANAGERAndrea D. OalagerGeorge H. DelarosaBASE CITY501 MurtreesboroTN615123-4567502 Lexington503 Cape Girardeau MOKYSE8234-5678456345-6709Maria J. Talindo504 DatonGA901456-7890Peter F. McAveeTable name: TYPEPrimary key: TYPE_CODEForeign key: noneTYPE_CODETYPE DESCRPTION1 Single box, double-ade2 Single box, single-ode3 Tandem traler, single-adeCreate the ERD for this database.

Answered: Create the ERD for this database.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

I am not sure what this is asking to be done.

FIGURE P3.17 The Ch03_TransCo Database Tables
Table name: TRUCK
Database name: Cho03_TransCo
Primary key: TRUCK_NUM
Foreign keys: BASE_CODE, TYPE_CODE
TRUCK NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK_SERIAL NUM
1001
1002
1003
1004
501
32123.5
23-Sep-07 AA-322-12212WI1
502
1
76984.3
05-Feb-06 AC-342-22134-023
501
2
123466
11-Nov-06 AC-445-70656-299
28943
06-Jan-07 WO-112-23144-T34
1005
1006
1007
1008
1009
503
45673.1
01-Mar-06 FR-998-32245W12
501
2
193245.7
15-Ju-03 AD-456-00645-R45
502
3
320123
17-Oct-04 AA-341-98573-284
502
3
44213.6
07-Aug-05 DR-s59-22189-D33
503
2
109329
12-Feb-08 DE-S87-98456-E94
Table name: BASE
Primary key: BASE_CODE
Foreign key: none
BASE CODE
BASE STATE BASE AREA_CODE BASE_PHONE BASE MANAGER
Andrea D. Oalager
George H. Delarosa
BASE CITY
501 Murtreesboro
TN
615
123-4567
502 Lexington
503 Cape Girardeau MO
KY
SE8
234-5678
456
345-6709
Maria J. Talindo
504 Daton
GA
901
456-7890
Peter F. McAvee
Table name: TYPE
Primary key: TYPE_CODE
Foreign key: none
TYPE_CODE
TYPE DESCRPTION
1 Single box, double-ade
2 Single box, single-ode
3 Tandem traler, single-ade
Create the ERD for this database.

Expert Solution

Introduction

The given assignment has three tables as below:

1) TRUCK

2) BASE

3) TYPE

The requirement is to build an Entity-Relationship Diagram based on the given attributes and primary and foreign key relationships where Entity Relationship diagram shows the relationships of entities (tables) with other tables (entities) along with a cardinality of relationship.

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions