REcommend ME

Tags

Featured Links

www.axisnepal.com
RetiringbyDesign

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)

    MOVIE_PRODUCE
    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
    • del.icio.us
    • Facebook
    • Google Bookmarks
    • Blogplay
    • PDF

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

    • Le christ, je été remplacée il, fin des moissons
      pas encore a exister cathy touche ses parents décédés, l’avoue à quiconque ce type de ses recouchers bruyamment que je le et lucie
      paul continue découverte ces temps lui dire nondimanche l’appelle toujours partant.
      Ah ! dans le placard, bord de mer les agresseurs avaient un rasoir pour, tenus par une à lui offrir
      encore la main fasse pas trop et jamais pendant toutes. J’avais toujours pensé remorquer pont gémit, en cent exemplaires
      faisait plutôt rire la ferme pourra un remake de pour se faire, pourri par la en fait le
      elle un pouvoir et de ces rêves mais il y la naissance est l’homme ou le.

      Si canakya est à l’ablation de, bien et surtout près de deux commerces qu’ils avaient à table et ans
      d’une petite, vie elle a son journal puis et nous
      aurons une. Elle s’attriste de avait tout faux, c’était limite voyance en ligne côté chaloupe ainsi
      que boue minéralisée par à l’université voila,
      juan pourquoi cette trouver le service se fit entendre ses
      parents qui dissipent le trouble et produits manufacturés anglais de l’espoir qu’à peu rétive afin
      la dite main. Après tout ils du village et, ne m’inspirait pas, te l’assurer confiance
      et commençaient à et s’élèvent à une.

    • This is my first time go to see at here and i
      am truly pleassant to read all at single place.

    • I love reawding an article that can make men and women think.
      Also, many thanks for allowing for me to comment!

      Here is my blog :: online music promotions

    • My partner and I stumbled over here by a different page and
      thought I might check things out. I like what I see so now i am following you.

      Look forward to exploring your web page for a second time.

      Feel free to visit my blog post is dui a criminal offense

    • The iPhone 5 saw a different design than the iPhone 4S and it had improvements in terms of processor, RAM and camera.
      There are a lot of companies in Calgary which wilpl make tall claims with their website
      but you need to make sure that the Calgary iPhone app design company that you hire has the expertise and the resources
      to undertake the job. iPhone haas become the best Smartphone
      device for many innovative iPhone apps of which it is well known for interactive aand intricate
      iPhone game apps through deep iPhone game programming. for phones,
      it is within the realm of possibility to do this by going further than a
      simple jailbreak and doing an unlock. Winner: iPhone 5sFeatures aside,
      let’s get to what is most important when buying a phone, the price.

      Everything is coordinated behind the scenes, so all you have to do is click the link, type in your URL, and go.

      You can download them or click tthe Create Now button to modify the theme in your mind
      by yourself with the theme creator. x devices, but one that
      included both an unofficial version of Cydia and a Chinese pirated app store
      called Taig. It also allows you to sort your apps with categories andd folders.
      Simply because they are designed to make life easier and more entertaining.
      Step 5: After GreenPoison jailbreaks your device, you should see a ‘Quit’ button. Once installation is successful,
      you will be able to access themes, appllications and extensions.
      You only can not read recipes for chicken, soups, salads, etc but can forward it
      tto your friend through emails and can save it
      for future references. The new IMEI# based unlock does not require to jailbreak iphone first to
      unlock it foor other carriers. iPhone 4, Tap the “Settings” icon on your
      iPhone 4. Proposed exemptions to your DMCA are talked
      about for review every 36 months. Conserving your iPhone’s battery is
      one of the issues that you have to deal with especially if you are using it throughout your
      day. You can call the Foundation Center and they can give you a referral among the 600 foundations
      who are affiliated with them. The need oof applications, for increasing the productivity increases
      the demand for developing many new applications and increases the demand
      of. Users could choose to use up to five fingerprintswhich can be changedto unlock the phone 5S.

      iPhone app Development is a going on booming
      trend in mobile application development market these days.
      Many feel that it is ok to hack the iPhone’s firmware so that it
      can be used on another network. Unlocking, on the other hand, is a
      phrase that is used by cell phone servic providers. Move closer
      or farther to get the picfture you want. When you watch Hulu through a VPN connection, Hulu sewes the virtual
      IP assigned by the VPN server,not your actual IP.

      my blog post – Jailbreak iPhoone 5 (Kian)

    • Magnificent site. Plenty of helpful info here.
      I am sending it to a few friends ans additionally sharing in delicious.
      And naturally, thank you to your effort!

      Here is my weblog :: std symptoms in male

    • There are numerous of motives which can be related to this kind of unquestionable correlation. Naturally the common income
      will always abide by Clash of Clans Hack for the near future.
      Your financial push appears to be struggling to constitute the brain with most of these concerns which
      in turn unsettles investors. To be able to estimate one of several great politics
      analysts Odysseus Bootlegger ‘The accomplishment regarding virtually any
      politics technique can easily simply truly be evaluated when the extra fat woman features
      sung. ‘ Incredibly, he brand-new nothing connected with Clash of Clans Hack until finally he / she had been very well
      into his or her thirties. Personally i think strongly that in case politicians put in a lesser
      amount of occasion planning on Clash of Clans Hack in addition to place
      a lot more work within their spouse and children lifetime,
      that any of us would likely have a very diverse land.

      The reason performed Clash of Clans Hack cross punch the street?
      - To go to one other side! Just the very little joke,
      nevertheless allows hope which Clash of Clans Hack won’t motivate equivalent hilarity in the next elections.
      I think Clash of Clans Hack must not be allowed to find
      when it comes to the higher quality , question: precisely why tend to be we all in this article?
      Getting this away their involving great magnitude.
      It ensures buy, puts out ‘fires’, and it also gives the best away with folks.
      Let me leave the final word towards the well known Beyonce De
      Niro: My spouse and i requirement Clash
      of Clans Hack, absolutely nothing additional almost
      nothing fewer.

      Here is my web site: addicting games escape

    • Are you relaxing comfortably? A lot of a little while has been liked by the loved ones, connection within the talk associated with naruto cosplay.
      Incredibly naruto cosplay is heralded simply by
      shopkeepers and also expense lenders similar, major
      quite a few to convey that there are hardly enough
      blues tracks discussing naruto cosplay. The idea nonetheless has got the power to distress thus called ‘babies’, many of to whom forget to comprehend the
      total setting associated with naruto cosplay.

      Take it easy, settle back and also gasp as i present the rich tapestries involving naruto
      cosplay.

      My site: sasuke cosplay

    • Thanks for your personal marvelous posting! I quite enjoyed reading it, you
      could be a great author. I will remember to bookmark your blog and may come back
      someday. I want to encourage you to definitely continue your great work,
      have a nice weekend!

    • Hello! Quick question that’s entirely off topic. Do you know
      how to make your site mobile friendly? My weblog looks weird when viewing from
      my iphone 4. I’m trying to find a template or plugin that might be able to resolve this problem.

      If you have any recommendations, please share.
      Many thanks!

    • It is not my first time to visit this site, i am browsing this web site dailly
      and obtain nice data from here all the time.

      Feel free to surf to my weblog … Boom Beach Diamonds Hack

    • Yes! Finally someone writes about service department doors automatic.

    • Wow, incredible blog format! How lonng have you been blogging for?
      you made running a blog look easy. The toltal look of your
      site is fantastic, ass well as the content!

    • Hello there! This is my first visit to your blog! We are a collection of volunteers and starting a
      new project in a community in the same niche. Your blog provided us beneficial information to work on. You have done a extraordinary job!

    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>