DATABASES
71. 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.
You've reached the end of your free preview.
Want to read all 7 pages?
- Spring '14
- BarbaraDaly
- Databases, invoice, FileMaker, c.What SQL statement
