100%(7)7 out of 7 people found this document helpful
This preview shows page 1 - 3 out of 7 pages.
DATABASES71. Databases.a. Briefly describe the two key situations discussed in lecture in which using a multi-table relational database is preferable to placing all the data in a single table and explain why it is preferable.b. You are given a project to do, and you know that you want to use either a spreadsheet or a database. How do you decide which one to use? Give two significant and distinct reasons for picking one rather than the other.72. Consider the following database, which is used to manage invoices and inventory for a small mail-order business. The Inventory table records carried by the business. An invoice is prepared each tine an order is placed. a. In the diagram above, underline the field(s) comprising the primary key of each table.