a. Consider the following table to answer the questions 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 ComputerProc that displays Serial Number and then Make and Model combined as one attribute named ComputerType from the COMPUTER table. (3 marks) Remarks COMPUTER ColumnName SerialNumber Make Type Integer Char (12) Key Primary Key Required Yes No Yes Must be "Dell" or "HP" or "Other" Yes Model ProcessorType Processor Speed Char (24) No Char (24) No Numeric (3,2) No No Yes Between 2.0 and 5.0 Char (15) No Yes MainMemory DiskSize Char (15) No Yes