Question: Assignment 3-Creating Database and Tables in Assignment Submission Folder in D2L. It is important that you specify your name in the SQL file. The attachment

 "Assignment 3-Creating Database and Tables" in Assignment Submission Folder in D2L.

"Assignment 3-Creating Database and Tables" in Assignment Submission Folder in D2L. It is important that you specify your name in the SQL file. The attachment name should follow the following convention: 1. Create database schema with name "Employee Information' (0.5 point). 2. Create 4 tables based on the logical schema below. Note: you need to define primary key(s) foreign key(s), constraints, and correct data type to get credits (8 points). Supervise Employee EmployeelD Course EmployeeFistName CourselD CouseTitle EmployeeCourse Logical Schema: SuperviorlEmployeelD SuperisorlD Course CourselD, Course Title) Legend: Primary Key: Bold and underline. Foreign Key: Italic 3- Insert 5 sample records for each table (1.5 point) "Assignment 3-Creating Database and Tables" in Assignment Submission Folder in D2L. It is important that you specify your name in the SQL file. The attachment name should follow the following convention: 1. Create database schema with name "Employee Information' (0.5 point). 2. Create 4 tables based on the logical schema below. Note: you need to define primary key(s) foreign key(s), constraints, and correct data type to get credits (8 points). Supervise Employee EmployeelD Course EmployeeFistName CourselD CouseTitle EmployeeCourse Logical Schema: SuperviorlEmployeelD SuperisorlD Course CourselD, Course Title) Legend: Primary Key: Bold and underline. Foreign Key: Italic 3- Insert 5 sample records for each table (1.5 point)

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!