Employee(EID*, First Name, Last Name, SIN^, Address, Phone, BirthDate, Salary, DepartmentID@)

* = primary key.
@ = foreign key.
^ = unique field.

Customer(CustID*, CustName)
Order(OrderID*, CustID@, Date)
or
Order(OrderID*, CustID@[Customer.CustID], Date)

Employee(EID*, First Name, Last Name, SIN^, Address, Phone, BirthDate, Salary, DepartmentID@, Supervisor@[Employee.EID])
Project(PID*,ProjectName)

Employee_Project(EID*@,PID*@,StartDate)

Course(CrsCode*, DeptCode, Description)
Class(CrsCode*@, Section*, ClassTime…)