[go: up one dir, main page]
Scribd
Upload
48 views3 pages

Normalization Questions Exercise

The document contains a series of normalization questions categorized into easy, medium, and hard levels, each with specific tables and tasks related to database normalization. It requires identifying normalization forms, functional dependencies, and performing normalization up to BCNF or 4NF. The questions involve practical examples with tables related to students, employees, orders, books, suppliers, and hospitals.

Uploaded by

tasriftanim2002
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
48 views3 pages

Normalization Questions Exercise

The document contains a series of normalization questions categorized into easy, medium, and hard levels, each with specific tables and tasks related to database normalization. It requires identifying normalization forms, functional dependencies, and performing normalization up to BCNF or 4NF. The questions involve practical examples with tables related to students, employees, orders, books, suppliers, and hospitals.

Uploaded by

tasriftanim2002
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Normalization Questions (Easy, Medium, Hard)

Easy Level Questions

Question 1

Table:

| Student_ID | Student_Name | Course1 | Course2 |

|------------|--------------|---------|---------|

|1 | Alice | Math | Physics |

|2 | Bob | English | Math |

Tasks:

- Identify if the table is in 1NF or not.

- Convert the table into 1NF.

Question 2

Table:

| Employee_ID | Employee_Name | Department |

|-------------|---------------|------------|

| 1001 | John | HR |

| 1002 | Emma | IT |

Tasks:

- Is the table normalized? Why?

- If not, normalize it to 2NF.

Medium Level Questions

Question 3

Table:

| Order_ID | Customer_Name | Product_Name | Product_Price |

|----------|---------------|--------------|---------------|
Normalization Questions (Easy, Medium, Hard)

| 201 | Sarah | Laptop | 60000 |

| 202 | Sarah | Mouse | 1000 |

| 203 | John | Mobile | 25000 |

Tasks:

- Identify redundancies.

- Normalize the table up to 3NF, showing steps.

Question 4

Table:

| Book_ID | Book_Title | Author_Name | Author_Email |

|---------|------------|-------------|--------------|

|1 | DBMS Basics| John Smith | john@email.com |

|2 | AI World | John Smith | john@email.com |

Tasks:

- Identify functional and transitive dependencies.

- Normalize the table up to BCNF.

Hard Level Questions

Question 5

Table:

| Student_ID | Student_Name | Course_ID | Course_Name | Instructor_Name |

|------------|--------------|-----------|-------------|-----------------|

|1 | Alice | C101 | DBMS | Dr. Khan |

|1 | Alice | C102 | Networking | Dr. Ali |

|2 | Bob | C101 | DBMS | Dr. Khan |

Tasks:

- Identify all functional dependencies.


Normalization Questions (Easy, Medium, Hard)

- Identify partial and transitive dependencies.

- Normalize the table up to BCNF with proper steps.

Question 6

Table:

| Supplier_ID | Supplier_Name | City | Product_ID | Product_Name | Product_Category |

|-------------|---------------|------|------------|--------------|------------------|

| S1 | Alpha Ltd | Dhaka| P1 | Mouse | Electronics |

| S1 | Alpha Ltd | Dhaka| P2 | Keyboard | Electronics |

| S2 | Beta Ltd | Rajshahi| P3 | Pen | Stationery |

Tasks:

- Identify multivalued and transitive dependencies.

- Decompose the table up to 4NF.

- Justify why each decomposition is necessary.

Extra Challenge (Bonus)

Question 7

Table:

| Hospital_ID | Hospital_Name | Doctor_ID | Doctor_Name | Patient_ID | Patient_Name |

|-------------|---------------|-----------|-------------|------------|--------------|

| H1 | Central Hosp | D1 | Dr. Smith | P1 | John Doe |

| H1 | Central Hosp | D2 | Dr. Adams | P2 | Emma Stone |

Tasks:

- Analyze the table for any partial, transitive, and multivalued dependencies.

- Normalize into multiple related tables following up to BCNF or 4NF.

- Draw the ER diagram for the final structure.

You might also like