Question: Modify the CUSTOMER table to included two new attributes CUST DOB
Modify the CUSTOMER table to included two new attributes: CUST_DOB and CUST_AGE. Customer 1000 was born on March 15, 1979, and customer 1001 was born on December 22, 1988.
Relevant QuestionsAssuming you completed problem 10, write the query that will list the names and ages of your customers. Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the sameinvoice.Create a procedure named prc_cus_balance_update that will take the invoice number as a parameter and update the customer balance.How do systems analysis and systems development fit into a discussion about information systems?List and briefly explain the four steps performed during the logical design stage.
Post your question