Question: I) Define the term Database Management System (DBMS) in your words. (Marks 02) II) List and briefly explain two main features of a DBMS. (Marks

I) Define the term "Database Management System (DBMS) in your words. (Marks 02) II) List and briefly explain two main features of a DBMS. (Marks 02) III) Briefly explain the importance of "Normalization" for effective data management. (Marks 02) IV) Consider below table with Customer ID, Customer Name, Address, Phone Number, PIN (for booking) Number, Date Booked. Order ID. Room/ Table ID, Pax (Number of persons) and the Price data, respectively. Customer ID and PIN is the Composite Key. Cusid Cusname Phone PIN Dtbooked Ordid Room/tbl Pax Price Address (Area Only) 10001 Saman Padukka 0112858143 123 2020/11/24 1001 11 2 8000 10002 Saman Nugegoda 0112345678 124 2020/11/23 999 1 1 6000 10001 Saman Padukka 0112858143 125 2020/11/11 899 12 2 8500 10003 Soma Kandy 0712008882 10001 Saman Padukka 0112858143 126 2020/09/11 700 11 2 8000 10004 Yohan Padukka 0713008883 127 2020/11/24 4-Ocean Villa 3 10000 5-Rose Villa 3 10000 Tablel.1 - Customer Bookings List and briefly explain occurrences of Insert, Update and Delete anomalies with respect to the above table of data (Table 1.1) (Marks 09) V) Normalize data in Table1.1 up to Third Normal Form (3NF). Identify clearly, the normalized relations/ tables, their Primary Keys and Foreign Keys. Describe briefly, how you have overcome the above anomalies. (Marks 10)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
