Database Management - Normalization

Use any graphic tool of your choice to draw lines. 1) Consider the following relation: Date AIUTINT 6.3.2020 6 3 2020 6.3.2020 7.3.2020 7.3.2020 ROSZA CENTER BOOKING HallID Date Hall Size 500m2 600m2 HallID 400m2 500m2 600m2 ClientID ClientName Hall Size Jones Smith ClientID Weller Jones Brown Event Rehearsal Dinner Anniversary ClientName Bar Mitzvah Wedding Wedding Some of the requirements for this table are as follows: Each hall has a unique HallId and HallSize. Each client has a unique ClientId and ClientName Each hall can have at most one event booked for it on one date NoOfGuests Clients can book more than one event with Excelsior Events 100 a) In the figure below, indicate functional dependencies by drawing lines with arrows. (10 points) 110 Event 120 150 NoOfGuests b) Normalize the relation ROSZA CENTER BOOKING to the second normal form (2NF). Show column names (underline primary keys) and functional (10 points) dependencies. c) Normalize the relation ROSZA CENTER BOOKINGS to the third normal form (3NF). Show table names, column names (underline primary keys), and functional dependencies. (10 points)

Use any graphic tool of your choice to draw lines but 1) Consider the following relation: ROSZA CENTER BOOKING Some of the requirements for this table are as follows: - Each hall has a unique HallId and HallSize. - Each client has a unique ClientId and ClientName - Each hall can have at most one event booked for it on one date - Clients can book more than one event with Excelsior Events a) In the figure below, indicate functional dependencies by drawing lines with arrows. (10 points) b) Normalize the relation ROSZA CENTER BOOKING to the second normal form (2NF). Show column names (underline primary keys) and functional dependencies. (10 points) c) Normalize the relation ROSZA CENTER BOOKINGS to the third normal form (3NF). Show table names, column names (underline primary keys), and functional dependencies. (10 points)