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 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
ALTER TABLE bookstores MODIF... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12122e20_716102.pdf
180 KBs PDF File
1803_60b8c12122e20_716102.docx
120 KBs Word File
