BuyFind

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
BuyFind

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
Chapter 3, Problem 17P
Textbook Problem
387 views

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.

FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES

Chapter 3, Problem 17P, For each table, identify the primary key and the foreign key(s). If a table does not have a foreign

Expert Solution
Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number.

Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Explanation of Solution

Given database tables:

Table Name: TRUCK

TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUMBER
1001 501 1 32123.5 AA-332-12212-W11
1002 502 1 76984.3 AC-342-22134-Q23
1003 501 2 12346.6 AC-445-78656-Z99
1004   1 2894.3 WQ-112-23144-T34
1005 503 2 45673.1 FR-998-32245-W12
1006 501 2 193245.7 AD-456-00845-R45
1007 502 3 32013.2 AA-341-96573-Z84
1008 502 3 44213.6 DR-559-22189-D33
1009 503 2 10932.9 DE-887-98456-E94

Table Name: BASE

BASE_CODE BASE_CITY BASE_STATE BASE_AREA_CODE BASE_PHONE BASE_MANAGER
501 Murfreesboro TN 615 123-4567 Andrea D. Gallagher
502 Lexington KY 568 234-5678 George H. Delarosa
503 Cape Girardeau MO 456 345-6789 Maria J. Tallindo
504 Dalton GA 901 456-7890 Peter F. McAvee

Table Name: TYPE

TYPE_CODE TYPE_DESCRIPTION
1 Single box, double-axle
2 Single box, single-axle
3 Tandem trailer, single-axle

Primary Key and Foreign Key in the above Tables:

For Table Name: TRUCK:

Primary Key: TRUCK_NUM

“TRUCK_NUM” acts as primary key of the table because the attribute “TRUCK_NUM” is a unique ID that is assigned to every individual truck...

Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Chapter 3 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
Ch. 3 - Create the basic ERD for the database shown in...Ch. 3 - Create the relational diagram for the database...Ch. 3 - Use Figure Q3.13 to answer Questions 1317. FIGURE...Ch. 3 - Create the table that results from applying a...Ch. 3 - Write the relational algebra formula to apply an...Ch. 3 - Create the table that results from applying an...Ch. 3 - Using the tables in Figure Q3.13, create the table...Ch. 3 - Suppose you have the ERD shown in Figure Q3.18....Ch. 3 - What are homonyms and synonyms, and why should...Ch. 3 - How would you implement a l:M relationship in a...Ch. 3 - Identify and describe the components of the table...Ch. 3 - Identify the primary keys. FIGURE Q3.22 THE...Ch. 3 - Identify the foreign keys. FIGURE Q3.22 THE...Ch. 3 - Create the ERM. FIGURE Q3.22 THE CH03_THEATER...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Suppose you wanted quick lookup capability to get...Ch. 3 - What would be the conceptual view of the INDEX...Ch. 3 - For each table, identify the primary key and the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Create the ERD to show the relationship between...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Create the ERD to show the relationships among...Ch. 3 - Create the relational diagram to show the...Ch. 3 - For each table in the database, identify the...Ch. 3 - Create the ERD to show the relationship between...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Create the ERD to show the relationships among...Ch. 3 - Create the relational diagram to show the...Ch. 3 - For each table, identify the primary key and the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Identify the TRUCK tables candidate key(s). FIGURE...Ch. 3 - For each table, identify a superkey and a...Ch. 3 - Create the ERD for this database. FIGURE P3.17 THE...Ch. 3 - Create the relational diagram for this database....Ch. 3 - For each table, identify each of the following...Ch. 3 - Create the ERD. (Hint: Look at the table contents....Ch. 3 - Create the relational diagram. FIGURE P3.24 THE...Ch. 3 - Modify the ERD you created in Problem 25 to...Ch. 3 - Create the relational diagram for the design you...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying a...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions
What are some basic database functions that a spreadsheet cannot perform?

Database Systems: Design, Implementation, & Management

Why must a band saw blade be annealed after welding?

Precision Machining Technology (MindTap Course List)

As explained in the chapter, the air resistance to motion of a vehicle is determined experimentally by placing ...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Describe the functions of the hydraulic system combination valve.

Automotive Technology: A Systems Approach (MindTap Course List)

What enterprise resource planning (ERP)? What is supply chain management (SCM)?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Plug and Play Error You have connected an external hard drive to your computer so that you can back up your imp...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

List the three types of light that may be present during welding.

Welding: Principles and Applications (MindTap Course List)