Complete the following two questions: a. Determine the Primary key in the following table. (2 marks) PurchaseTable Transactionld Customerld ProductID Purchase Date 1201 3489 507 12/01/2021 1202 3492 248 12/01/2021 1202 3410 610 18/01/2021 1204 3489 248 11/12/2021 b. What are the appropriate data types that can be used for the following fields? (4 marks) i. CreatedDate ii. Email iii. Passport Number iv. Employeeld 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 Computer Proc that displays SerialNumber 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 Yes No Must be "Dell" or "HP" or "Other" Model Processor Type Processor Speed Char (24) No Char (24) No Numeric (3,2) No Yes No Yes Between 2.0 and 5.0 MainMemory No Yes Char (15) Char (15) DiskSize No Yes