BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900
Chapter 3, Problem 24P
Textbook Problem
53 views

For each table, identify each of the following when possible:

  1. a. The primary key
  2. b. A superkey
  3. c. A candidate key
  4. d. The foreign key(s)
  5. e. A secondary key

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.

Candidate Key:

A set of attributes (minimal) which can uniquely identify a record is known as candidate keys. A attribute which could’ve been a primary key but for was not chosen as primary key for some reason is a candidate key.

The value of candidate is not null for every record in database and in unique.

The candidate key can be of composite attributes and there can be more than one candidate key in a relation.

SUPER KEY:

A set of one or more columns or attributes to uniquely identify rows in a table is called super key.

A Super Key is a candidate key containing redundant attributes.

All candidate keys are super keys as candidate keys are derived from super keys.

Any primary key plus any attribute is a super key.

SECONDARY KEY:

Secondary keys are the set of attributes which are not selected as primary key but are considered to be candidate keys for the primary key of the table.

Numbers of attributes that constitute secondary key are arbitrary.

Secondary keys are also known as alternate keys.

After selecting the attributes from candidate key to form a primary key, the remaining attributes of candidate key are called secondary keys.

Explanation of Solution

Given database tables:

Table Name: CHARTER

CHAR_TRIP CHAR_DATE CHAR_PILOT CHAR_COPILOT AC_NUMBER CHAR_DESTINATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHA_HOURS_WAIT CHAR_FUEL_GALLONS CHAR_OIL_QTS CUS_CODE
10001 05-Feb-18 104 2289L ATL 936.0 5.1 2.2 354.1 1 10011
10002 05-Feb-18 101 2778V BNA 320.0 1.6 0.0 72.6 0 10016
10003 05-Feb-18 105 109 4278Y GNV 1574.0 7.8 0.0 339.8 2 10014
10004 06-Feb-18 106 1484P STL 472.0 2.9 4.9 97.2 1 10019
10005 06-Feb-18 101 2289L ATL 1023.0 5.7 3.5 397.7 2 10011
10006 06-Feb-18 109 4278Y STL 472.0 2.6 5.2 117.1 0 10017
10007 06-Feb-18 104 105 2778V GNV 1574.0 7.9 0.0 348.4 2 10012
10008 07-Feb-18 106 1484P TYS 644.0 4.1 0.0 140.6 1 10014
10009 07-Feb-18 105 2289L GNV 1574.0 6.6 23.4 459.9 0 10017
10010 07-Feb-18 109 4278Y ATL 998.0 6.2 3.2 279.7 0 10016
10011 07-Feb-18 101 104 1484P BNA 352.0 1.9 5.3 66.4 1 10012
10012 08-Feb-18 101 2289L MOB 884.0 4.8 4.2 215.1 0 10010
10013 08-Feb-18 105 4278Y TYS 644.0 3.9 4.5 174.3 1 10011
10014 09-Feb-18 106 4278V ATL 936.0 6.1 2.1 302.6 0 10017
10015 09-Feb-18 104 101 2289L GNV 1645.0 6.7 0.0 459.5 2 10016
10016 09-Feb-18 109 105 2778V MQY 312.0 1.5 0.0 67.2 0 10011
10017 10-Feb-18 101 1484P STL 508.0 3.1 0.0 105.5 0 10014
10018 10-Feb-18 105 104 4278Y TYS 644.0 3.8 4.5 167.4 0 10017

Table Name: AIRCRAFT

AC_NUMBER MODE-CODE AC_TTAF AC_TTEL AC_TTER
1484P PA23-250 1833.1 1833.1 101.8
2289L C-90A 4243.8 768.9 1123.4
2778V PA31-350 7992.9 1513.1 789.5
4278Y PA31-350 2147.3 622.1 243.2

Table Name: MODEL

MOD_CODE MOD_MANUFACTER MOD_NAME MOD_SEATS MOD_CHG_MILE
B200 Beechcraft Super KingAir 10 1.93
C-90A Beechcraft KingAir 8 2.67
PA23-250 Piper Aztec 6 1.93
PA31-350 Piper Navajao Chiettan 10 2.35

Table Name: PILOT

EMP_NUM PIL_LICENSE PIL_RATINGS PIL_MED_TYPE PIL_MED_DATE PIL_PTI35_DATE
101 ATP ATP/SEL/MEL/Instr/CFII 1 20-Jan-18 11-Jan-18
104 ATP ATP/SEL/MEL/Instr 1 18-Dec-17 17-Jan-18
105 COM COMM/SEL/MEL/Instr/CFI 2 05-Jan-18 02-Jan-18
106 COM COMM/SEL/MEL/Instr 2 10-Dec-17 02-Feb-18
109 COM ATP/SEL/MEL/SES/Instr/CFII 1 22-Jan-18 15-Jan-18

Table Name: EMPLOYEE

EMP_NUM EMP_TITLE EMP-LNAME EMP_FNAME EMP_INITIAL EMP_CODE EMP_HIRE_DATE
100 Mr. Kolrnycz George D 15-Jun-62 15-Mar-08
101 Ms. Lewis Rhonda G 19-Mar-85 25-Apr-06
102 Mr. Vandam Rhett 14-Nov-78 18-May-13
103 Ms. Jones Anne M 11-May-94 26-Jul-17
104 Mr. Lange John P 12-Jul-91 20-Aug-10
105 Mr. Williams Robert D 14-Mar-95 19-Jun-17
106 Mrs. Duzak Jeanine K 12-Feb-88 13-Mar-18
107 Mr. Deante George D 01-May-95 02-Jul-16
108 Mr. Wiesanbach Paul R 14-Feb-86 03-Jun-13
109 Ms. Travis Elizabeth K 18-Jun-81 14-Feb-16
110 Mrs. Genkazi Lieghla W 19-May-90 29-Jun-10

Table Name: EMPLOYEE

CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE
10010 Ramas Alfred A 615 844-2573 0.00
10011 Dunne Leona K 713 894-1293 0.00
10012 Smith Kathy W 615 894-2285 896.54
10013 Owolski Paul F 615 894-2180 1285.19
10014 Orlando Myron 615 222-1672 673.21
10015 OBrian Amy B 713 442-3381 1014.86
10016 Brown James G 615 297-1228 0...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

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

Get Started

Chapter 3 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
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 add
What is Hadoop, and what are its basic components?

Database Systems: Design, Implementation, & Management

Why would ISPs ban outbound port scanning by their customers?

Principles of Information Security (MindTap Course List)

What is the smallest graduation on a metric micrometer with a vernier scale?

Precision Machining Technology (MindTap Course List)

What is meant by sequential firing of fuel injectors?

Automotive Technology: A Systems Approach (MindTap Course List)

These dimensions concern transportation systems. Look up the dimensions of the following vehicles; give the mod...

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

In Sample Problem 5.5, determine Oy with one scalar equilibrium equation.

International Edition---engineering Mechanics: Statics, 4th Edition

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

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

Identify functions of the following tools: personal firewalls, hardware firewalls, antivirus programs, malware ...

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

If a cutting tip sticks in the cutting head, how should it be removed?

Welding: Principles and Applications (MindTap Course List)