To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.
Exercise On ERD model
The cut-off date for posting to this forum is reached so you can no longer post to it.
Construct an ER Diagram for Company
having the following details :
- Company
organized into DEPARTMENT. Each department has unique name and a
particular employee who manages the department. Start date for the
manager is recorded. Department may have several locations.
- A
department controls a number of PROJECT. Projects have a unique name,
number, and a single location.
- Company's
EMPLOYEE name, ssno,
address, salary, and
birth
date are recorded. An employee is assigned to one department, but may work
for several projects (not necessarily controlled by her dept).
Number of hours/week an employee works on each project is recorded; The
immediate supervisor for the employee.
- Employee's
DEPENDENT are tracked for health insurance purposes (dependent name,
birthdate, relationship to employee).