I am currently working on a small project in mySQL.I have a table called employee;ID, FirstName, ...) I want to create a sub entity of this employee table and name it chef. chef has a special attributes: chef( cuisine, shift type,..) What is the best way to achieve this? Thanks
Asked
Active
Viewed 133 times
0
-
Create separate table which is referenced to `employee` and stores employeeID and specific chief columns. – Akina Dec 08 '20 at 13:11
-
@Akina that's just one of the possible solutions – Shadow Dec 08 '20 at 13:22
-
@Shadow Of course. – Akina Dec 08 '20 at 13:24