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.

  • CreatedNovember 03, 2009
  • Files Included
Post your question