Question: Add 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

Add 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 different datatypes. Does this cause an error when adding the constraint? Make table modifications as needed so that you can add the required constraint.

Constraint Comments Column Name Datatype PRIMARY KEY column NUMBER(8) Store_ID VARCHAR2(30) Should be UNIQUE and NOT Nam

Constraint Comments Column Name Datatype PRIMARY KEY column NUMBER(8) Store_ID VARCHAR2(30) Should be UNIQUE and NOT Name NULL VARCHAR2(30) Contact Rep_ID VARCHAR2(5)

Step by Step Solution

★★★★★

3.56 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ALTER TABLE bookstores MODIF... View full answer

blur-text-image
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)

PDF file Icon

1803_60b8c12122e20_716102.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12122e20_716102.docx

120 KBs Word File

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

Q:

Given the following narrative, develop either an activity diagram or a fully developed description for a use case of Add a new vehicle to an existing policy in a car insurance system. A customer...

Q:

1. What function(s) did the systems analysis report and the design report play in the creation of the AMCI system? 2. What precautions did Josh and Sandra take to make sure the AMCI system was stable...

Q:

In Chapter 9, you created a magic.html page that simulated the behavior of a Magic 8-Ball. As written, your page completely ignores the user's question while randomly selecting from a list of...

Q:

Week 5 in class exercises JustLee Books has become the exclusive distribuitor for a number of books. The company now needs to assign sales representatives to retail bookstores to handle the new...

Q:

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

Q:

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

Q:

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

Q:

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

Q:

1. 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...

Q:

1. Create a table named book_stores to include the column listed in the following chart. 2. Add a constraint to make sure the REP_ID value entered in the Book_STORES table is a valid value contained...

Q:

Get part numbers for parts supplied to all projects in London.

Q:

An angle is observed repeatedly using the same equipment and procedures producing the data below: 74 37'00", 74 37'10", 74 37 10", and 7436'55" Calculate the standard deviation Express your answer in...

Q:

Group A B is a large retail group selling mainly home improvement products. The following data is the revenues and costs associated with the opening of a new branch in Ceetown. \ table [ [ Branch...

Q:

5. Which type of contract has the least amount of risk for the buyer? 0. . fixed-price b. cost plus incentive fee (CPIF) c. time and material d. cost plus fixed fee (CPFF)

Q:

Given a sequence S of n elements, on which a total order relation is defined, describe an efficient method for determining whether there are two equal elements in S. What is the running time of your...

Q:

Given an array A of n integers in the range [0,n 2 1], describe a simple method for sorting A in O(n) time.

Q:

Consider the voting problem from Exercise C-12.35, but now suppose that we know the number k

Q:

Problem Unit 4: Linear Programming (graphical method) A freight company handles shipments by two corporations, A and B that are in the same city. Corporation A ships boxes that each weigh Big and...

Q:

Kaleidescope Entertainment is considering buying a machine that costs $ 5 5 7 , 0 0 0 . The machine will be depreciated over four years by the straight - line method and will be worthless at that...

Q:

Chipotle Mexican Grill, Inc. CMG 1. (a) Using Yahoo! Finance( *the above company), calculate the average of the bid price and ask price for a call option on your stock maturing on January 19, 2018...