Database Systems

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: Cal Health services Education [b] and learning [c] Gender related services [d] Water and sanitation le] Child protectionlf Nutrition[g] Others .Residents volunteer to help in the activities which target various groups of residents. Possible groups are: [a] The community at large/collective benefit [b] Women[c] Youth[d] Children [e] Senior citizens[f] Minorities Underprivileged/disadvantaged Disabled and handicapped Others