How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
- 1 Answers
- 9165 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
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is the database development process?
Who are naive users?
How to read and create .LDC data files which are used by linguatic dictionary.
What is dbms explain in brief?
Explain about the storage and physical database design?
What are the 18 schemas?
Explain the role of indexing in databases?
How can I detect whether a given connection is blocked?
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?
Who are end users in dbms?
Explain what a database is?
State the acid rules?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
