Describe the different types of primary keys.
What will be an ideal response?
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. 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...
_____ usually represents a major ongoing use of cash
a. Borrowing funds b. Sales of existing noncurrent assets c. Issuance of common shares d. Acquisition of noncurrent assets, particularly property, plant, and equipment e. All of the above are major ongoing uses of cash.
As the product manager for the eatery division at Whole Foods, Jerry is responsible for analyzing sales data to help him manage his team. Today Jerry is analyzing his data using many different perspectives to identify different ways to improve his division. Which of the following common digital dashboard capabilities is Jerry using to analyze his department's success?
A. Drill-down B. Consolidation C. Pivot D. Slice-and-Dice
Briefly explain what "slotting" is. What ethical issues might arise with regard to slotting?
What will be an ideal response?
Gain sharing poses greater risk to individual employees than profit sharing.
Answer the following statement true (T) or false (F)