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
-
Andretti Company has a single product called a Dak. The company normally produces and sells 80,000 Daks each year at a selling price of $62 per unit. The company's unit costs at this level of...
-
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...
-
You have the following information for Jewels Gems. Jewels uses the periodic method of accounting for its inventory transactions. Jewels only carries one brand and size of diamonds-all are identical....
-
Selected account balances before adjustment for Foxboro Realty at December 31, 2008, the end of the current year, are as follows: Data needed for year-end adjustments are as follows: a. Unbilled fees...
-
Last year, Shirley, a single college student, made \($12,500\) in total wages, salaries, and tips. She ha \($1,200\) of federal income tax withheld. Her taxable interest was \($59.\) No one was able...
-
Partially completed T-accounts and additional information for Cardinals, Inc., for the month of November follow. Additional information for November follows: Labor wage rate was $30 per hour. ...
-
Question 1 (10 points) Saved You have accumulated some money for your retirement. You are going to withdraw $45,500 every year at the end of the year for the next 20 years. How much money have you...
-
Timp Company had the following transactions during the year: January February March 1 Ordinary shares outstanding 1 Issued a 10% share dividend 1 Issued ordinary shares in a business combination 1...
-
The Merlin rocket engines developed by SpaceX can produce 7.41 x 105 N of instantaneous thrust with an exhaust speed of 3.05 x 103 m/s in vacuum. What mass of fuel does the engine burn each second to...
-
A curling stone of mass of 18 kg is traveling at 5 m/s when it hits the opponents stone (of the same mass) at rest in the house (target area). If after the collision, the opponent's stone travels at...
-
An elastic bone is compressed 10 m by a student's weight. The student picks up a very heavy backpack and the same bone compressed by an extra 5 m. (a) How many times heavier or lighter is the student...
-
On January 1, 2024, Cullumber Ltd., a public company, purchased $672,000 of 5-year, 6% bonds at par from Bramble Corporation. Interest is received semi-annually on July 1 and January 1. Cullumber...
-
For the following provide an example of best practice that is currently being implemented in an early childhood education and care setting regarding environmental responsibility (ER) and cite the...
-
Connor Corp. has an EBIT of $980,000 per year that is expected to continue in perpetuity. The unlevered cost of equity for the company is 14 percent, and the corporate tax rate is 23 percent. The...
-
The following table shows the rates of total return in successive years from 2004 to 2008 for the Sprott Canadian Equity Fund and for the benchmark Toronto Stock Exchange S&P/TSX Composite Index. By...
-
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?
-
Comparative financial statements for the Rahul Corporation for the year ended December 31 are given below. A total of 500,000 shares of stock were outstanding. The market value of the company's stock...
-
Refer to the data in Exercise 13-15. Compute the following financial ratios for the year 2009: Data From Exercise 13-15 Comparative financial statements for the Rahul Corporation for the year ended...
-
Simply Spa Collections had a current ratio of 2.5 to 1 on December 31 of the current year. On that date, the companys assets were as follows: Required a. What was the company's current ratio on...
Study smarter with the SolutionInn App