Writing SQL Statements for the following tasks

$1.$ Create a table named $$yourfirstname$\_$store$\_$reps$$ with the following columns:

CREATE TABLE yourfirstname$\_$store$\_$reps $($

rep$\_$id NUMBER$(5),$

last VARCHAR$2(15),$

first VARCHAR$2(10),$

comm CHAR$(1))$;

Modify the table so that $$rep$\_$id$$ is the PRIMARY KEY and the $$comm$$ column has a default value of $$Y$.($The $$comm$$ column indicates whether the sales representative earns commission$).$

Write your SQL code here.

$2.$ Modify the $$yourfirstname$\_$store$\_$reps$$ table to ensure that NULL values cannot be entered in the $$first$$ and $$last$$ columns.

Write your SQL code here.

$3.$ Modify the $$yourfirstname$\_$store$\_$reps$$ table so that only a $$Y$$ or $$N$$ can be entered in the $$comm$$ column.

Write your SQL code here.

$4.$ Add a column named $$base$\_$salary$$ with a datatype of NUMBER$(7,2)$ to the $$yourfirstname$\_$store$\_$reps$$ table. Ensure that values entered are above zero.

Write your SQL code here.

$5.$ Create a table named $$yourfirstname$\_$book$\_$stores$$ with the following structure:

Column Names Data Types Constraints

store$\_$id NUMBER$(8)$ PRIMARY KEY

name VARCHAR$2(30)$ UNIQUE, NOT NULL

content VARCHAR$2(30)$

rep$\_$id VARCHAR$2(5)$

Write your SQL code here.

$6.$ Ensure that the $$rep$\_$id$$ in the$$ yourfirstname$\_$book$\_$stores$$ table references a valid value in the $$yourfirstname$\_$store$\_$reps$$ table. Make necessary modifications if the datatypes of $$rep$\_$id$$ are different in both tables.

Write your SQL code here.

$7.$ Modify the constraint created in the previous question $6$ so that deleting a row in the $$yourfirstname$\_$store$\_$reps$$ table automatically deletes associated rows in yourfirstname$\_$book$\_$stores$$ table $.$

Write your SQL code here.

$8.$ Create a table named $$yourfirstname$\_$rep$\_$contracts$$ with the following structure and constraints:

$$ Columns: store$\_$id $($NUMBER$(8)),$ name $($VARCHAR$2(5)),$ quarter $($CHAR$(3)),$ rep$\_$id $($NUMBER$(5)).$

$$ Assign a composite PRIMARY KEY to $$rep$\_$id$,$store$\_$id$,$ and $$quarter$,$ and add FOREIGN KEY constraints to $$rep$\_$id$$ and $$store$\_$id$.$

Write your SQL code here.

$9.$ Display information about all existing constraints on the $$yourfirstname store$\_$reps table$.$

Write your SQL code here.

$10.$ Issue commands to disable and then enable the CHECK constraint on the $$base$\_$salary$$ column added in question $4.$

Write your SQL code here.