Ensure that your database satisfies 3NF. Assuming youre creating your database based on the correct ER diagram, it probably does satisfy 3NF for the most part. Only the recreational facilities table is questionable. Consider the following questions:

1. Why might the recreational facilities table be judged as not satisfying 3NF?

2. How might you make changes to the recreational facilities table to ensure that your entire database does indeed satisfy 3NF? (Do not actually make these changes, but do thoroughly brainstorm the solution.)

Adjusted Parcels ParcellD Council Member Member Name Cell number Home number Work number DistrictiD Council District Adjusted status BND Name 7 District!D BND Name Zoning ? ZoninglD Class BND Name -| Facility!D Streets Class City_BND BND Na Acres StreetiD Street name Type Direction BND Name BND Name intersect at intersect, at ID Parks Recreation Facilities 2StreetiD LightiD LFacilitylD FacilitylD playground pavillion Park name Park type BND Name Street Light LightID Direction basketball Power type