Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

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

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question