Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2016
    Posts
    2

    Help required for designing a database

    Hello everyone,

    I need to design a database for a small vocabulary application (android). This app will help people preparing for TOEFL or IELTS examination. It will contain lists of high-frequency words. I am attaching a simple schema please check and advice.

    The Schema
    HTML Code:
    Column Name	Data Type
    word_id		Int
    Word		        Varchar
    Meaning 1   	Varchar
    Meaning 2   	Varchar
    Meaning 3   	Varchar
    Usage 1		Varchar
    Usage 2		Varchar
    Usage 3		Varchar
    Thanks in advance
    Arijit
    Last edited by arijit99; 03-30-16 at 04:32.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    So what happens if say a word has more than 3 meanings
    Why do you yhink you need to create a word_id when you could perfectly happily use word itself granted not as a varchar but as a specfic size. Aside from obtuse words such as here https://en.m.wikipedia.org/wiki/Longest_word_in_English i think English words are generally less than 15 characters. Don't make the same assumption about German.

    For me id probably have an entity for word
    And an entity for definition (meaning and usage). Heck i might even be tempted to push the usage to another entity that allows you to have as many usage examples as you need for a specific meaning of a word.
    Or persist with your current design but allow duplicate word and have a single meaning and usage per row.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2016
    Posts
    2

    Thank you for your help

    Hi, I would like to thank you for your thoughts. I figured out another schema based on suggestions.

    Code:
    Word Table
    
    word_id int
    word	character
    
    Meaning Table
    
    Meaning_id int
    word_id    int
    meaning    varchar
    
    Usage Table
    
    usage_id int
    word_id    int
    usage    varchar
    Please check.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    So what do you think you need for this design.
    Have you got test data, does that data map ok to the schema.
    Do you need more than one usage definition for the same meaning. Personally i would have expected something to record the usage
    Eg Fred Smith in Colloquial English, published 1900 by OED says break and brake were used synomolously in the Railways. Eg xxxR Break van 1903. LNWR brake van 1913
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Ultimately its your system, its your design. Is there a single schema design that us right.... Doubtfull.
    You design your schema to meet your requirements. In the absence of the use case and / or detailed requirements then you leave a void for others to interpret what they think is the right approach
    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
  •