a,b,c show step

DUE: September 6, 2018 Write schemas for the following relations. (10 points each) a) 1. PROD_CODE PROD DESCRIPT PROD PRICE PROD ON HAND VEND_CODE Table Name: PRODUCT 001278-AB Claw hammer Primary Key: PROD CODE Foreign Key: VEND_CODE SRE-657UG Rat tail file 123-21UUY Houselite chain saw, 16-in. bar QER-34256 Sledge hammer, 16-lb. head 189.99 18.63 2.99 6.79 15 ZZX 32450 Steel tape, 12-f1. length b) T'able Name: VENDOR VEND CODOE VEND CONTACT VEND AREACODE VEND PHONE Primary Key: VEND_CODE Foreign Key: None 230 Shelly K. Smithson 608 231 James Johnson 615 232 Annelise Crystall 608 555-1234 123-4536 224-2134 Crente 1001 10014 321452 C 324257 B 321452 A 324257 B 321452 C 324257 C Table Name: CLASS Primary Key: CLASS_CODE + STU NUM 10018 Foreign Key: CLASS CODE, STU NUM 10018 10021 10021