FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUM 1001 32123.5 AA-322-12212-WW11 1002 1003 1004 76984.3 AC-342-22134-Q23 12346.6 AC-445-78656-Z99 2894.3 WVQ-112-23144-T34 45673.1 FR-998-32245-W12 193245.7 AD-456-00845-R45 32012.3 AA-341-96573-Z84 1005 1006 1007 1008 44213.6 DR-559-22189-D33 10932.9 DE-887-98456-E94 1009 501 502 501 503 501 502 502 503 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE_CITY 1 1 Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE_CODE 2 1 2 2 3 3 2 BASE STATE BASE_AREA_CODE BASE PHONE TN 501 Murfreesboro 123-4567 502 Lexington KY 234-5678 503 Cape Girardeau MO 345-6789 504 Dalton GA 456-7890 TYPE DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandem trailer, single-axle 615 568 456 901 Database name: Ch03_TransCo BASE MANAGER Andrea D. Gallager George H. Delarosa Maria J. Talindo Peter F. McAvee Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 18. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 20. Identify the TRUCK table's candidate key(s). 21. For each table, identify a superkey and a secondary key. 22. Create the ERD for this database. 23. Create the relational diagram for this database. 19. 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. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUM 1001 32123.5 AA-322-12212-WW11 1002 1003 1004 76984.3 AC-342-22134-Q23 12346.6 AC-445-78656-Z99 2894.3 WVQ-112-23144-T34 45673.1 FR-998-32245-W12 193245.7 AD-456-00845-R45 32012.3 AA-341-96573-Z84 1005 1006 1007 1008 44213.6 DR-559-22189-D33 10932.9 DE-887-98456-E94 1009 501 502 501 503 501 502 502 503 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE_CITY 1 1 Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE_CODE 2 1 2 2 3 3 2 BASE STATE BASE_AREA_CODE BASE PHONE TN 501 Murfreesboro 123-4567 502 Lexington KY 234-5678 503 Cape Girardeau MO 345-6789 504 Dalton GA 456-7890 TYPE DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandem trailer, single-axle 615 568 456 901 Database name: Ch03_TransCo BASE MANAGER Andrea D. Gallager George H. Delarosa Maria J. Talindo Peter F. McAvee Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 18. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 20. Identify the TRUCK table's candidate key(s). 21. For each table, identify a superkey and a secondary key. 22. Create the ERD for this database. 23. Create the relational diagram for this database. 19. 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.
Expert Answer:
Answer rating: 100% (QA)
17 Identify the primary key and foreign keys for each table TRUCK Primary key TRUCKNUM Foreign keys BASECODE references the BASECODE primary key in th... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these management leadership questions
-
You meet with your client Sonya and throughout your discussion, you realize that Sonya is struggling financially. You recommend that Sonya apply for the guaranteed income supplement (GIS). Which of...
-
The monthly high and low levels of direct labor hours and total manufacturing overhead costs for Onyx Company are as shown: Level Direct Labor Hours Manufacturing Overhead Costs Highest observed...
-
Write a short email to your instructor, discussing what you believe are your greatest strengths and weaknesses from an employment perspective. Next, explain how these strengths and weaknesses would...
-
Identify the statistic used to estimate the population linear correlation coefficient.
-
You have been asked to evaluate returns from your commercial real estate investment fund (Bluestone Fund) against an industry benchmark index to determine how successful your active investment...
-
Find all components of the stiffness and compliance matrices for a specially orthotropic lamina made of AS/3501 carbon/epoxy.
-
The adjusted trial balance for Matthews Corporation at the end of the current year contained the following accounts. Interest Payable .......... $ 9,000 Lease Liability .......... 59,500 Bonds...
-
A thin airfoil is measured to have the following linear Cp distributions on its upper and lower surfaces at some small angle of attack, \ alpha . C p u pper = - 1 * ( 1 - x / c ) , C p l ower = 0 . 5...
-
Jurassic Jumpers Co. (JJ Co.) offers bungee jumping for those looking for an extreme outing. JJ Co. prepares annual financial statements and has a December 31, 2023 yearend. a. On April 1, 2023, JJ...
-
Who is the author who tells us about an evaluation process such as; Respond to the needs of the audience, illuminate teaching-learning processes, be relevant to public decision-making? Select one:...
-
The current market value of the 500,000 preferred shares of Clumsy Sports Inc. is $25 million. If the shares pay an annual dividend of $5 on a par value of $85 and the risk-free rate is 5.5%, what is...
-
The Lost in Space corporation is trying to finally build a space ship that won't end up stranding everyone on it in some random part of the galaxy. To do so they are considering a new three-year...
-
The accompanying table provides the inflation rate in the year 2005 and the average inflation rate over the period 20062019 for eight different countries. Country Inflation rate in 2005 Average...
-
Factorize (x4 - 20x + 100)
-
Given the following information, calculate each organization's times-interest-earned ratio and debt ratio. Which organization is in the stronger position? Seven Kingdoms Corp Snow Corp. Net Income...
-
Becton Labs, Inc., produces various chemical compounds for industrial use. One compound, called Fludex, is prepared using an elaborate distilling process. The company has developed standard costs for...
-
To balance the chemical equation SiH3 + O2 SiO2 + HO, you could introduce coefficients a, b, c, d and write aSiH3 + bO2 cSiO + dHO then write linear equations for each element. The equation for Si...
-
What is a visibility symbol in UML?
-
Describe the purpose of the SUBTRACT command in relational algebra.
-
What is a shared lock? What is an exclusive lock?
-
On Cartesian axes, the x-component of a vector is generally associated with a (a) cosine, (b) sine, (c) tangent, (d) none of the foregoing.
-
What process do you follow to make decisions for these different circumstances, and are you satisfied with the results?
-
A football is thrown on a long pass. Compared to the balls initial horizontal velocity component, the velocity at the highest point is (a) greater, (b) less, (c) the same.
Study smarter with the SolutionInn App