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
- 9993 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
Write the fastest query to find out how many rows exist in a table?
Explain about the database management systems.
What is a database development?
What is DB Development software?
What is dbms explain in brief?
Explain about the hierarchical model of the database?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Explain the rollup operator?
Explain about the storage and physical database design?
Explain about query and reporting.
What are the main phases of database development?
How to replace not in with not exist?
How is data stored in dbms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
