由买买提看人间百态

topics

全部话题 - 话题: normalizae
(共0页)
l*******9
发帖数: 177
1
来自主题: Database版 - how to normalizae this database
主要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
来自主题: Database版 - how to normalizae this database
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
来自主题: Database版 - how to normalizae this database
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
来自主题: Database版 - how to normalizae this database
The combination of the two ids should be sufficient for PK.
(共0页)