Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 typeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started