1) Explain the difference between detail, summary, and exception reports. Give an example of each for an ATM System.

2) Explain the major differences between an ERD Model and a complete physical design database.

3) Define database, table, and system file. Answers must be complete and more than one line. Your answer must clearly define the differences.

4) Choose an alternative system design strategy for a new Travel Expense System and explain why you would choose that alternative and why not the other options. A travel expense system records employee expenses (air fare, meals etc) when they travel on business. Every organization has the same needs.

5) Draw a Normalized Database (please note if easier to do on paper and take a picture please do so but must be legible) Please note that stores belong to regions that belong to retailers. a. Include all keys(primary and foreign) b. add tables where necessary c. add surrogate keys to make tables unique d. add fields to database tables where it makes sense Region Region Chain Chain Region Store ID Store Address Store City Store State Retailer Retail State 1 Walmart Midwest 1 447 Lake Street Culver Indiana 1 Arkansas 2 Jewel Midwest 2 3916 Prentis Downers Grove Illinois 2 Illinois 1 Walmart Midwest 3 615 S Quincy Hinsdale Illinois 1 Illinois 2 Jewel Western 4 5995 Paradise Drive Phoenix Arizona 2 Arkansas 3 Walmart Southern 5 28116 Fox rock Bonita Springs Florida 1 Arkansas