Skip to content

Database Management System

CSE · Quiz · Spring 26

Paper 6 of 8By SUPAN ROYSwitch

Paper 6 of 8

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

Read the questions as text

Read off the PDF by AI, so it may have mistakes. The PDF is the original.

Daffodil International University CSE-311 (66_L) Class Test-2 Time : 25 min, Marks : 15 (13 + 2(Attendance)) Name : ID : Amazon is maintaining a database to keep track of their order. They recently hired a database expert and told them that their database expert asked for some suggestions to make their database more efficient in storing and accessing data from their database.The expert has suggested they redesign the structure of their database by following the principles of Normalization. 13 Order_ID | Order_date | Customer_ID | Customer_name | Address | Product_ID | Product_Name | Quantity | Price 01 | 03-03-2026 | C03 | Henry | 231 MainSt. | P01,P02 | PS5 Slim, Dual Shock 5 controller | 1,1 | 600$, 60$ 02 | 01-01-2026 | C05 | Nazib | 903 Oak Ave | P04 | RTX 5080 | 3 | 3000$ 03 | 05-03-2026 | C09 | Heisenberg | 789 Mapel St. | P15,P20 | PS5-Game (GOD of War), PS5-Game (Blackmyth Wokong) | 1,1 | 40$, 50$ - Normalize the following table up to Third Normal Form (3NF). Show the First Normal Form (1NF) and Second Normal Form (2NF) before presenting the Third Normal Form.