Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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 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 Store ID PRIMARY KEY column Datatype NUMBERS VARCHAR2(36 VARCHAR2(30) Same Should he UNIQUE and NOT NULL Contact Rep D VARCILAR2(5) 7. Change the constraint created in Assignment #6 so that associated rows of the BOOK_STORES table are deleted automatically If a row in the STORE_REPS table is deleted. 8. 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 Name Datatype Store_ID NUMBER(8) Name NUMBER(5) Quarter CHAR(3) Rep_ID NUMBER(5) 9. Produce a list of information about all existing constraints on the STORE_REPS table. 10. Issue the commands to disable and then enable the CHECK constraint on the Base salary column

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

What is cost plus pricing ?

Answered: 1 week ago

Question

1. What are the types of wastes that reach water bodies ?

Answered: 1 week ago

Question

Which type of soil has more ability to absorb water?

Answered: 1 week ago