CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Página 71

b. Display the data in your view sorted by customer_id.
Does this help you to “visualize” how to group the data to
create the totals?
c. Create a query USING THIS VIEW and the
appropriate aggregate function to display customer_id
and the total sales for each customer.
d. Now join to the customer table in order to display the
customer_name as a single field named Customer along
with the total sales. Sort the report by Total sales in
descending order.
This is the end of Lab 7.
===========================================
CIS 336 Quiz 1 (Devry)
FOR MORE CLASSES VISIT
www.cis336study.com
(TCO 3) Normalization works through a series of stages
called normal forms. Typically _________ stages must be
completed before a table can be considered normalized.
(TCO 3) The conflicts between design efficiency,
information requirements, and processing speed are often
resolved through