How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
- 1 Answers
- 9543 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 |
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain what a database is?
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.
Can you instantiate a COM object by using T-SQL?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What is denormalization and when would you go for it?
Explain the family trees and connection by clause.
Where is dbms used?
Explain about the relational database?
Who are end users in dbms?
Explain the role of indexing in databases?
Why does this query return 0?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
