Database

You are required to design and implement a relational database to help the local community center better serve the residents in your neighborhood. Database Specifications: In your preliminary analysis, you have determined the following basic facts about the community center and the services it provides to the residents in the neighborhood: The community center serves multiple areas which fall into different zip codes. The community center provides collaborative family based care services. An immediate family is defined to include one or both parents and any of their children living at the same or different address. Each family resides at an address or addresses. An address includes an apartment or floor number (or none), street number, Street name, borough or city name, and zip code. The community center engages in activities related to the services it provides. Possible services are: [a]Health services[b] Education and learning [c] Gender related services [d] Water and sanitation [e] Child protection[f] Nutrition[gl others Residents volunteer to help in the activities which target various groups of residents. Possible groups are: la The community at large/collective benefit [b] Women[c] Youth Children Cel Senior citizens[f] Minorities[g] Underprivileged/disadvantaged Chl Disabled and handicappedlij Others