How To Implement One-to-one, One-to-many And Many-to-many Relationshi

1.	How To Implement One-to-one, One-to-many And Many-to-many Relationships While Designing Tables?
Answer» One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign KEY relationships. One-to-Many relationships are implemented by SPLITTING the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented USING a junction table with the keys from both the tables forming the COMPOSITE primary key of the junction table. One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

How To Implement One-to-one, One-to-many And Many-to-many Relationships While Designing Tables?

Answer»

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign KEY relationships. One-to-Many relationships are implemented by SPLITTING the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented USING a junction table with the keys from both the tables forming the COMPOSITE primary key of the junction table.

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Discussion

No Comment Found

Related InterviewSolutions

What Function Catx Syntax Does?
Mention The Validation Tools Used In Sas?
Explain How You Can Debug And Test Your Sas Program?
In Sas Explain Which Statement Does Not Perform Automatic Conversions In Comparisons?
Explain What Is Pdv?
Explain What Is Data Step?
Explain What Is The Basic Structure Of Sas Programming?
Explain What Is Sas? What Are The Functions Does It Performs?
Name Several Ways To Achieve Efficiency In Your Program.
If Reading A Variable Length File With Fixed Input, How Would You Prevent Sas From Reading The Next Record If The Last Variable Didn't Have A Value?