SQL-table-normalization.scala

Employee: {
  name: String
  birthDate: Date
  children: Table {
    name: String
    birthDate: Date
  }
  jobHistory: Table {
    jobTitle: String
    salaryHistory: Table {
      data: Date
      salary: Salary
    }
  }
}

// normalization =>

Employee: {
  PK employeeId: Id
  name: String
  birthDate: Date
}

Children: {
  PK childrenId: Id
  FK employeeId: Id
  name: String
  birthDate: Date
}

JobHistory: {
  PK jobHistoryId: Id
  FK employeeId: Id
  jobTitle: String
}

SalaryHistory: {
  PK salaryHistoryId: Id
  FK jobHistoryId: Id
  data: Date
  salary: Salary
}