Using the WPC database, create an SQL script named WPC-Create-New-Views-And- Functions.sql to answer Project Question
Create a view of COMPUTER named ComputerMakeAndModel View that displays SerialNumber and then uses the ComputerMakeAndModel function you created in Project Question 1 to display an attribute named ComputerType. Test the Mew with an appropriate SQL SELECT statement.
Project Question 1
Create and test a user-defined function named ComputerMakeAndModel to concatenate Make and Model to form the {Make}: {Model} character string as you did without a function in Project Question 2.
Project Question 2
Create a view of COMPUTER named ComputerView that displays SerialNumber and then Make and Model combined as one attribute named ComputerType. Place a colon and a space between Make and Model in the format: Dell: OptiPlex 9020. Do not create a user-defined function to perform this task. Run the statement to create the view, and then test the view with an appropriate SQL SELECT statement.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.