Assignment 3 - Creating Database and Tables Fall 2021 The due date for the assignment 3 is 10/8/2021 (midnight). It must be submitted through the "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: BUSA526 ASSIGNMENT3 FIRSTNAME LASTNAME.SQL 1. Create database schema with name 'Employee Information' (0.5 point). 2. Create tables based on the ERD schema. Note: you need to define primary key(s), foreign key(s), constraints, and correct data type to get credits (8 points). -Manager Employee JobPromotion EmployeelD JobPromotionID OF Name (FN, LN) JobPromotionStartDate {CompanyPosition} JobPromotionEnd Date 3. Insert 5 sample records for each table (1.5 point) The following criteria will be used to grade the assignment