please a,b,, in detail

Identify all functional dependencies of the following relations. (20 points each) ModelNo ModelName SereenSize ProviderID ProviderName Price SM-J700H Galaxy J7 5.5 SM- J700H Galaxy J7 SM-Z2-8M Z2 Tizen SM-Z2-8M Z2 Tizen SM-N920C Note 5 ATT VER SPR USC VER 300 290 350 U.S. Cellular 300 AT&T Verizon Sprint 4.5 5.7 Verizon b) Order ID Order_Date Cust ID Cust Name Cust City Prod ID Prod Dese Price Quantity John Shu Plano John Shu Plano 1001 2/10/2008 1001 1001 2/10/2008 1007 2/11/2008 1007 2/11/2008 Swing 600 Boat 8500 Bicycle450 2/10/2008 John Shu Plano 6 John Smith Boulder11 4 6 John Smith Boulder 4Bicycle 4503 c) StudentID Name CourselD CourseName InstructorID InstructorName Grade E1110001 MarkIS201 10001 10002 10001 10003 10003 10004 Alex Webb Adriana Yi Alex Webb B Karam BestA Karam Best A Computing E1110001 Mark IS301 Applications E1110002 Amina IS201 E1110002 Amina IS413 Computin Database E1110003 Louis IS413 Database1 E1110004 |Nicole IS520 Networks DIUTDITORY tahle to write SOL statements for the following queries. Make sure to h of the query