You are provided two tables of sample transaction data. The definitions of the columns are provided in the appendix.You can see there are data redundancies. You are required to normalize the given...

77830 - Normalised ERD/ERD.png
77830 - Normalised ERD/report.docx
Normalization
The provided tables have relational tables. The relational table can be defined as those tables which has relationship between themselves. As we can see the given data has property ID and different types of attributes for the property. It also has the host ID who will be managing the whole property. These tables are having different types of relationship between themselves.
Currently all the attributes present in these tables are not clear and they have different types of dependencies on each other. It has functional dependency. Functional dependency can be defined as that dependency when we store the information in one table, and it can uniquely determine information present in another table. For example, the property ID present in one table has the direct dependency...