Question

The fig shows some sample data values for an extended form of the suppliers and parts database called the suppliers parts projects database. Suppliers (S), parts (P), and projects (J) are uniquely identified by supplier number (S#), part number (P#), and project number (J#), respectively. The predicate for SPJ (Shipments) is: Supplier S# supplies part P# to project J# in quantity QTY (the combination {S#, P#, J#} is the primary key, as the figure indicates). Write an appropriate set of SQL definitions for this database. Note: This database will be used as the basis for numerous exercises in subsequent chapters.

$1.99
Sales0
Views193
Comments0
  • CreatedNovember 03, 2009
  • Files Included
Post your question
5000