how to normalizae this database - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to normalizae this database

how to normalizae this database# Database - 数据库

l*92007-07-05 07:07

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*e2007-07-05 07:07

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*92007-07-05 07:07

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*e2007-07-05 07:07

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..