Given the following tables, draw the dependency diagram, clearly labeling all functional, full functional, partial, and transitive dependencies. You may draw them using Words facilities for shapes and drawings, Visio and then pasting them into this document, or use Draw.io. If you use Draw.io, you will need save your files as images (JPG, PNG) and paste them into this document. Under each diagram, list the dependencies. Be sure to underline the PK, and color the diagrams like shown in the book and class notes (exact color matching is not necessary). State any assumptions you make about the table and data in a bulleted list (note that your assumption may be incorrect, so be cautious when making them).

GNAMIE | Alfred A. Ramas 615-844-2573218 Fork Rd., Babs, TN Leona K. Dunne C PHONE | C_ADDRESS | C-ZIP | A-NAME | APHONE TR AMIT I REN A-PHONE | TPI AMT 36123 Leah F. Hahn 615-882-1244 T1 25246 Alex B. Alby 713-228-1249 T1 100.00 05-Apr-2016 250.0016-Jun-2016 713-894-1238 Box 12A, Fox, KY Kathy W. Smith 615-894-2285 125 Oak Ln, Babs, TN 36123 Leah F. Hahn 615-882-2144 S2 150.0029-Jan-2017 300.00 14-Oct-2016 100.00 28-Dec-2016 850.00 22-Sep-2016 120.00 25-Mar-2017 250.0017-Jul-2016 100.00 03-Dec-2016 500.0014-Mar-2017 Paul F. Olowski 615-894-2180 217 Lee Ln., Babs, TN 36123 Leah F. Hahn 615-882-1244 S1 B. Alby 713-228-1249 TI Amy B. O'Brian 713-442-3381 387 Troll Dr., Fox, KY 25246John 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 George Wllms 615-290-2556 155 Maple, Nash, TN 37119 John T. Okon 615-123-5589 S1 Anne G. Farriss 713-382-7185 2119 Elm, Crew, KY 25432Alex B. Alby 713-228-1249 T2 37118 John T. Okon 615-123-5589 S2 Myron Orlando 615-222-1672 Box 111, New, TN 36155 Alex Olette K. Smith 615-297-3809 2782 Main, Nash, TN C NAME Customer name C_PHONE Customer phone A NAME Agent name A PHONE Agent phone TP AMT REN CADDRESS = Customer address C_ZIP = Insurance type Insurance policy amount, in thousands of $ Insurance renewal date - Customer zip code