Draw the ER diagram and then diagram the relations that result from this ERD for the following scenario:

Imagine you work for the public housing agency of a city, and you have been charged with keeping track of who is living in the agency's developments over time. To help you in this task, you have decided to use a relational database for your record keeping. Your task is to design a database that allows you to capture the facts described below:

-The city has three public housing developments. You want to record their names, locations, the year they opened, and their height in stories.

-For each unit in the development, you want to keep track of the number of bedrooms, the number of bathrooms, whether the unit has a kitchen or living room, and the square footage.

-The database should keep track of the households living in the units. For each member of a household, you want to record their name, date of birth, sex, and indicate whether or not they are they are the head of the household (more than one person can share that distinction).

-You also want to keep track of when a household moved into and out of a particular unit. You want to be able to follow households as they move from one unit to another or from one development to another. Think about how you will find the unit that the household is currently occupying (i.e., what query would you write to find the current unit of each household).

** I asked this question earlier, but only recieved part of the answer. The part i'm really having an issue with is the database part of this. After creating the ERD we are to create a database on SQL, and that is what I am looking for help with here. **