Consider the following table to answer the questions a. Create a view named ComputerView that should show the columns Make and Processor Speed from the COMPUTER table. (3 marks) b. Create a stored procedure named Computer Proc that displays SerialNumber and then Make and Model combined as one attribute named ComputerType from the COMPUTER table. (3 marks) COMPUTER ColumnName Type Key Required Remarks SerialNumber Integer Primary key Yes Make Char (12) No Yes Must be "Dell or "HP" or "Other" Model Char (24) No Yes Processor Type Char (24) No No Processor Speed Numeric (3,2) No Yes Between 2.0 and 5.0 MainMemory Char (15) No Yes Disk Size Char (15) No Yes