Question

What is the need of setting relationships between tables in dbms?

Answer 1

✔✔✔Ur answer✔✔✔


⭐Multiple relationships between tables⭐

✔✔A Data Model can have multiple relationships between two tables. ✔✔

⭐⭐⭐⭐⭐⭐⭐⭐⭐

To build accurate calculations, Excel needs a single path from one table to the next.
⭐⭐⭐⭐⭐⭐⭐⭐⭐
Therefore only one relationship between each pair of tables is active at a time.☺☺

Answer 2

2 divide your information stored in separate table for example to connect a customer with all the customer orders is table in a database must include field or set of fields that uniquely identifies individual record in the table such a field or set of field is called primary key