Question: a. Consider the following table to answer the questions Create a view named ComputerView that should show the columns Serial Number and Make from the

a. Consider the following table to answer the questions Create a view named ComputerView that should show the columns Serial Number and Make from the COMPUTER table. (3 marks) b. Create a stored procedure named ComputerProc that displays SerialNumber and then Main Memory and Disk Size combined as one attribute named ComputerSize from the COMPUTER table. (3 marks) COMPUTER ColumnName Type 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 ProcessorSpeed Numeric (3,2) No Yes Between 2.0 and 5.0 MainMemory Char (15) No Yes DiskSize Char (15) No Yes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
