Question: I have created a relational schema using Microsoft based on ER diagram (first picture) But I am not sure if the schema satisfies 1NF 2NF

 I have created a relational schema using Microsoft based on ER

diagram (first picture) But I am not sure if the schema satisfies

I have created a relational schema using Microsoft based on ER diagram (first picture)

But I am not sure if the schema satisfies 1NF 2NF and 3NF.

Please let me know what to fix.

Plus, if there is anything weird in terms of relationships. let me know too.. thanks

adjus home_number cell_numberName DistrictIDParcellD address status work_number oning ID Adjusted Parcels Council District Zoning represent Member email class status FacilityID contain Consist of divided into name Schools are within City Boundary belong to class ype type acres Streets direction playground rovid de with have intersect at Facilit track LightID Recreation Facilities Parks Street Lights basebal direction tennis Facility D park type power type wattage pool icerink basketball 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 adjus home_number cell_numberName DistrictIDParcellD address status work_number oning ID Adjusted Parcels Council District Zoning represent Member email class status FacilityID contain Consist of divided into name Schools are within City Boundary belong to class ype type acres Streets direction playground rovid de with have intersect at Facilit track LightID Recreation Facilities Parks Street Lights basebal direction tennis Facility D park type power type wattage pool icerink basketball 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!