1 Modify the following SQL command so that the RepID column

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 representative earns commission.) CREATE TABLE store_reps (rep_ID NUMBER(5), last VARCHAR2(15), first VARCHAR2(10), comm CHAR(1) );

Solution

CREATE TABLE store_reps

(rep_ID NUMBER(5),

last VARCHAR2(15),

first VARCHAR2(10),

comm char(1) DEFAULT \'Y\',

CONSTRAINT \"REP_ID\" PRIMARY KEY (\"REP_ID\"));