Use the technique of normalization to validate the structure of your relational schema. Demonstrate that each of your relations is in third normal form (3NF) by displaying the functional dependencies between attributes in each relation. Note, if any of your relations are not in 3NF, this may indicate that your ER model is structurally incorrect or that you have introduced errors in the process of deriving relations from your model.

If there is such a thing as a relational model, what is the overarching name for attributes, and how are they utilized?

Normalization   Show all the steps as you perform normalization for each problem up to 3NF. State your final relation to schemas in 3NF.

Normalize Table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State the action taken upon the table(s) for each Normal Form. For the INF in this case, only identify the Primary Key and keep the INF result in a single table. Then, split into new table(s) starting from a) 2NF onwards. Also, consider the following assumptions: - One ReservelD can have multiple venues' booking. - One venue can only be booked once for the same ReservelD on the same ReserveDate ReservelD ReserveDate StartTime EndTime VenuelD VenueTag 10:00 13:00 210101-01 3-Jan-21 210101-02 3-Jan-21 Hibiscus Lily VenueSize FeePerHour Purpose |150 15:00 v10 Small Discussion 20:00 20:00 21:00 V22 Medium 260 Forum 210101-02 3-Jan-21 13:00 V20 Petal Medium 260 Meeting 210101-02 3-Jan-21 17:00 V10 Hibiscus Small 150…