Question 1 ,3,5 & 8 only

0 Life Wireless 9:49 PNM irantuto.com tablename ao (cONSTRAISIE conatraintnanel PRIMARY KEY above is valid syntax Hands-On of books. The company now needs to assign sales representatives to retail bookstores to handle the new distribution des For these assignments, creane new tables to support the following !. Modity te tolowing SQL command sothat the Repcolumn is he PRIMARY PEY for he table and the detauit value of Y is assigned to the Comm column. (The Comm eou ndicates whether the sales representative eams commission) CREATE TABLR store reps Laat VARCHAR2 (15) tlEst VARCHAR2(0 Constraints 2. Change the STORE REPS table so that NULL vallues can't be entered in the name 3. Change the STORE REPS table so that only a Y or N can be entered in the Comm 4. Add a coumn named Base salary with a datatype of NUMBER(T 2) to the STORE REPS 5. Create a table named BOOK STORES to include the columns listed in the tollowing chart columns (First and Las table Er Pat the amount enlered above zero. 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 ntially created as dnerert daarees. Does this cause an error when adding constrain? Make table moditications as needed so that you can add the required constrant Datatype PRIMARY XY 7. Change the constant created in Ass gr ert#6se that assocated rows at the BOOKSTORES table ase dind automascally if a row in the STORE REPS table 8. Create a table named REP CONTRACTS containing the columns isted in the tollowing chart. A composite PRIMARY KEY constraine including he Rep ID, Store.ID, and Quarter columns should be assigned In addsion, FOREIGN KEY constraints should be assigned to both the Rep D and Stose D columns. Column Name Datatype Produce a list of intormation about all existing constraints on the STORE REPS table 0 Issue the commands to dsable and then enable the CHECK constraint on the Base slary