I was studying about relationships in RDBMS.I have understood the basic concept behind mapping relation ship,but I am not able to spot them.
The three possibilities :
Don't look at relationships from a technical perspective. Use analogies and real-life examples when trying to envision relationships in your head.
For example, let's say we have a library database. A library must have books.
Book may have been written by multiple
Authors and each
Author may have written multiple
Books. Thus it is a many-to-many relationship which will reflect into 3 tables in the database.
Book must also have a
Publisher, but a
Book may only have one
Publisher and a
Publisher can publish many
Books. Thus it is a one-to-many relationship and it reflects with the
PublisherId being referenced in the
A simple analogy like this one explains relationships to their core. When you try to look at them through a technical lens you're only making it harder on yourself. What's actually difficult is applying real world data scenarios when constructing your database.