Define the concept of entity integrity. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.Define the concept of referential integrity. 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 Create an ERD based on the Crow’s Foot model, using the database tables in Figure 1. Show the relationship's strength (weak or strong) Table TRUCKTRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATE TRUCK_SERIAL_NUM23-Sep-07 AA-322-12212-W1105-Feb-06 AC-342-22134-Q2311-Nov-06 AC-445-78656-Z9906-Jan-07 VQ-112-23144-T3401-Mar-06 FR-998-32245-W1215-Jul-03 AD-456-00845-R4517-Oct-04 AA-341-96573-Z8407-Aug-05 DR-559-22189-D3312-Feb-08 DE-887-98456-E94100110021003100410051006100710081009501502501503501502502503Table BASEBASE_CODE BASE_CITY501 Murfreesboro502 LexingtonTNKY503 Cape Girardeau MO504 DaltonGATable TYPE112122332BASE_STATE32123.576984.312346.62894.345673.1193245.732012.344213.610932.9TYPE_CODE TYPE_DESCRIPTION1 Single box, double-axle2 Single box, single-axle3 Tandem trailer, single-axleBASE_AREA_CODE615568456901| BASE_PHONE BASE MANAGERAndrea D. GallagerGeorge H. DelarosaMaria J. TalindoPeter F. McAvee123-4567234-5678345-6789456-7890

Hi. You can check below for your answers.

Answered: Define the concept of entity integrity.…

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

Define the concept of entity integrity. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
Define the concept of referential integrity. 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
Create an ERD based on the Crow’s Foot model, using the database tables in Figure 1. Show the relationship's strength (weak or strong)

Table TRUCK
TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATE TRUCK_SERIAL_NUM
23-Sep-07 AA-322-12212-W11
05-Feb-06 AC-342-22134-Q23
11-Nov-06 AC-445-78656-Z99
06-Jan-07 VQ-112-23144-T34
01-Mar-06 FR-998-32245-W12
15-Jul-03 AD-456-00845-R45
17-Oct-04 AA-341-96573-Z84
07-Aug-05 DR-559-22189-D33
12-Feb-08 DE-887-98456-E94
1001
1002
1003
1004
1005
1006
1007
1008
1009
501
502
501
503
501
502
502
503
Table BASE
BASE_CODE BASE_CITY
501 Murfreesboro
502 Lexington
TN
KY
503 Cape Girardeau MO
504 Dalton
GA
Table TYPE
1
1
2
1
2
2
3
3
2
BASE_STATE
32123.5
76984.3
12346.6
2894.3
45673.1
193245.7
32012.3
44213.6
10932.9
TYPE_CODE TYPE_DESCRIPTION
1 Single box, double-axle
2 Single box, single-axle
3 Tandem trailer, single-axle
BASE_AREA_CODE
615
568
456
901
| BASE_PHONE BASE MANAGER
Andrea D. Gallager
George H. Delarosa
Maria J. Talindo
Peter F. McAvee
123-4567
234-5678
345-6789
456-7890

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 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