• 4 hours
  • Easy

Free online content available in this course.



Got it!

Last updated on 5/25/20

Get some practice by designing an ERD

Log in or subscribe for free to enjoy all this course has to offer!

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!

Example of certificate of achievement
Example of certificate of achievement