Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(B) Normalize the following table TP AMT Alfred A. Ramas 615-844-2573 218 Fork Rd., Babs, TN 36123 Leah F. Hahn 615-882-1244 T1 Leona K. Dunne

image text in transcribed

(B) Normalize the following table TP AMT Alfred A. Ramas 615-844-2573 218 Fork Rd., Babs, TN 36123 Leah F. Hahn 615-882-1244 T1 Leona K. Dunne 713-894-1238 Box 12A, Fox, KY Kathy W. Smith 615-894-2285 125 Oak Ln, Babs, TN 36123 Leah F. Hahn 6 Paul F. Olowski 615-894-2180 217 Lee Ln., Babs, TN36123 Leah F. Hahn 615-882-1244 S1 Myron Orlando 615-222-1672 Box 111, New, TN Amy B. OBrian 713-442-3331 387 Troll Dr.,Fox, KY25246 John T. Okon 615-123-5589 T2 James G. Brown 615-297-1228 21 Tye Rd., Nash, TN 37118 Leah F. Hahn 615-882-1244 S1 100.00 05-Apr-2016 250.00 16-Jun-2016 615-882-2144 S2 150.00 29-Jan-2017 25246 Alex B. Alby 713-228-1249 T .00 14-Oct-201 36155 Alex B. Alby 713-228-1249T 00.0028-Dec-2016 22-Sep-2016 20.00 25-Mar-2017 850.00 George Viliams 615-290-2556 55 Maple, Nash, TN 37119 John T.Okon 615-123-5589 S1 25000 17ul-2016 Anne G. Farriss 713-382-7185 2119 Elm, Crew,KY25432 Alex B.Alby 713-228-1249 T2 100.00 03-Dec-2016 Olette K. Smith 615-297-3809 2782 Main, Nash, TN 37118 John T.Okon 615-123-5589 S2500.00 14-Mar-2017 CNAME = Customer name C-PHONE =Customer phone C ADDRESS Customer address C ZIP A NAME = Agent name A PHONE = Agent phone TP AMT REN Insurance type Insurance policy amount, in thousands of $ Insurance renewal date = Customer zip code Assumptions: 1NF

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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