**ER Diagrams to Tables-**

Before you go through this article, make sure that you have gone through the previous article on **ER Diagrams to Tables**.

After designing an **ER Diagram**,

- ER diagram is converted into the tables in relational model.
- This is because relational models can be easily implemented by RDBMS like MySQL , Oracle etc.
- The rules used for converting an ER diagram into the tables are already discussed.

In this article, we will discuss practice problems based on converting ER Diagrams to Tables.

**PRACTICE PROBLEMS BASED ON CONVERTING ER DIAGRAM TO TABLES-**

**Problem-01:**

Find the minimum number of tables required for the following ER diagram in relational model-

**Solution-**

Applying the rules, minimum 3 tables will be required-

- MR1 (M1 , M2 , M3 , P1)
- P (P1 , P2)
- NR2 (P1 , N1 , N2)

**Problem-02:**

Find the minimum number of tables required to represent the given ER diagram in relational model-

**Solution-**

Applying the rules, minimum 4 tables will be required-

- AR1R2 (a1 , a2 , b1 , c1)
- B (b1 , b2)
- C (c1 , c2)
- R3 (b1 , c1)

**Problem-03:**

Find the minimum number of tables required to represent the given ER diagram in relational model-

**Solution-**

Applying the rules, minimum 5 tables will be required-

- BR1R4R5 (b1 , b2 , a1 , c1 , d1)
- A (a1 , a2)
- R2 (a1 , c1)
- CR3 (c1 , c2 , d1)
- D (d1 , d2)

**Problem-04:**

Find the minimum number of tables required to represent the given ER diagram in relational model-

**Solution-**

Applying the rules, minimum 3 tables will be required-

- E1 (a1 , a2)
- E2R1R2 (b1 , b2 , a1 , c1 , b3)
- E3 (c1 , c2)

**Problem-05:**

Find the minimum number of tables required to represent the given ER diagram in relational model-

**Solution-**

Applying the rules that we have learnt, minimum 6 tables will be required-

- Account (Ac_no , Balance , b_name)
- Branch (b_name , b_city , Assets)
- Loan (L_no , Amt , b_name)
- Borrower (C_name , L_no)
- Customer (C_name , C_street , C_city)
- Depositor (C_name , Ac_no)

**Next Article-** **Constraints in DBMS**

Get more notes and other study material of **Database Management System (DBMS).**

Watch video lectures by visiting our YouTube channel **LearnVidFun**.