Question: Please, DO NOT copy your answer from other questions. Many thanks! Q10. Using the data model shown below: EMPLOYEE has Ho Lin_ TEAM IP team_no

Please, DO NOT copy your answer from other questions. Many thanks! Q10.Please, DO NOT copy your answer from other questions. Many thanks!

Q10. Using the data model shown below: EMPLOYEE has Ho Lin_ TEAM IP team_no NUMERIC (3) F emp_no NUMERIC (5) C TEAM PK (team_no) leads HO- leder * emp_no NUMERIC (5) emp_frame VARCHAR (30) emp_lname VARCHAR (30) emp_street VARCHAR (50) emp_town VARCHAR (30) emp_pcode CHAR (4) emp_dob Date emp_taxno VARCHAR (20) team_no NUMERIC (3) mentor_no NUMERIC (5) EMPLOYEE PK (emp_no) I mentored_by IF IF mentors Code a schema file to create this model in an Oracle database. You should code this in a new script file called monsoftware_schm.sql in the tut7 folder of your local repo. Test your schema out in your Oracle account, when it is working correctly, copy and paste the code back here. At the head of your script include your name, id and tutorial number. Just above your first create table statement add two DROP TABLE statements to allow the running script to drop the two tables if they currently exist

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!