Database Management System
CSE · Quiz · Spring 26
Paper 6 of 8By SUPAN ROYSwitch
Paper 6 of 8
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.