Purchase Solution

Primary keys, candidate keys, and two dimensional tables

Not what you're looking for?

Ask Custom Question

Question 1
Distinguish between the primary key and a candidate key. Provide an example of each.

Question 2
What requirements must a two-dimensional table satisfy in order to be a relation? Provide an example of a table that is a relation.

Purchase this Solution
Solution Summary

This solution discusses primary and candidate keys, and also discusses the requirements needed for a two dimensional table in order to be a relation. References are provided for both questions.

Solution Preview

Question 1

The primary key is a candidate key that the IT professional has selected that acts to identify the rows in a table. The primary key is typically chosen based upon the amount of foreign key data that needs to be generated. The primary key is used for four distinct tasks, including identifying table rows, and then representing the rows into a relationship. The other two duties include organizing the relation of storage and for use in indexes to improve operational performance. A good use of a primary key would be a key internally generated "that has no meaning outside of the database system" (Chapple, 2012). This would then be used as an auto number to create a record identification, which would be automatically generated in specific order each time a new record is created by the user.

The candidate ...

Purchase this Solution
Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

View More Free Quizzes
Related BrainMass Solutions

  • Databases - Identification candidate keys

    Reference Figures: TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BASE TYPE The TRUCK tables candidate keys are TRUCK_NUM, BASE_CODE, and TYPE_CODE, of which the first one is the Primary Key and the other two are Foreign Keys.

  • Designing a database for university

    The same holds true for other tables. Primary Keys Keys indicated in RED are primary keys. In most of the tables there are two keys in red color indicating that these tables have composite keys.

  • Candidate keys: Choosing the right primary key

    During this, you will discover many candidate keys and issues concerning how primary keys should be defined.

  • Identification of keys and entity relationship model

    194514 Identification of keys and entity relationship model 1. Suppose that you are using the database composed of the two tables shown in Figure Q3.12. a. Identify the primary keys. b. Identify the foreign keys. c.

  • Databases - Identification of candidate key

    194674 Databases - Identification of candidate key Do the tables exhibit referential integrity? Answer Yes or No, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.

  • Accounting Information Systems: Placement of Primary Keys

    These two relational database concepts E-R diagrams and normalization facilitate to a large extent the placement of primary keys in relational tables in order to link multiple tables together. References Rob, P., & Coronel, C. (2004).

  • Process of Joining Tables Together with Primary Keys

    Tables We can select data from two tables by referring to two tables, like this: Example Who has ordered a product, and what did they order?

  • Improving Table Designs Using Normalization.

    Let's remember that, in all tables candidate keys (also known as Primary Keys) are in BOLD Let's call the below table OrderInfo table: Table OrderInfo: Order_id Order_date Customer_id Customer_name Customer_address Customer_city Customer_state

  • Custom order entry system

    Let's remember that, in all tables candidate keys (also known as Primary Keys) are in BOLD Let's call the below table OrderInfo table: Table OrderInfo: Order_id Order_date Order_Number Customer_id Customer_name Customer_address Customer_city

View More Related Solutions