• 4 hours
  • Easy

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 6/2/23

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!

Ever considered an OpenClassrooms diploma?
  • Up to 100% of your training program funded
  • Flexible start date
  • Career-focused projects
  • Individual mentoring
Find the training program and funding option that suits you best
Example of certificate of achievement
Example of certificate of achievement