Describe the different types of primary keys
A natural key (also called a logical key or an intelligent key) is a primary key that consists of a column that uniquely identifies an entity, such as a person's Social Security number, a book's ISBN (International Standard Book Number), a product's UPC (Universal Product Code), or a vehicle's VIN (Vehicle Identification Number). If a natural key does not exist for an entity, it is common to create a primary key column that will be unique and accessible to users. A column that you create for an entity to serve solely as the primary key and that is visible to users is called an artificial key. The final type of primary key, which is called a surrogate key (or a synthetic key), is a system-generated primary key that is usually hidden from users. When a DBMS creates a surrogate key, it is usually an automatic numbering data type, such as the Access AutoNumber data type.
You might also like to view...
On October 1, Black Company receives a 6% interest bearing note from Reese Company to settle a $20,000 account receivable. The note is due in six months. At December 31, Black should record interest revenue of
A) $0 B) $100 C) $300 D) $600
Which of the following is most associated with financial accounting?
A) Can have both objective and subjective information. B) Can be prepared periodically, or as needed. C) Prepared in accordance with GAAP D) Can be prepared for the entity or segment.
Cross subsidies:
a. occur when high–volume products are assigned less than their fair share of overhead costs. b. occur when low–volume products are assigned more than their fair share of overhead costs. c. are eliminated by volume–based costing systems. d. cause distorted cost information for pricing decisions.
Joe wanted to join a union so that he could take advantage of the equality and teamwork brought about through union membership. Joe was motivated by
A. dissatisfaction with management. B. political needs. C. economic needs. D. social and status needs.