Question: 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
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 representative earns commission.)
CREATE TABLE store_reps
(rep_ID NUMBER (5),
last VARCHAR2 (15),
first VARCHAR2 (10),
comm CHAR (1));
Step by Step Solution
3.53 Rating (160 Votes )
There are 3 Steps involved in it
CREATE TABLE storereps rep... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12122c09_716097.pdf
180 KBs PDF File
1803_60b8c12122c09_716097.docx
120 KBs Word File
