Show the answers to the following SQL commands [Based on the Attached Scenario] (15 points).

UPDATE Student SET Status = ‘SM’ WHERE Name = ‘CHARLES’;  (by User FRED)

UPDATE faculty SET Rank = ‘Professor’ WHERE Name = ‘LOONEY’;   (by       User LOONEY)

UPDATE faculty SET Address =  ’14 West’ WHERE Name = ‘MARTIN’; (by User LOONEY)                             

i need only question 4 and question 5.

please check attched file for complete details