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

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)

Step by Step Solution

★★★★★

3.43 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE TABLE repcontracts storeid NUMBER8 name NUMBER5 quart... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

1803_60b8c12122efd_716104.pdf

180 KBs PDF File

1803_60b8c12122efd_716104.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!

Show the SQL statement necessary to create a table named T1 with columns C1, C2, and C3. Assume that C1 is a surrogate key. Assume that C2 has character data of maximum length 50 and that C3 contains...

Create a table named Quiz as follows: The Quiz table stores multiple-choice questions. Suppose the multiple-choicequestions are stored in a text file accessible from www.cs.armstrong.edu/liang/data/...

Create a table named Salary as follows: Obtain the data for salary from?http://cs.armstrong.edu/liang/data/Salary.txt?and populate it into the?Salary?table in the database. create table Salary(...

Q: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...

6Add a constraint to make sure the Rep_ID value entered in the BOOK_STORES table is a valid value contained in the STORE_REPS table. The Rep_ID columns of both tables were initially created as...

Modify the following SQL command so that the Rep _ ID column is the PRIMARY KEY for the table and the default value of Y is assigned to the Comm column. ( The Comm column indicates whether the sales...

USING MYSQL WORKBENCH BookStore_Maged Books has become the exclusive distributor for a number of books. The company now needs to assign sales representatives to retail bookstores to handle the new...

Oracle 12c Joan Casteel. Chapter 4 - Create the SQL statements for ALL the Hands-On Assignments at the end of Chapter 4 (#1 - #10). Combine all of the SQL statements into one .sql file named...

Lab 4 - Constraints JustLee Books has become the exclusive distributor for a number of books. The company now needs to assign sales representatives to retail bookstores to handle the new distribution...

5. Create a table named BOOK_STORES to include the columns listed in the following chart. 6. Add a constraint to make sure the Rep_ID value entered in the BOOK STORES table is a valid value contained...

Suppose the coal and steel industries form an open economy. Every $1 produced by the coal industry requires $0.15 of coal and $0.20 of steel. Every $ 1 produced by steel requires $0.25 of coal and...

Paul Preppie is an accountant for the Very Big (VB) Corporation of America, located in Los Angeles. When Paul went to work for VB, he did not have a college degree. VB required that Paul earn a B. S....

What principles should be followed to write a quality report?

3. In which project procurement management process is an RFPoften written? a. planning procurements b. conducting procurements c. administering procurements d. selecting sellers

Describe and analyze an efficient method for removing all duplicates from a collection A of n elements.

Give an example input that requires merge-sort and heap-sort to take O(nlogn) time to sort, but insertion-sort runs in O(n) time. What if you reverse this list?

Given a sequence S of n values, each equal to 0 or 1, describe an in-place method for sorting S.

J. Smythe, Inc., manufactures fine furniture. The company is deciding whether to introduce a new mahogany dining room table set. The set will sell for $6,400, including a set of eight chairs. The...

The face value of a bond is $68,000, its stated rate is 7%, and the term of the bond is five years. The bond pays Interest semiannually. At the time of issue, the market rate is 8%. Determine the...

Rubenstein Bros. Clothing is expecting to pay an annual dividend per share of $0.95 out of annual earnings per share of $3.25. Currently, Rubenstein Bros.' stock is selling for $17.50 per share....