l*******9
发帖数: 177 | 1 主要fields包括：movie_name, released_date, list_of_actors,
genre, actor_name, hometown, list_of_movies, birthday...
主要是list_of_actors and list_of_movies 如何在表
的关系中表达出来。。 谢谢。 |
|
a*******e
发帖数: 100 | 2 movie table:
movie_id
movie_name
release_date
genre
actor table:
actor_id
actor_name
hometown
birthday
movie_actor table:
movie_id
actor_id |
|
l*******9
发帖数: 177 | 3 thanks, sounds good. so in the movie_actor table,
the PK should be the combination of two ids, right?
do I need an unique id in this table for sometimes
easy-query? If I do so, it seems not 3NF then..
thanks again.. |
|
a*******e
发帖数: 100 | 4 The combination of the two ids should be sufficient for PK. |
|
