what is the differances with SQL tables and relation modelling?
ratatu 0 Newbie Poster
urtrivedi 276 Nearly a Posting Virtuoso
your er diagram could be of two types
1) logical: used to understand database conceptually, may not reflect actual no of table in database. for e.g when showing many to many relation we may show only 2 related entities in diagram
2) physical: user to show all table used in database. you can say all sql tables may be mapped to physical er diagram for e.g when showing many to many relation we may show all 3 entities in diagram
debasisdas 580 Posting Genius Featured Poster
Relational modeling is the logical representation of the physical relation of the DB tables.
ratatu 0 Newbie Poster
Relational modeling is the logical representation of the physical relation of the DB tables.
thank you for helps.
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.