Member Avatar for jayanandan

I am designing my own site to learn English words. Attached is the image of my DB design. Can some one suggest/direct me to design the DB more perfectly?

easy_english.jpg 283.17 KB
Edited by jayanandan because: spell check
  • 2 Contributors
  • 4 Replies
  • 136 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by jayanandan
Member Avatar for debasisdas

Before i look into the ER let me know how you are going to use this in your application.

Member Avatar for jayanandan

Hi thanks for the reply. I am planning to learn words. So word(ee_word) is the root one.
what type(noun,adjective,verb) of word(ee_type)
label to categorize(ee_word_label,ee_label)
note and picture about the word(ee_note,ee_picture)
related-word to word(ee_word_word,ee_relationship)
story to comprise learned words(ee_story,ee_story_word)

Member Avatar for debasisdas

That ER looks impressive.

May need some minor modification.

Member Avatar for jayanandan

Thanks debasisdas. if it needes any modification, yes please u can advice me.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.