CS 200 Review Databases.docx - DATABASES 71 Databases a Briefly describe the two key situations discussed in lecture in which using a multi\u00adtable

CS 200 Review Databases.docx - DATABASES 71 Databases a...

This preview shows page 1 - 3 out of 7 pages.

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.
Image of page 1
Image of page 2
Image of page 3

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture