The Movie database for the final project will have the four tables shown above. Begin with MovieRating, since this is the simplest table in the database. It is a lookup table of all the MPAA Rating Codes (plus NR for Not Rated) and it has two fields: RatingID and Rating. Once created it should be populated with the following records:

MovieRating
RatingIDRating
0NR
1G
2PG
3PG-13
4R
5NC-17


Some of the characteristics you associate with movies are in the table, Movie. They represent most of the data types associated with a relational database. The MovieID is a unique number that identifies a single movie, Title is a text field containing the movie title, YearReleased is the year the movie was first released, RatingID is a foreign key associated with the Rating in the MovieRating table, and the remaining fields are Boolean variables (Yes/No) to identify movies that are in black and white, and foreign films with subtitles. Once created it should be populated with the following records:
Movie
MovieIDTitleYearReleasedRatingIDBWSubtitles
1Quiet Man, The19521
2McLintock!19633
3Thin Man, The19340TRUE
4Tampopo19854TRUE


An important part of any movie database is the cast. The table Cast contains information about the actors from the movies listed. Beside the name of the actor (LastName and FirstName) we will include the Date of Birth (DOB) and Date of Death (DOD). Once created it should be populated with the following records: 
Cast
CastIDLastNameFirstNameDOBDOD
1WayneJohn5/26/19076/11/1979
2O’HaraMaureen8/17/1920
3PowellWilliam7/29/18923/5/1984
4LoyMyrna8/2/190512/14/1993
5YamazakiTsutomu12/2/1936
6MiyamotoNobuko3/27/1945
7WatanabeKen10/21/1959


Finally, since there are usually many actors in a single movie, and a single actor is usually in many movies, we need to construct an intersection table named MovieCast that relates the actors with the movies they were in. We will also include the character name of the actor in that movie. Once created it should be populated with the following records:
MovieCast
MovieIDCastIDPersona
11Sean Thornton
12Mary Kate Danaher
21George Washington McLintock
22Katherine Gilhooley McLintock
33Nick Charles
34Nora Charles
45Goro
46Tampopo
47Gun


Feel free to add your own movies and actors to these tables; just remember to include entries in MovieCast.

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 12:05 AM My Price 8.00

-----------

Attachments

file 1495673984-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer