Create database schema with name 'Employee Information' 2. Create 4 tables based on the logical schema below. Note:

1. Create database schema with name 'Employee Information'

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 ).

Logical Schema:

Employee(EmployeeID, EmployeeFirstName, EmployeeLastName)

Supervior(EmployeeID, SupervisorID)

Course(CourseID, CourseTitle)

EmployeeCourse(EmployeeCourseID, EmployeeID, CourseID, DateCompleted)

Legend:

Primary Key: Bold and underline.

Foreign Key: Italic

3. Insert 5 sample records for each table