Primary Key

Satisfactory Essays
AutoParts Warehouse
1.

Draw an ERD for AutoParts Warehouse indicating the types of relationships between the entities.

2.
Owns
CUSTOMER

1

VEHICLE
M

M

ORDERS

N
N
PARTS

INVENTORIES

1
STORE

M

REQUEST

M
TRANSFER

2. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.
a. PARTS (PART_NUMBER, STORE_NUMBER, PART_DESCRIPTION, QTY_ON_HAND,
COST, RETAIL_PRICE)
Candidate keys: PART_NUMBER is the only candidate key. No other field will identify parts uniquely.
Primary key: PART_NUMBER is the primary key.
Foreign key: STORE_NUMBER is a foreign key from the STORE table.
Secondary keys: There are no other potential secondary keys.
b. CUSTOMER (CUSTOMER-ID, CUSTOMER_NAME, CUSTOMER_PHONE_NUMBER,
CUSTOMER_EMAIL)
Candidate keys: CUSTOMER-ID, CUSTOMER_PHONE_NUMBER, and
CUSTOMER_EMAIL are the candidate keys. The CUSTOMER_NAME field will not identify customers uniquely because two customers may have the same name.
Primary key: CUSTOMER-ID is the primary key.
Foreign key: There are no foreign keys.
Secondary keys: CUSTOMER_NAME, CUSTOMER_PHONE_NUMBER, and
CUSTOMER_EMAIL are potential secondary fields.
c. PARTS_ORDER_DETAIL (INVOICE_ID, PART_NUMBER, DATE, SUBTOTAL,
SALES_TAXES, TOTAL, PAYMENT_METHOD)
Candidate keys: The candidate keys are INVOICE_ID and PART_NUMBER.
Primary key: Combination of the INVOICE_ID and the PART_NUMBER is the primary key. Foreign key: PART_NUMBER is the primary key of the PARTS table.
Secondary keys: PART_NUMBER, and DATE could be used as a secondary key.
d. STORE (STORE_NUMBER, ADDRESS, PHONE_NUMBER)
Candidate keys: The candidate keys are STORE_NUMBER and PHONE_NUMBER.
Primary key: The STORE_NUMBER is the primary key, while it is unique, it would not be practical to use the phone number.
Foreign key: There are no foreign keys.
Secondary keys: There are no potential secondary

You May Also Find These Documents Helpful

  • Satisfactory Essays

    HSIS FALA09 Master Patient Index and Primary Keys The Master Patient Index (MPI) is an electronic medical record system for every patient registered in a health care organization. The MPI is stored in a database and contains a unique identifier, known as the Primary Key (PK). The PK is unique and identifies each record in the database. The MPI is considered the most important resource in a healthcare facility (AHIMA). The MPI will contain the core elements about a patient such as name…

    • 385 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The key understanding after primary research is that “safety” is the major concern of the customer. The fact that they have to travel with a stranger in a cab / car discourages them from sharing a ride. But when the customers find that the ride sharing has been arranged by a well-established company, the hesitation decreases and they automatically assume credibility and safety. So the primary takeaway from this observation is to drive the ride share using Ola’s brand image. We suggest the following…

    • 430 Words
    • 1 Page
    Good Essays
  • Good Essays

    Primary Succession

    • 824 Words
    • 4 Pages

    Primary Succession Primary Succession is an ecological succession process that occurs in an environment with no prior inhabitants. Primary succession is the changes in species composition over time in a previously uninhabited environment. When primary succession begins no soil exist; rock surfaces like volcanic lava and glacier scraped rock surfaces are the platform on which primary succession begins. In figure 4.4 of the text Primary succession is happening on glacier moraine after the glacier…

    • 824 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Primary Data

    • 5379 Words
    • 22 Pages

    INTRODUCTION TO THE TOPIC: Primary research is any type of research that we go out and collect ourselves. Examples include surveys, interviews and observations. In other words information that has been collected at first hand is called primary research. It involves measurement of some sort, whether by taking readings off instruments, sketching, counting, or conducting interviews. Conducting primary research is a useful skill to acquire as it can greatly supplement our research in secondary…

    • 5379 Words
    • 22 Pages
    Powerful Essays
  • Good Essays

    Primary Groups

    • 716 Words
    • 3 Pages

    Primary groups are important not only from the individual point of view, but they are equally important from the viewpoint of society. The primary group is the birth-place of human nature. Primary groups help in the socialization of the individuals and maintain social control over them. The attitude of kindness, love, sympathy, mutual help and sacrifice which provide the cementing force to social structure is developed in the primary group. The primary group is a heaven for the individuals where…

    • 716 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Primary Reinforcers

    • 218 Words
    • 1 Page

    Latoya, I agree with primary reinforcers being a benefit or reward, in addition to secondary reinforcers being more like a "motivator" (Cloninger, S. 5th Ed., 2013). Therefore, this behavior is infact learned, trained and conditioned. Common examples of primary reinforcers are water, food, sleep, sex and air. Primary reinforcers are biological, genetic and a result of an evolutionary process. One thing that sets primary reinforcers apart from secondary, is the fact that primary reinforcers are not…

    • 218 Words
    • 1 Page
    Good Essays
  • Satisfactory Essays

    The primary clinic

    • 414 Words
    • 2 Pages

    Assignment 1: The Primary Care Clinic Due Week 4 and worth 150 points A small primary care clinic has 69 employees, representing 9 different clinical professions and 12 other skills. It operates two (2) sites, one (1) of which is bigger and has the departments for medical specialists, diagnostic labs, and patient services. The clinic also contracts for a variety of services, such as repair and maintenance, referral specialists, and advanced diagnostic services. You are the manager. You report…

    • 414 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Primary Markets

    • 754 Words
    • 4 Pages

    Free Pricing Regime * Before 1992, Regulator of new issues was CCI (Controller of Capital Issues) * Approval from CCI for raising funds in Primary markets was essential. * Timing, Quantum and Pricing of the issue was decided by the controller. * New Companies could issue shares only at par and the existing companies with substantial reserves could issue shares at premium. * Fixed Price mechanism results in under pricing of many issues. Thus after 1992, promoter and the merchant…

    • 754 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Primary Sector

    • 103 Words
    • 1 Page

    Primary Sector - this involves acquiring raw materials. For example, metals and coal have to be mined, oil drilled from the ground, rubber tapped from trees, foodstuffs farmed and fish trawled. This is sometimes known as extractive production. Secondary - this is the manufacturing and assembly process. It involves converting raw materials into components, for example, making plastics from oil. It also involves assembling the product, e.g. building houses, bridges and roads. Tertiary - this refers…

    • 103 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Primary Care

    • 858 Words
    • 4 Pages

    The Primary Care Clinic Dana E. Wilson Prof. Terese Cole HSA 300 Health Service Organization Management October 29, 2013 Our healthcare facility provides primary and comprehensive care for patients that include women, men and young adults in a metro area that has a population of over 200,000 people. We also have expanded our practice to offer specialized care in Obstetrics and Gynecological services. We have multiple locations in the area in order to provide services…

    • 858 Words
    • 4 Pages
    Good Essays