Create a table named REP_CONTRACTS containing the columns listed in the following chart. A composite PRIMARY KEY

Question:

Create a table named REP_CONTRACTS containing the columns listed in the following chart. A composite PRIMARY KEY constraint including the Rep_ID, Store_ID, and Quarter columns should be assigned. In addition, FOREIGN KEY constraints should be assigned to both the Rep_ID and Store_ID columns.

Column NameDatatype NUMBER(8) Store_ID NUMBER(5) Name Quarter CHAR(3) Rep_ID NUMBER(5)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: