How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
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 |
Explain the cube operator?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What are the types of database model?
How can you log an error to the server event log from a stored procedure?
Explain about the relational database?
What is the database development process?
Where is dbms used?
Write the difference between case version and decode version.
What is a join and explain different types of joins?
What are cursors? Explain different types of cursors?
Explain about relational database management systems?
Explain the process of the user request and data generating?
Oracle (3253)
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)