Using the spreadsheet structure provided, transform the flat file to 3NF (third

Question

Using the spreadsheet structure provided, transform the flat file to 3NF (third normal form).

1 Employer ID Employer Name Address St Prv Code Country AICS Code NAICS Description Contact First Name Contact Last Name Position 10120 Beantown Tours 105 State Street Boston MA Ca21og USA Le152 Tor Operators Sarah Tasker Office Manage K0122 Beantown Tours 105 State Street Boston MA 02109 USA 56152 Tour Operators Sarah Tasker Office Manage Bayside Inn & Country Club General Manager 10 10135 The Adele Barrister House 151 Thames street Newport RI 02840 USA 1191 Bed and Breakfast Inns Cheryl Coppolno General Manager 11 00138 Bue Hit Inn & Country Club 38 Bue Hil Road Chatham MA 02633 USA 111 Hotels and Motels Hwan Tang Personnel Drector O0145 The Cipper Ship Inn 5 Clifside Drive MA 01966 USA T21191 Bed-and-Breaktas Inns oren Ben-Joseph Personnel Manager 12 13 O0145 The Clipper Ship Inn 5 ciffside Drive Rocxport IMA 01966 USA 21191 Bed-and-Breaktastinns oren Ben-Joseph Personnel Manager 14 40145 The cipper ship Inn 5 cifside Drive Rockport MA 01966 USA 721191 Bed-and-Breakfast In oren Ben-Joseph Personnel Manager 15 0145 The Clipper Ship Inn 5 Cliffside Drive 01966 USA. 721191 Bed-and-Break ast Inns Oren Ben-Joseph Personnel Manager 75 Ocean Drive Newport RI 16 0146 Newport Mansion Guded Toura USA. 56152 17 Newport Mansion Guded Tours 75 Ocean Drive 0146 Newport USA 56152 18 NH 03880 USA 015 Granite State Resort Hayward Ave North Comwa Hotels and Motels Christine Faraci HR Manager 19 015 Granite State Resort Hayward Avenue North Comwa NH 03860 USA Hotels and Motel Christine Faraci HR Manager 21 0151 Grantee State Resort Hayward Avenue North Corway NH C3860 USA 111 Hotels and Motels Christine Fara HR Manager Alpine Touring Center Skiing Faci Manage Alpine Touring Center. Skiing Facilities Manage 24 0154 All Seasons Resort 45 Oceanside Wa Falmouth USA. Hotels and Motels Chelsea Petraitis Director Al Seasons Resort 45 Oceanside Way Falmouth MA USA 72111 Hotels and Motels Chelsea Petraitis Drector 0154 26 0154 All Seasons Resort Oceanside Way Falmouth USA. Chelsea Director 45 Hotels and Motels Petraitis 27 mited-Service Restaurant 0155 amble Restaurant 52 Wingate Drive USA Valencia Manage 28 0155 amble Restaurant 52 Wingate Drive USA mited Service Restauran Valencia Manage 29 0158 seaport Scenic Tours 87 Cottrell Street Mystic 06355 USA 71393 Marinas Greg Robitaille Director 31 0159 Summit Hotel & Conference Center 19 Whte Mountain Highway Franconia NH C3480 USA T2111 Hotels and Motels Narcy Shea Personnel Manager

Explanation / Answer

Here is the process:

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.