StoreSore_Name	Store_Mgr	Emp_Id	Hours_per_week	Revenue	Opening_Date	Emp_Salary	Emp_super	Emp_Dept	Rating
Pink_store	Bob	E-11	25	300000	1/15/2015	60000	Alice	10	9
Pink_store	Bob	E-5	40	300000	1/15/2015	55000	Bob	12	8
Pink _Store	Bob	E-6	10	300000	1/15/2015	43000	Alice	10	8
Blue_store	Alice	E-11	15	500000	3/1/2014	60000	Alice	10	7
Blue _store	Alice	E-6	30	500000	3/1/2014	43000	Alice	10	9
Blue _store	Alice	E-2	40	500000	3/1/2014	45000	Bob	15	9

You can make the following assumptions:

1. Each store has one manager
2. Each employee has one supervisor
3. Many employees are assigned to each store. The attribute Hours tells the number of hours each employee has worked on the corresponding store per week and the attribute rating is the rating that this employee received for his work on this store.
4. Revenue and opening date refer to the store

Create the DDL scrips for the 3NF schema that you just developed. This means that you need to write the SQL statements that will create the tables on oracle database.

You should also create for each table primary keys and foreign keys.

Now implement the 3NF relational schema on oracle database using the DDL scripts.

Insert the sample data.