I need help with an exercise; I have three entities: Employee(id, name) , Technician ( name, city , salary) and Medic ( id, hospital, room ) . Technician and medic are linked to Employee by a is a relationship. The problem is that I dont know how to implement the IS-A in SQL.
Asked
Active
Viewed 61 times
-2
-
3You may want to check this: [How to create relationships in MySQL](http://stackoverflow.com/questions/260441/how-to-create-relationships-in-mysql) – Maxson Ndlovu Nov 08 '16 at 14:38
-
2Common please use Google or tell specific problem :-/ – Blackbam Nov 08 '16 at 15:50
1 Answers
0
I would create two new tables, each one for the 'a is a' relationship. For example: employee_technician (and employee_medic)
'employee_technician's Primary Key would consist of two columns: employee's PK and technician's PK.
D Ie
- 841
- 7
- 23