Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table does not have a primary, secondary key or foreign key, write None. 2.2 Do the tables A,B,C exhibit entity integrity? For each table answer yes or no and then explain your answer. 2.3 Do the tables A,B,C exhibit referential integrity? For each table answer yes or no and then explain your answer. Indicate if any of the tables A,B,C have a composite key and why you think so 2.4

2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table does not have a primary, secondary key or foreign key, write None. 2.2 Do the tables A,B,C exhibit entity integrity? For each table answer yes or no and then explain your answer. 2.3 Do the tables A,B,C exhibit referential integrity? For each table answer yes or no and then explain your answer. Indicate if any of the tables A,B,C have a composite key and why you think so 2.4

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Chapter11: Building Solutions: Database, System, And Application Development Tools
Section: Chapter Questions
Problem 4MC
See similar textbooks
icon
Related questions
Question
2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table does not have a primary, secondary key or foreign key, write None. 2.2 Do the tables A,B,C exhibit entity integrity? For each table answer yes or no and then explain your answer. 2.3 Do the tables A,B,C exhibit referential integrity? For each table answer yes or no and then explain your answer. Indicate if any of the tables A,B,C have a composite key and why you think so 2.4
Transcribed Image Text:2.1 In Tables A,B,C identify the primary key(s), secondary key(s) and the foreign key(s). If a table does not have a primary, secondary key or foreign key, write None. 2.2 Do the tables A,B,C exhibit entity integrity? For each table answer yes or no and then explain your answer. 2.3 Do the tables A,B,C exhibit referential integrity? For each table answer yes or no and then explain your answer. Indicate if any of the tables A,B,C have a composite key and why you think so 2.4
The ABC Database Tables Table A TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK SERIAL NUM 501 502 501 23-Sep-07 AA-322-12212-WM1 05-Feb-06 AC-342-22134-Q23 11-Nov-OS AC-445-78656-Z99 06-Jan-07 WVQ-112-23144-T34 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-284 07-Aug-05 DR-559-22169-D33 12-Feb-08 DE-887-98458-E94 1001 1032 1003 1004 1005 1006 1007 1009 1009 Table C Table B BASE CODE 501 502 Lexington 503 Cape Girardeau 504 Detton 503 501 502 502 T TYPE_CODE 503 BASE CITY Murfreesboro TYPE DESCRIPTION 1 Single box, double-sode 2 Single box, single-axde 3 Tandem trailer, single-exde 1 1 2 1 2 2 3 32 2 32123.5 76934.3 12346.6 2894.3 45673.1 193245.7 32012.3 44213.6 10932.9 BASE STATE BASE_AREA_CODE TN KY MO GA 615 568 456 901 BASE PHONE 123-4567 234-5678 345-6789 458-7890 BASE MANAGER Andree D. Gallager | George H. Delarosa Maria J. Talindo Peter F. McAvea
Transcribed Image Text:The ABC Database Tables Table A TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK SERIAL NUM 501 502 501 23-Sep-07 AA-322-12212-WM1 05-Feb-06 AC-342-22134-Q23 11-Nov-OS AC-445-78656-Z99 06-Jan-07 WVQ-112-23144-T34 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-284 07-Aug-05 DR-559-22169-D33 12-Feb-08 DE-887-98458-E94 1001 1032 1003 1004 1005 1006 1007 1009 1009 Table C Table B BASE CODE 501 502 Lexington 503 Cape Girardeau 504 Detton 503 501 502 502 T TYPE_CODE 503 BASE CITY Murfreesboro TYPE DESCRIPTION 1 Single box, double-sode 2 Single box, single-axde 3 Tandem trailer, single-exde 1 1 2 1 2 2 3 32 2 32123.5 76934.3 12346.6 2894.3 45673.1 193245.7 32012.3 44213.6 10932.9 BASE STATE BASE_AREA_CODE TN KY MO GA 615 568 456 901 BASE PHONE 123-4567 234-5678 345-6789 458-7890 BASE MANAGER Andree D. Gallager | George H. Delarosa Maria J. Talindo Peter F. McAvea
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Arrays
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS