Database

Program Your Classmate’s Database

Write a description for a scalar function that would be useful in your database.

1. Display the city and state as Orlando, FL.

2. Make the title ‘Remember Me’ all Upper Case.

3. Show the difference between the year an item was created and the year it was sold for Item # 3;

Write a description for a stored procedure that would be useful in your database.

1. Return the count of Customers.

2. Return all items where the created year is between 1995 & 2000.

3. Return website names, upload years using any integer where website views are greater than or equal to 35000.