Get some practice by designing an ERD

It's your turn!

You're ready to design an employee database!

You've been hired as a freelancer by a company of 50 employees to design a logical database model.

Create a single ERD to design a database with the following tables:

• Employee (with all contact information plus an attribute referencing )

• Department (DepartmentID, DepartmentName, etc)

• Customers (Similar contact information as Employee)

• Dependents (this would be the dependents of the employee, so include the attributes EmployeeID)

Define the tables (Entities), attributes, data types, and any default data. Also indicate the primary and foreign keys.

Good luck! 😎

Check your work!