database design and development

Answer the following: . What is a stored procedure? What's the difference between a stored procedure and a function? Required Assignment: 1. Create a procedure called getMyRep that will return a column called 'WhosMyRep'. It will return "Hello [CustomerFirstName] your representative is: [EmployeeFirstName] EmployeeLastName]." The Proc should accept a parameter for customer ID. o Write the command to call this procedure 2. Create a procedure that allows us to look up products by name it should return The name of the product line description, the products name, the quantity, price and MSRP. The lookup should be a "fuzzy" lookup, so partial matches should return. . Execute this procedure passing in a name of 'Susp' 3. As part of the software update, we're looking at creating an employee directory, write a stored procedure that takes in an Office's City and returns the email, phone number(both), and Name (combine first and last name). Null, phone numbers should display as "N/A" Create 4 procedures that completes the CRUD operations on the ProductLine Table.(CRUD means Create, read(select), update, delete) Name the procedures after the operation they perform i.e. Create ProductLine, Read ProductLine, etc.. Your Create procedure should create a new record and add it to the table, it will need to take in the columns as parameters . Your read should select a record based on ProductLine ID . Your update should update based on ProductLineID o Your Delete should remove the record based on ProductLineID 4. Create a proc that gets the total payments that a single customer (by their ID) has made for a date range