# For each table, identify each of the following when possible: a. The primary key b. A superkey c. A candidate key d. The foreign key(s) e. A secondary key

### Database Systems: Design, Implemen...

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

Chapter
Section

### 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: a. The primary key b. A superkey c. A candidate key d. The foreign key(s) 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

Find more solutions based on key concepts
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)