Would an information management system or knowledge management system benefit the Campagnes? If…

Would an information management system or knowledge management system benefit the Campagnes? If so, explain why.

You may download a database file (WildOutfit.mdb) for this case from the textbook's Web page at www.course.com. Use Microsoft Access or a comparable database management system to answer the following questions:

(a). What are the names of the tables in the database?

(b). For each table, what are the primary keys and foreign keys?

(c). What are the relationships between the tables (many-ta-many, one-ta-many, one-to-one)?

(d). Create a query to determine the number of sales transactions that occurred from the Web site.

(e). Create a query to find the total number of camping equipment items sold.

(f). Create a query to find the names and ZIP codes · of all customers who purchased the litewalkers Hiking Boots.

(g). Create a standard invoice using your DBMS reparting function. The invoice should include the follOWing items: customer information; a listing of the transactions that make up the invoice, including each product, quantity, and price; a calculation of the subtotal, tax (use a 5 percent sales tax rate); and total.