Match each of the following tables from the diagram with the number of the corre

Question

Match each of the following tables from the diagram with the number of the corresponding primary key from the list of primary keys below. Assign O to any tables that are not part of the database for this diagram Possible primary keys (# indicates number) (If there are multiple primary keys associated with a table, ensure to select the number from the dropdown that corresponds to all related keys.) 1. Project # 2. Budget # 3. Budget item # 4. Employee # 5. Customer # 6. Labor category # 7. Equipment category # 8. Services category # 9. Materials type # 10. Budget item # + Labor category # 11. Budget item # + Equipment category # 12. Budget item # + Services category # 13. Budget item # + Materials type # 14. Budget # + Budget item # ables Primary Keys a. Projects b. Budgets C. Budget items d. Labor e. Equipment f. Services g. Materials h. Budget items - Labor i. Customers Budget items - Materials Budget items Services Budget items - Equipment

Explanation / Answer

Solution for the problem is given int the table below:

TABLES Primary KEYS Projects Project # Budgets Budget # Budget Items Budget Item # Labor Labor Category # Equipments Equipment Category # Services Service Category # Materials Materials Type# Budget Items-Labor Budget Item # + Labor Category # Customers Customer # Budget Items-Materials Budget Item # + Material Type # Budget Items-Services Budget Item # + Service Category # Budget Items-Equipments Budget Item # + Equipment Category #

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---