Assignment 6 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 duties. For these assignments, create new tables to support the following: 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) 2. Change the STORE REPS table so that NULL values can't be entered in the name columns 3. Change the STORE REPS table so that only a Y or N can be entered in the Comm 4. Add a column named Base salary with a data 5. Create a table named BOOK STORES to include the columns listed in the following chart (First and Last) column, table. Ensure that the amount entered is above zero. Add a constraint to make sure the Rep ID value entered in the type of NUMBERC72) to the STORE REPS 6. BOOK STORES table is a Column Name Store ID Name Contact Rep ID Datatype NUMBER(8) VARCHAR2(30) VARCHAR2(30) VARCHAR2(5) Constraint Comments PRIMARY KEY column Should be UNIQUE and NOT NULI Coronel PPT Chos.ppt coronel,PPT-Ch D3.ppt