I would like to implement a tree structure for storing attributes of a given part in MySQL 8.0+.

I am creating a website similar to this website. My website needs to allow users to save different kinds of listing like home, plots. offices, shops, agricultural land etc. My question is how to create a database design in MySQL where I can easily add any kind of listings and also it’s amenities. Some listings would have amenities and some won’t like a plot can have amenities such as boundary wall, near hopital etc.

So, I’m sure it is 2nf since there is no partial dependency, but I’m not sure if phone numbers 1 and 2 are transitive.