BuyFindarrow_forward

Systems Analysis and Design (Shell...

11th Edition
Scott Tilley + 1 other
ISBN: 9781305494602

Solutions

Chapter
Section
BuyFindarrow_forward

Systems Analysis and Design (Shell...

11th Edition
Scott Tilley + 1 other
ISBN: 9781305494602
Textbook Problem

Consider an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year color, and invoice cost Identify the possible candidate keys, the likely primary key, a probable foreign key, and potential secondary keys.

Program Plan Intro

Identify the possible candidate keys, the likely primary key, a probable foreign key, and a potential secondary key for the given situation.

Program Explanation

Given information:

Consider an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year, color and invoice cost. Identify the possible candidate keys, the likely primary key, a probable foreign key, and a potential secondary key.

Explanation:

Primary key: Primary key is defined as the attribute in a table which can uniquely identifies all the row of tables. For the given scenario, the primary key would be that field which can identify uniquely a single vehicle. Therefore, vehicle identification number can act as proper primary key since it can identify every vehicle.

Candidate Key: Candidate key is a single attribute or a set of attributes that uniquely identify tuples or record in a database. There can be more than one candidate key for a table among which minimum candidate key can be selected as primary key...

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

Additional Engineering Solutions

Find more solutions based on key concepts

Show solutions add

What is structural independence, and why is it important?

Database Systems: Design, Implementation, & Management

What is a project plan? List what a project plan can accomplish.

Principles of Information Security (MindTap Course List)

How would you model Question 6 with an OODM? (Use Figure 2.4 as your guide.)

Database Systems: Design, Implementation, & Management

Why is high voltage needed to establish a spark across the gap of a spark plug?

Automotive Technology: A Systems Approach (MindTap Course List)

For Example 19.4, determine the probability that it will take a person between 5 and 10 minutes to assemble the...

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

What is a mandatory access control?

Management Of Information Security

Explain how to eject removable storage media safely.

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

What is a twist ratio, and why is it important?

Network+ Guide to Networks (MindTap Course List)