Sunday, 29 September 2013

Primary-, foreign keys and relationship model

Primary-, foreign keys and relationship model

For my homework, we need to create a sql database model on paper, but I'm
stuck at the following subject:
We have different people, with some data assigned to them:
Person table:
person_id (Primary key)
person_name
person_number
.....
Now we have to create a talent table, for every person has some kind of
talent (IT, Art, singing, ...) and it has to be linked somehow. The catch
here is that a person can have multiple talents(IT and art together).
What's the best way to create this relationship between those 2 tables?

No comments:

Post a Comment