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. 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
Get step-by-step solutions from verified subject matter experts
