Database System

Based on Figure 4, write an SQL coding for the following questions. Table : CUSTOMER Table: VENDOR CCode 10010 10011 10012 10013 10014 CName Abu Joji Ramy Gopi Sally CInitial A J R G S CBalance 0.00 0.00 345.86 536.75 221.19 VCode VName VState 21225 Bryson, Inc. TN 21226 Super, Inc. FL 21231 My Supply TN 21344 Dina Supply KY 22567 Green Tech GA 23119 Abs System GA 24004 Padu, Inc. FL Table : PRODUCT Table : INVOICE INum CCode IDate 001 10011 16-Jan-18 002 10014 17-Jan-18 003 10013 16-Jan-18 Table : LINE INum LNum 001 1 002 2 002 1 003 3 PCode 112 112 114 113 PCode PDescript 111 Hammer 112 Screw 113 Cloth 114 PVC Pipe V Code 21231 24004 21344 21225 Figure 4 -Inventory i) Create table VENDOR with a suitable data type. (5 marks) ii) List VName and PDescript where PCode is 114. (4 marks iii) List CName, IDate and PDescription for CBalance is more than 200. (6 marks) Determine the highest CBalance for the customer. (2 marks) List all of vendor's records in descending order by VCode. iv)