PHpahelp po sa mga master natin diyan..homework ko po nakakalito 
salamat po ng marami
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:
salamat po ng maramiImagine 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, ***, 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).
