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
- 9894 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
Explain about normal forms?
Explain about the hierarchical model of the database?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is the database development process?
Who are naive users?
How would you design a database for an online site, which would average a million hits a day?
What are the key features of dbms?
What is an application role and explain a scenario when you would use one?
What is data modeling with example?
What are the 18 schemas?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Write short notes on manual refreshes.
I have a few records all are same structures data, I want to store data in multiple targets how
Explain what a database is?
