Consider the following table to answer the questions a Create a view named ComputerView that should show the columns SerialNumber 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) Subject Database design and development Please hurry i need it in 1 hour thanks Key Remarks COMPUTER ColumnName SerialNumber Make Type Integer Char (12) Primary key No Required Yes Yes Must be Dell or HP or Other No Yes Model Processor Type Processor Speed Char (24) Char (24) Numeric (3,2) No No No Yes Between 2 0 and 5 0 MainMemory Char (15) No Yes Disk Size Char (15) No Yes

The Answer is in the image, click to view ...

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

Consider the following table to answer the questions

a. Create a view named ComputerView that should show the columns SerialNumber 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)

Consider the following table to answer the questions a. Create a view

Subject Database design and development Please hurry i need it in 1 hour thanks

Key Remarks COMPUTER ColumnName SerialNumber Make Type Integer Char (12) Primary key No Required Yes Yes Must be "Dell" or "HP" or "Other" No Yes Model Processor Type Processor Speed Char (24) Char (24) Numeric (3,2) No No No Yes Between 2.0 and 5.0 MainMemory Char (15) No Yes Disk Size Char (15) No Yes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

Consider the following table to answer the questions a. Create a view named ComputerView that should show the columns MainMemory and Model from the COMPUTER table. (3 marks) b. Create a stored...

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...

a. Consider the following table to answer the questions Create a view named ComputerView that should show the columns MainMemory and Model from the COMPUTER table. (3 marks) b. Create a stored...

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...

/ * CSC 5 6 5 Database Management Systems Assignment 8 Intermediate SQL * / use university; # Write SQL statements for the following questions: # 1 . show all information of all instructors along...

* CSC 5 6 5 Database Management Systems Assignment 8 Intermediate SQL * / use university; # Write SQL statements for the following questions: # 1 . show all information of all instructors along with...

A company produces chairs. The cost per chair is: Materials $15 Packaging $1.00 Decorations $5 Shipping and handling $10.00 Each worker earns $28,500 annually in salary and benefits. The number of...

QUESTION 3 [ 1 0 MARKS ] Consider the following statements and answer the questions. a ) What type of project meeting is this description referring to ? ( 5 marks ) b ) During which stage of the...

Differentiate explicitly on the difference between causation and effectuation and provide at least two entrepreneurs that use causation decision-making logic and two entrepreneurs that use...

A spring with a 5-kg mass and a damping constant 13 is held in spring-mass equilibrium 0.5 meters below the spring equilibrium by a force of 1.5 Newtons. Suppose the spring is pulled down and...

Jackie, age 6 8 , has one son, Taylor, who is 2 9 . In order to acquire some cash flow, Jackie would like to sell some of his assets to Taylor. But he does not want to incur a gift tax liability. As...

Journalize the following redemption transactions: 1. Oolong Corporation retired $130,000 face value bonds on June 30, 2017, at 103. The carrying value of the bonds at the redemption date was...