Consider an automobile dealership with three locations. Data fields exist for the stock number,...

Question:

Consider an automobile dealership with three locations. Data fields exist for the 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.

Database Table Keys:

Database tables have different types of keys. There are PRIMARY keys, CANDIDATE keys, FOREIGN keys, and SECONDARY keys. PRIMARY keys uniquely define a record, and can be automatically incremented upon insertion with an IDENTITY, or can be a natural key occurring in the data that makes the record unique, such as SSN.

Answer and Explanation: 1

Become a Study.com member to unlock this answer!

View this answer

PRIMARY key:

Vehicle identification number


Potential CANDIDATE key:

Stock number

Vehicle identification number


FOREIGN keys:

Location

Mak...

See full answer below.


Learn more about this topic:

Loading...
What is a Database Index? - Definition & Tutorial

from

Chapter 6 / Lesson 10
12K

Take a look into the definition of a database index, a comparison of spreadsheets and database indexes, a full-text search engine comparison, a tutorial of database index types, and some categories of database indexes.


Related to this Question

Explore our homework questions and answers library