Gregg Baker orders tickets for two concerts over the Web. His orders are processed, exact seat locations are assigned, and the tickets are mailed separately. One of the sets of tickets gets lost in the mail. When he calls the service number, he does not remember the date or the seat numbers, but the ticket agency is able to locate his tickets quickly because the agency has denormalized the relation.

1. Describe the ticket ordering system by listing the data elements that are kept on the order form and the shipping form.

2. What information did Gregg give the ticket agency to retrieve the information?

Answer rating: 100% (QA)

Solution Ans 1The Ticket ordering system will contain a database of customer ... View the full answer