Social Work homework help

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: Italic3. Insert 5 sample records for each table