Redian新闻
>
问一道online test的database题。。。
avatar
问一道online test的database题。。。# JobHunting - 待字闺中
a*9
1
1家小公司的online test,上网查了下貌似题目不变的。。
其中1道database题:
IMDB 2.0 - Movie DB Table Structure
Your best friend Betty thinks IMDB (www.imdb.com) is too complicated and
challenges you to create a simple movie web site. One page will display
movies (with movie name, date it was released, and list of actors). Click on
an actor and you’re taken to the actor page (with actor name, birthday,
bio, and list of movies actor has been in). Please outline the table
structure of the database for this.
应该就是写个schema吧,由于我对database一点不懂,想问下各位这题答案。。
还有就是难不难,如果是很入门的话我就想粘个答案上去然后如果有电面就突击争取糊
弄过去,如果难的话就准备老老实实说不会算了。。
求帮助。。
avatar
c*m
2
试着答一下~~
Tables:
Movies (Movie_ID, Movie_Name, Description, Date_Released) primary key is
Movie_ID
Actors (Actor_ID, Actor_Name, Birthday, Bio) primary key is Actor_ID
Movie_Actor (Movie_ID, Actor_ID, Actor_Role) primary key is (Movie_ID,
Actor_ID), and foreign keys are Movie_ID and Actor_ID
And there is a "many to many" relationship for Movies -> Movie_Actor Actors
avatar
a*9
3
灰常感谢!!!

【在 c**m 的大作中提到】
: 试着答一下~~
: Tables:
: Movies (Movie_ID, Movie_Name, Description, Date_Released) primary key is
: Movie_ID
: Actors (Actor_ID, Actor_Name, Birthday, Bio) primary key is Actor_ID
: Movie_Actor (Movie_ID, Actor_ID, Actor_Role) primary key is (Movie_ID,
: Actor_ID), and foreign keys are Movie_ID and Actor_ID
: And there is a "many to many" relationship for Movies -> Movie_Actor : Actors

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。