a********9 发帖数: 129 | 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一点不懂,想问下各位这题答案。。
还有就是难不难,如果是很入门的话我就想粘个答案上去然后如果有电面就突击争取糊
弄过去,如果难的话就准备老老实实说不会算了。。
求帮助。。 | c**m 发帖数: 535 | 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 | a********9 发帖数: 129 | 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
|
|