SQL databases. Please show your work and give an explanation.Thank you!
2. Consider the following table and FDs ACTIVITY (customerid,fname, 1name, address,zip,status,partid,date,price,quantity,material,color) customeridfame,lname,address address-zip partid-price,material,color customerid.partid date.quantity.status For each of the following decompositions, determine (i) if lossless join holds;(i each table i the decomposition the normal forms of (a) CUST(customerid,fname, lname,address), CUSTADD(address.zip)., PART (partid,price,material,color), BUY (customerid,partid,date quantity (b) CUST(customerid.fname,lname,address,zip.status), PART (partid.price.material.quantity), BUY (customerid.partid.color,date). Show transcribed image text
Expert Answer
An answer will be send to you shortly. . . . .