Create the ERD for this database.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 23P: Problems 2224 are based on the following query: SELECT P_CODE, P_DESCRIPT, P_PRICE, P.V_CODE,...
Related questions
Question
I am not sure what this is asking to be done.
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
This is a popular solution!
Step by step
Solved in 5 steps with 2 images
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning