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
- 9863 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
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?
How to read and create .LDC data files which are used by linguatic dictionary.
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?
Explain about relational database management systems?
Explain about network model?
What is data modeling with example?
Write short notes on manual refreshes.
Explain the rollup operator?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How to use timestamp datatypes
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What is dbms explain in brief?
Why does this query return 0?
What is normalization? Explain different levels of normalization?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
