Hostel Registration Number: A0000501 Hostel Type: Girls Hostel Address: South Mawaleh, Seeb Student ID Student Name...

  

 

Transcribed Image Text:

Hostel Registration Number: A0000501 Hostel Type: Girls Hostel Address: South Mawaleh, Seeb Student ID Student Name 21F21345 Hanaa 22F21456 Ruqaiya 21F21345 Hanaa 22F21456 23S21345 Ruqaiya Salma Visitor PhoneNr 93456785 94456785 98546575 93685656 98766758 Visitor Name Hamad Rawan Sumaiya Rashid Raya Total Visitors: 5 Visit Date 12/01/23 13/01/23 16/01/23 17/01/23 25/01/23 Visit Time 12.00 13.00 14.00 8.00 15.00 a) Considering the above scenario, separate the data into different groups to obtain the first normal form (1 NF). Also identify the primary keys and the foreign keys for the groups b) Considering your answer for 1, normalize the solution to convert it into 2nd Normal Form (2 NF). Also identify the primary keys and the foreign keys all the groups. c) Normalize the solution of 2NF to 3NF by applying appropriate rules to the solution of* Also identify the primary keys and the foreign keys. Hostel Registration Number: A0000501 Hostel Type: Girls Hostel Address: South Mawaleh, Seeb Student ID Student Name 21F21345 Hanaa 22F21456 Ruqaiya 21F21345 Hanaa 22F21456 23S21345 Ruqaiya Salma Visitor PhoneNr 93456785 94456785 98546575 93685656 98766758 Visitor Name Hamad Rawan Sumaiya Rashid Raya Total Visitors: 5 Visit Date 12/01/23 13/01/23 16/01/23 17/01/23 25/01/23 Visit Time 12.00 13.00 14.00 8.00 15.00 a) Considering the above scenario, separate the data into different groups to obtain the first normal form (1 NF). Also identify the primary keys and the foreign keys for the groups b) Considering your answer for 1, normalize the solution to convert it into 2nd Normal Form (2 NF). Also identify the primary keys and the foreign keys all the groups. c) Normalize the solution of 2NF to 3NF by applying appropriate rules to the solution of* Also identify the primary keys and the foreign keys.