Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sale Sale Product ty Cost Amt Customer Salesperson Searson Phone Salespersonal 1 1/1/2014 Paper 20 12.98 259 lack Smith -616-1111 2 1/1/2014 Staplers 42 15.9
Sale Sale Product ty Cost Amt Customer Salesperson Searson Phone Salespersonal 1 1/1/2014 Paper 20 12.98 259 lack Smith -616-1111 2 1/1/2014 Staplers 42 15.9 Kyle Clark 1 60-1112 1/2/2014 Pen 402.1996 April Sean Clinton -650-1113 1/2/2014 Paper 10 12.5 129 Craig Smith 30-05-1111 31/1/2014 Pens 9 5 2.19 208 Acton Sean Clinton 100-50-1113 01/1/2014 File Folders 54.99 39 Adolf Rab Chen 300-650 1114 71/1/2014 Staplers 25 15.95 396 Rabbie Kyle Clark 300-650 1112 claw .edu 1/4/2014 File Folders 97 4.99 484 Pablo Ra Chen 3 00 650 1114 thenewww.edu 9 1/4/2014 Paper 20 12.5 239 Pige o n Smith 300 650 1111 showed 30 1/4/2014 Paper 20 12.98 259 son Kve Clark Kyle Clark 300 650 1112 360650 1112 klart www.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: SaleID SaleDate, Product, Qty, Cost, Amt, Customer, Salesperson, SalespersonPhone, Sales PersonEmail Product -> Cost Normalized tables: Submit this file to Canvas
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started