Hi all,
For representing tables,view,relationship (one to many , many
to many) etc. are there any general diagrams ? Why I try to google
Usecase samples for data modelling I get a lot unrelated results. Any
pointer to a fundamental tutorial for learning these conventions will
be helpful.
Thank you.
Krishna.

On Dec 12, 11:34 am, kkrish <clearminded.kkr...@gmail.com> wrote:
> Hi all,
> For representing tables,view,relationship (one to many , many
> to many) etc. are there any general diagrams ? Why I try to google
> Usecase samples for data modelling I get a lot unrelated results. Any
> pointer to a fundamental tutorial for learning these conventions will
> be helpful.
> Thank you.
> Krishna.

Yes. Entity-relationship models are commonly used in database
design. http://en.wikipedia.org/wiki/Er_diagram

I hope this helps.

Emory Merryman
External Concepts Guild

On 12 ÄÅË, 14:34, kkrish <clearminded.kkr...@gmail.com> wrote:
> Hi all,
> For representing tables,view,relationship (one to many , many
> to many) etc. are there any general diagrams ? Why I try to google
> Usecase samples for data modelling I get a lot unrelated results. Any
> pointer to a fundamental tutorial for learning these conventions will
> be helpful.
> Thank you.
> Krishna.

Take a look at MicroOLAP Database Designer for MySQL. You can find it
useful for modeling database structure.
http://microolap.com/products/database/mysql-designer/