(Extra Credit) Match each of the following common field names with the attribute

Question

(Extra Credit) Match each of the following common field names with the attribute description that best fits. (use each answer only once) social security number in a corporate payroll database date of birth in customer file used at a pharmacy last name and first name of students at Uofl sales transaction ID at a loca Yzip code for residential addresses in a shipping database primary key - indexed (no duplicates) ) B C long text auto number incremented (no duplicates short text- reduced from 255 bytes to only 40 to conserve storage retail supermarket space compound key - indexed (duplicates OK) alternate key-indexed (duplicates OK) integer - 9 digits, validated using USPS data street address for a local business family medical history in a patient database total sales amount (including applicable taxes) on an invoice H. currency - 2 decimal places record

Explanation / Answer

Social Security number in carporate payroll database A. Primary key - indexed (no duplicates) date of birth in customer file used at pharmacy E. Compound key - indexed (duplicates OK) last name and first name of students at UofL F. alternate key - indexed (duplicates OK) sales transaction ID at a local retail supermarket B. Auto number- incremented (no duplicates) Zip code for residential addresses in a shipping database G. Integer - 9 digits, validated using USPS data. street address for a local business C.Short text- reduced from 255 bytes to only 40 to converse storage space. Total sales amount(including applicable taxes) on an invoice record H. Currency 2 decimal places

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.