DataDriven
LearnPracticeInterviewDiscussDailyJobs

An employees table stores department name alongside department ID

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain
Data Modeling
Difficulty
medium

Problem

An employees table stores department name alongside department ID. The name depends on the ID, not the primary key. Remove the transitive dependency.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • Data Modeling Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons