The fig shows some sample data values for an extended form of the suppliers and parts database

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.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Discovering Advanced Algebra An Investigative Approach

ISBN: 978-1559539845

1st edition

Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke

Question Posted: