IT Management assignment on: Programming and data relations

AssumptionOnly 1 studio produces movies and one studio can produce many movies at a time

Movie belongs to one single country.

Organisation also belongs to one single country.

Normalized relations of the data

Studio (Studio_id, Studio_name, Studio_year_opened, Studio_year_closed, Studio_country)

Studio is in 3NF because each field s either part of the key or provides a (single-valued) fact about exactly the whole key and nothing else. Movie_data (Movie_id, Movie_name, Movie_tagline, Movie_genre, Movie_released, Movie_country, Movie_running_time, Movie_language, Movie_colour, Movie_rating, Movie_ranking, Movie_launch_date, Studio_id)

Movie_data is in 3NF because each field s either part of the key or provides a (single-valued) fact about exactly the whole key and nothing else.

Country (Country_id, Country_name)

Country is in 3NF because each field s either part of the key or provides a (single-valued) fact about exactly the whole key and nothing else.

Person (Person_id, Movie_id, real_name, pen_name, Gender, Website, Emails, DOB, Birth_city, Birth_country, Movie_role, Name_in_movie)

Person is in 3NF because each field s either part of the key or provides a (single-valued) fact about exactly the whole key and nothing else.

Cinema (Cinema_id, Cinema_name, Cinema_contact_num, Cinema_website, Num_of_screen, Cinema_street, Cinema_city, Cinema_state, Cinema_country, Movie_id)

Cinema can have multiple Movie_id so it has to be converted into 1NF and after that 2NF.

Therefore it can be broken into two parts

Cinema (Cinema_id, Cinema_name, Cinema_contact_num, Cinema_website, Num_of_screen, Cinema_street, Cinema_city, Cinema_state, Cinema_country)

Cinema_movie (Cinema_id, Movie_id)

Now both of them are in 3NF

Nomination (Nomination_id, Nomination_title, Nomination_movie_id, Nomination_people_id, Award_id, Organization_id)

Nomination has to be converted into 1NF as more than one movie and person can be nominated for single award.

Nomination (Nomination_id, Nomination_title, Award_id, Organization_id)

Nomination_movie (Nomination_id, Nomination_movie_id, Nomination_people_id)

Now both of them are in 3NF

Awards (Award_id, Award_name, Organization_id, Nomination_id, Winning_Movie_id, Winning_People_id, Award_Launch_date)

Awards is in 3NF because each field s either part of the key or provides a (single-valued) fact about exactly the whole key and nothing else.Organization (Organization_id, Organization_name, Organization_country)

Organization is in 3NF because each field s either part of the key or provides a (single-valued) fact about exactly the whole key and nothing else.

  If you want IT management Assignment Help study samples to help you write professional custom essay’s and essay writing help.

Receive assured help from our talented and expert writers! Did you buy assignment and assignment writing services from our experts in a very affordable price.

To get more information, please contact us or visit www.myassignmenthelp.Com