Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

3. Identify the methods used within each of the three approaches.

Answered: 1 week ago