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
- 9876 Views
- Flextronics, Hexaware, SQL Star, I also Faced
- E-Mail Answers
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 |
How is data stored in dbms?
Explain the role of indexing in databases?
What are the three types of database design?
What is bit datatype and what's the information that can be stored inside a bit column?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How long can an error message be in raiseerror function?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are triggers? How many triggers you can have on a table?
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?
What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?
How to use timestamp datatypes
What are the main phases of database development?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
