Results 1 to 5 of 5
  1. #1
    Join Date
    May 2014

    Question Noddy database design question about lists


    A very simple question but I'm going round in circles and would appreciate some help! Simplifying somewhat - I have a list of films, and each film is in zero or more languages, e.g.:
    "Film1" is in English.
    "Film2" is in French and German.
    "Film3" is in English, French and German.
    "Film4" has no language (not applicable or unknown).

    How do I model this as an ERD (I'm using Visio)? Do I need one entity for "Film", another for "Language" and another one for "LanguageGroup"??? And what are the relationships and cardinalities between these entities?

    Many thanks in advance!

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    There are multiple possible choices. What have you covered in class so far?

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Dec 2007
    Richmond, VA
    "LanguageGroup"??? do you mean a table with all the different languages grouped to gether? Something like:
    id Languages
    1 english, german
    2 english,french
    3 french,german
    4 english,french,german
    5 .................

    I would think something like:
    one entity for "Film", another for "Language"
    there would be a row in "Language" for each language the film is in.
    "Film1", English
    "Film2", French
    "Film2", German
    "Film3", English
    "Film3", French
    "Film3", German

    For Film4 you would go with no row, or if you must have it then "FILM4", N/A

  4. #4
    Join Date
    Jul 2012

    I have over 1,200 Data Models on my Database Answers Web Site and this one shows an example of the solution to your problem -
    Foreign Language Dictionaries Data Model
    In your case, a Product becomes a Film, and the table called Prod_Text_Fields holds records of which Films are available in which languages - of course, you need only the two Primary Keys.


    Barry in London

  5. #5
    Join Date
    Nov 2004
    out on a limb
    Id expect an entity for films, ons for languages and ond for the language a film is dubbed or subtitled with. The latter is an intersection table whose primary key is a composite of the primary keys of the film and language entities. Im presuming when you refer to a film having multiple languages you mean you have one film for each language.
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts