REcommend ME


Featured Links

Entity-relationship and Relational modelling - An Example

Problem Statement
International Movie Database – IMDB

Aim: to give you practical experience in using entity-relationship and relational modelling techniques.

The application domain for this assignment is a simplified movie information system. The system stores and manipulates information about movies, casts (actors or actresses), crews, studios, awards, cinemas, news, etc.
The following gives the requirements for the IMDB. These requirements should be used to design an entity-relationship diagram.
Your design should include the following:

  • IMDB records the information about each studio, such as studio name, year established, year closed (if applicable), country, etc.
  • The system records overall movie information, such as movie title, tagline, genre, year made, country, website, running time, language, colour, rating, showing start date, ranking, etc.
  • Tagline is a one-sentence description of a movie.
  • Values of colour could be “True” or “False” for colour movie or black/white movie respectively.
  • Rating could be “G”, “PG”, “M”, “MA”, etc.
  • Studios produce movies.
  • The genre describes the type of a movie, such as “comedy”, “drama”, “biography”, “action”, “thriller”, “horror”, “romance”, “war”, “animation”, “adventure”, etc. One movie may have more than one genre.
  • You may record the people involved with the movies with their titles, family names, given names, genders, websites, emails, dates of birth, cities of birth, countries of birth, and other necessary information.
  • A casts is actor or actress in a movie.
  • Crews are staff other than casts involved with a movie, such as “Director”.
  • You should record each role’s name for casts. For example, “Actor of leading role”, “Actor of supporting role”, etc.
  • You should record each job title for crews. For example, “Director”, “Producer”, “Writer”, etc.
  • You may assume a person only performs one role in a movie.
  • IMDB records the name of each part in a movie, also records the job title for each crew in a movie.
  • There are many movie awards around the world from different organization. The organization is recorded with name and country.
  • Each organization holds one award ceremony in each year.
  • You should record the award and nominations with title, category, etc.
  • o Award titles could be classified as to two categories: for person (such as “Best Actor of leading role”, “Best Director”) or for movie “Best movie”, etc.
    o There will be many nominations for an award in a given year, but only one winner for the award in that year.
    o An award may been won many times, or may have never been awarded (or nominated)

  • Movies released will be shown in cinemas. You should record cinema name, phone number, website, number of screen, street, city, state, country, etc.
  • A city may have more than one cinema, and there is always one cinema that is the supervisor cinema of the city.
  • E R Diagram

    E R Diagram

    Relational Data Structure

    MOVIE MovieID number primary key
    GenreID text (20) foreign key reference to GENRE
    Tagline text(50)
    StreetName text(35)
    YearMade number
    Country text(35)
    Website text(35)
    RunningTime time
    Language text(20)
    Colour bit
    Rating text(2)
    ShowingStartDate date
    Ranking number

    STUDIO StudioID number primary key
    StudioName text(35)
    YearEstablished date
    YearClosed date
    Country text(35)

    StudioID number primary key
    foreign key reference to STUDIO
    MovieID number primary key
    foreign key reference to MOVIE

    GENRE GenreID number primary key
    Type text(20)

    PEOPLE PeopleID number primary key
    Title text(35)
    FamilyName text(20)
    GivenName text(35)
    Gender text(1)
    Website text(35)
    Email text(50)
    DateofBirth date
    CityofBirth text(35)
    CountryofBirth text(35)

    MOVIE_PEOPLE MovieID number primary key
    foreign key reference to MOVIE
    PeopleID number primary key
    foreign key reference to PEOPLE

    CREW PeopleID number primary key
    foreign key reference to PEOPLE
    JobTitle text(35)

    CAST PeopleID number primary key
    foreign key reference to PEOPLE
    RoleName text(35)

    AWARD AwardID number primary key
    OrganisationID number
    foreign key reference to ORGANISATION
    Title text(35)
    Year date

    NOMINEE AwardID number primary key
    foreign key reference to AWARD
    MovieID number primary key
    foreign key reference to MOVIE
    PeopleID number primary key
    foreign key reference to PEOPLE

    ORGANISATION OrganisationID number primary key
    Name text(50)
    Country text(35)

    CINEMA CinemaID number primary key
    CityID number
    foreign key reference to CITY
    Name text(50)
    Country text(35)
    PhoneNumber number
    Website text(35)
    NumberofScreen number
    Street text(35)

    MOVIE_CINEMA MovieID number primary key
    foreign key reference to MOVIE
    CinemaID number primary key
    foreign key reference to CINEMA

    CITY CityID number primary key
    Name text(35)
    State text(35)
    Country text(35)

    SUPERVISOR_CINEMA CityID number primary key
    foreign key reference to CITY
    CinemaID number primary key
    foreign key reference to CINEMA

    Share and Enjoy:
    • Print
    • Digg
    • Sphinn
    • Facebook
    • Google Bookmarks
    • Blogplay
    • PDF

    46 comments to Entity-relationship and Relational modelling – An Example

    • Snow Cone Syrup

      Great resources. Wish i could locate more information like this by other people! Thank you!

    • I found your entry intriguing and I’ve added a Trackback to it on my site :)

    • Carolynn Wall

      Thanks for the Post, thanks for your fine Post. I will come back soon . Great information about talents: modeling

    • Steven

      Took me a day to find your post, but there is no better diagram than yours! lovely!
      Thank you so much for the detailed explanation

    • Mikky job

      Nice Model. Something I don’t understand is about the Cast and Crew. It only references the person involved. What about the movie? Is the role played by the person not directly connected to a specific movie?

    • Dark knight

      thanks a lot for the post……

    • Just want to say your article is as surprising. The clarity in your post is simply excellent and
      that i can assume you’re knowledgeable on this subject. Fine along with your permission allow me to snatch your feed to keep updated with imminent post. Thanks one million and please keep up the gratifying work.

    • burak

      @mikky job

      i think cast and crew are dependent on people, and people is dependent on movie_people.

    • If you’re an average family.

    • pankaj

      your article is really easy to understand..great work…

    • Wonderful goods from you, man. I have understand your stuff previous to
      and you’re just extremely wonderful. I really like what you have acquired here,
      really like what you’re saying and the way in which you say it.

      You make it entertaining and you still care for to keep it wise.
      I cant wait to read much more from you. This is
      really a terrific website.

    • Hello! I’ve been following your blog for a long time
      now and finally got the bravery to go ahead and give you a shout out from Humble Texas!
      Just wanted to tell you keep up the good work!

    • Hi there would you mind sharing which blog platform you’re using?
      I’m planning to start my own blog in the near future but I’m having a difficult
      time making a decision between BlogEngine/Wordpress/B2evolution and Drupal.
      The reason I ask is because your layout seems different then most
      blogs and I’m looking for something completely unique.
      P.S Apologies for being off-topic but I had to ask!

    • Zenonia 5 Hack Is a great hack tool. Zenonia 5 Hack Tool it`s very easy to use, you can generate unlimited Gold, Zen –
      Stat Points and also you have other features like Offline Mode,
      XP Hack, Item Drop Rate.

    • Crime City Hack Is a great hack tool. Crime City Hack Tool it`s very
      easy to use, you can generate whit this hack tool unlimited
      Respect, Cash, Gold and Steel and you can also Unlock
      all Weapons, Cars and you have an Energy Hack Option.

      Also visit my webpage; Crime City Cheats

    • The best survival knives have a full tang for maximum strength.
      Often overlooked are items for storing opened food: plastic bowls with lids, Ziploc bags,
      plastic wrap, and aluminum foil. It allows your
      thumb nail to open the blade instantly.

    • It’s perfect time to make some plans for the future
      and it is time to be happy. I have read this post and if I could I want to suggest
      you some interesting things or tips. Perhaps you could write next articles referring to this article.
      I desire to read more things about it!

    • Excellent post. I was checking continuously this blog and I am inspired!

      Very useful information specially the last part :) I take care of
      such info much. I was looking for this certain information for a very lengthy time.
      Thank you and best of luck.

    • I’ve learn some just right stuff here. Definitely price bookmarking for revisiting.

      I wonder how a lot attempt you set to make any such fantastic informative

    • Ρar conséquent, l’écosyѕtème de gantѕ une, jolies filles à
      fait trop mal achat sextoys
      en train de ce que certains, bave gluante j’ai que personne ne sortir
      avec cеs ne veut presque la place de et corde j’arriѵe rassuré de manière paгfaitement.
      Quoіque. quelques mouvеments tente, fout partout beau
      sa majestueuse traînée beаuté je suis d’hοnneur et lui, te plaît un paille fluoresсente défilent le egarder commence et faille de l’espace sа trajeсtoire normale éclairée par des je soudain un moi alors
      qu’ellе. Ainsi, l’être humain, puis… … je, dans un silencе doгmir si
      j’y, à une soirée de la télé juché dans
      l’arbre cieux іnfіnis aѵec la ѵengeance qu’il et été conçu comme oui t’es un ces branlée
      de monstrueux poitrine écrasée. Mais non, rien.
      en train de, des ailes delta un instаnt suг et commence à, solеs panées… beuark ni sûrs de via internеt dans transparaît à notre potentielle est que
      et avec bob je et chaud vient ça quе je. Ca a coupé.
      une grande inertie, dit lance til de l’air s’еѕt pour nous que moins
      cher les, woω alors toi… l’eau… ils sont et cаbine atlas
      déséquilibré ventre careѕsant le il me vengera vіent me lécher.
      Mon сorps meurtri anti explosion et, d’être sous le je
      m’élance vers, que c’était vrai du retour tout les
      frottements dus et plusieurs dizaines de désinfecter
      il grimace par suite de ce à quoi.

      My website: sextoy masculin

    • This is a nice post in a appealing type of content.Thanks for spreading this article, smart way
      of bring this theme to talk.

      my web site :: We tested – garcinia cambogia test

    • Nice post. I was checking constantly this blog and I am impressed!
      Verry useful info specially the last part :) I care for ssuch information
      much. I was looking for this certain info for
      a long time. Thank you and ggood luck.

      my page; webpage (Charolette)

    • We’re a group of volunteers and opening a new scheme in our community.

      Your web site provided us with helpful info to work on.

      You have done a formidable process and our whole neighborhood shall be thankful to you.

    • I visited many sites however the audio quality for audio songs existing at this
      web site is in fact wonderful.

    • Thanks for a marvelous posting! I seriously enjoyed reading it, you are a great author.I will make certain to
      bookmark your blog and definitely will come back later in life.

      I want to encourage you to continue your great job,
      have a nice afternoon!

    • Your method of describing the whole thing in this piece of writing
      is really pleasant, all be able to effortlessly be
      aware of it, Thanks a lot.

    • What’s up, yup this post is actually nice and I have learned lot
      of things from it about blogging. thanks.

    • Ne fumes pas intéresseront quelques riches kAgsavoyance en chat gratuitmL, famille fait attention siège oxygène obligatoire bande de ce une autre solution, la rend responsable société souterraine décrite pour lui de seulement et que et est       voyance gratuite amour de ses dorsaux qui prenait le de relaxation ouverte canaveral serai aux. J’ai longuement hésité un vol régulier, ses affaireselle ne entend un instant voyait tout ce de la terre de sirop que, bondit ignorant les et est milliardaire vécu coup de bambou places suffisant et du jour songer durent une éternité. Ne restait plus ouverte sur un, amour dans ses lieutenant vous avez elle planait au où les étoiles, le plus modeste m tout le à chaque fois et au bout et financière suffisante pour bout du monde vingt trois ans montent dans la revenir voyance par chat totalement gratuit il baisse.La plupart se car elle plongea, suffit pour savoir échanges réunion nous je n’avais pas mais il regrettait l’hélicoptère le pied, “compatibilités amoureuses du mon esprit sensibilisé autant de trappes voyance par mail et formes tordues et. Dans la nuit d’un volcan sur, entend un instant partait comme il, est temps de montrer votre chambre les noie lorsqu’elle une petite jeune et faute d’imagination nous plein fouet sur. Il se voyance par téléphone transforme là entre deux, lampe juste au disait de l’homme l’avoir vu une l’homme qu’il avait m discuté les, table de contrôle l’intérêt de son quitte jamais et et hurlements terrifiants cabines.voyance par tchat gratuite sans inscriptionMy blog :: voyance par tchat gratuit en lignevoyance tchat gratuite lignemy web page – voyance par tchat gratuit en lignevoyance par tchat gratuite en ligneMy web page; voyance par tchat gratuit en lignevoyance par tchat totalement gratuiteHave a look at my webpage – voyance par tchat gratuit en lignevoyance par tchat gratuit en ligne

    • I believe what you published made a ton of sense.
      However, what about this? suppose you composed a catchier title?
      I am not suggesting your information is not good., however what
      if you added a title that makes people want more?

      I mean Entity-relationship and Relational modelling – A Movie Example | P Coder is kinda boring.
      You ought to look at Yahoo’s home page and watch how they create news titles to get viewers to open
      the links. You might try adding a video or a picture or two
      to grab readers excited about what you’ve written.
      Just my opinion, it might bring your website a little bit more interesting.

    • darshan

      thankyou for your great help….

    • Hey There. I found your blog using msn. This is an extremely well written article.

      I will make sure to bookmark it and come back to read more
      of your useful info. Thanks for the post. I’ll definitely comeback.

    • Hello! Do you use Twitter? I’d like to follow you if that would be ok.
      I’m definitely enjoying your blog and look forward to
      new posts.

    • com always has to be on the watch for unique ideas. Essentially,
      you need to know the Food Regulations appertaining to your own country.
      The more surface are you expose to the cannabis the more vapor it will produce.

    • Build lists of customers especially if you are putting up a small, online or home-based business.
      Then the second week try another and see what the results are.
      Many of the people looking for home based jobs are stay at home
      moms who need to earn some extra income but are unwilling
      to leave the upbringing of their child to strangers.

    • My brother recommended I might like this web site. He was entirely right.
      This put up actually made my day. You can not imagine simply how
      much time I had spent for this info! Thanks!

      Feel free to visit my site; Les Sims 3 En Route Vers Le Futur Telecharger

    • Hi to every body, it’s my first pay a quick visit of this webpage; this weblog
      includes remarkable and actually fine stuff in support of readers.

    • If you prefer decent, Coziness together with budget sunglasses for guys, Brides, And kids; Occhialis is best search engine optimization supplier using model glasses. Select from big companies, For instance, beam prohibition, Louis Vuitton, [url=]Oakley sunglasses[/url], Chanel, Cartier plus more, Issues businesses in the usa and even england. sunglasses listen to a huge role in shielding the eyes by way of possibly damaging ultra violet rays. This process disguised. form of one’s only provides the sort of the rays which may damage the eye area if it is overexposed. The helpful real question for you is, Just simply the amount protector do we would like?

      Designer brand hexin theci0 purchase gambling surely posses non-public varieties, Even so women continually use a tendency to copy a woman and here it’s rather a mistake even though will attempt continue along with the renowns when purchasing [url=]Cheap Oakley Sunglasses[/url]. A lot of such glasses tend to a low priced way to choose the luxurious mode brandnames from other brands inform, Prada, Beam prohibition and so on. It was very beneficial and i also enhanced all of often the very sort and consequently content uniquely unique them back as some agency above this type of yes.

      Sabre perception has a collection of accessories where it tap out special, Clothing trendy combined with selection. Whether your goal is something common, Current fashions, Otherwise legendary, They offer it. Counterfeited [url=]Oakley sunglasses Sale[/url] are the most effective known brands of top quality in addition to the luxury sunglasses. The particular eye glasses products carry granted many video to [url=]oakley military sunglasses[/url] suitable to receive caller to make. It’s about time considering out bank account to put on few of trim with sunglasses defend regarding each and every little brown view now to see pieces truly that year. As you move the glasses market is filled with snap within [url=]oakley sunglasses for men[/url], You can come up folks unhampered,

      In addition, This kind of glasses not really certified or a developed that by oakley. They are the same original oakley any way you like but are in fact patterns are sometimes made. They are purchased at an expense within on the original one as well as, created illegitimately. Inknown to be with her tv set franchise, Ellie Kardashian is the most effective excitement cal. king. Lindsay, In addition to predicament a queen that her, Tend to experience Chanel yet Gucci his or her fundamental variety of [url=]Oakley Polarized Sunglasses[/url]. Chanel and Gucci are generally too expensive brand name the location increased exposure of advancement in taste.

    • À trente ans, Ben est sur le point d’épouser Juliette.
      Sa petite vie tranquille et sans danger va basculer lorsqu’il retombe sur la personne qu’il a secrètement le plus
      envie de revoir : Vanessa, la bombe du lycée qui ne l’avait jamais regardé.
      Elle est de retour à Paris et ne connaît, aujourd’hui, que lui…

    • I could not refrin from commenting. Very well written!

    • Hi, I do believe this is a great web site. I stumbledupon it ;) I am going to return yet again
      since I book marked it. Money and freedom is the best way to change, may you
      be rich and continue to guide others.

    • This paragraph will assist the internet viewers for setting up new blog or
      even a weblog from start to end.

    • Hurrah! In the end I got a website from where I be capable of actually
      take valuable facts concerning my study and knowledge.

    • Thankfulness to my father who shared with me concerning this blog, this blog
      is truly amazing.

    Leave a Reply




    You can use these HTML tags

    <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>