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 |
How can you log an error to the server event log from a stored procedure?
What are the three basic rules which are to be followed for the relational model of the database?
How long can an error message be in raiseerror function?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
State the acid rules?
What is database design and development?
What are the main phases of database development?
What are the key features of dbms?
explain detail about ftp in datastage?
How to replace not in with not exist?
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 the three types of database design?
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)