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
icon
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.
Transcribed Image Text: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

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Knowledge Booster
Processes of 3D Graphics
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education