Sale SaleDate Product Qty Cost Amt Customer SalesPerson Sales PersonPhone SalesPersonEmail 1 1/1/2014 Paper 20 12.95 259 Jack John Smith 360-650-1111 ismith@wwu.edu 2 1/1/2014 Staplers 42 15.95 669 Josh Kyle Clark 360-650-1112 kclark@wwu.edu 3 1/2/2014 Pens 44 2.19 96 April Sean Clinton 360-650-1113 sclinton@wwu.edu 4 1/2/2014 Paper 10 12.95 129 Craig John Smith 360-650-1111 jsmith@wwu.edu 5 1/3/2014 Pens 95 2.19 208 Acton Sean Clinton 360-650-1113 sclinton@wwu.edu 6 1/3/2014 File Folders 8 4.99 39 Adolf Rab Chen 360-650-1114 rchen@wwu.edu 7 1/3/2014 Staplers 25 15.95 398 Rabbie Kyle Clark 3 60-650-1112 kclark@wwu.edu 8 1/4/2014 File Folders 97 4.99 484 Pablo Rab Chen 360-650-1114 rchen@wwu.edu 9 1/4/2014 Paper 20 12.95 259 Paige John Smith 360-650-1111 jsmith@wwu.edu 10 1/4/2014 Paper 20 12.95 259 Jason Kyle Clark 360-650-1112 kclark@wwu.edu Two functional dependencies are given. Find and write down another functional dependency (Hint: two columns are determined by another column). Then, based on all the functional dependencies, write down the normalized tables using the Relation Expressions: Functional Dependencies: SalelD SaleDate, Product, Qty, Cost, Amt, Customer, Salesperson, SalesPersonPhone, SalesPersonEmail Product -> Cost Normalized tables: Sale SaleDate Product Qty Cost Amt Customer SalesPerson Sales PersonPhone SalesPersonEmail 1 1/1/2014 Paper 20 12.95 259 Jack John Smith 360-650-1111 ismith@wwu.edu 2 1/1/2014 Staplers 42 15.95 669 Josh Kyle Clark 360-650-1112 kclark@wwu.edu 3 1/2/2014 Pens 44 2.19 96 April Sean Clinton 360-650-1113 sclinton@wwu.edu 4 1/2/2014 Paper 10 12.95 129 Craig John Smith 360-650-1111 jsmith@wwu.edu 5 1/3/2014 Pens 95 2.19 208 Acton Sean Clinton 360-650-1113 sclinton@wwu.edu 6 1/3/2014 File Folders 8 4.99 39 Adolf Rab Chen 360-650-1114 rchen@wwu.edu 7 1/3/2014 Staplers 25 15.95 398 Rabbie Kyle Clark 3 60-650-1112 kclark@wwu.edu 8 1/4/2014 File Folders 97 4.99 484 Pablo Rab Chen 360-650-1114 rchen@wwu.edu 9 1/4/2014 Paper 20 12.95 259 Paige John Smith 360-650-1111 jsmith@wwu.edu 10 1/4/2014 Paper 20 12.95 259 Jason Kyle Clark 360-650-1112 kclark@wwu.edu Two functional dependencies are given. Find and write down another functional dependency (Hint: two columns are determined by another column). Then, based on all the functional dependencies, write down the normalized tables using the Relation Expressions: Functional Dependencies: SalelD SaleDate, Product, Qty, Cost, Amt, Customer, Salesperson, SalesPersonPhone, SalesPersonEmail Product -> Cost Normalized tables