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 的大作中提到】
: 主要fields包括：movie_name, released_date, list_of_actors,
: genre, actor_name, hometown, list_of_movies, birthday...
: 主要是list_of_actors and list_of_movies 如何在表
: 的关系中表达出来。。 谢谢。
| 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 的大作中提到】
: movie table:
: movie_id
: movie_name
: release_date
: genre
: actor table:
: actor_id
: actor_name
: hometown
: birthday
| a*******e
发帖数: 100 | 4 The combination of the two ids should be sufficient for PK.
【在 l*******9 的大作中提到】
: 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..
|
|
