Interested to Buy Any Domain ? << Click Here >> for more details...
How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
- 1 Answers
- 9933 Views
- Flextronics, Hexaware, SQL Star, I also Faced
- E-Mail Answers
Answer Posted / ramesh
One to one
Parent Entity does have one Corresponding record in Child
Entity
ex : Employee and his CV
One to many
Parent Entity does have many Corresponding records in Child
Entity
ex : Employee and his Projects
many to many
Parent Entity records do have many Corresponding records in
Child Entity vice versa
ex : Employees and Employers
Employees Receive Calls from Many Employers
Employers Receive CVs from Many Employees
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
State the acid rules?
What is data modeling with example?
Explain the process of the user request and data generating?
What is dbms explain in brief?
In which database can extended stored procedures be added?
What is the physical representation for a many-to-many relationship?
What is the maximum length of an extended property?
What are the main phases of database development?
What is a database development?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What are the 18 schemas?
How to customize error conditions.
Explain about the storage and physical database design?
What are the three basic rules which are to be followed for the relational model of the database?
How can I detect whether a given connection is blocked?
