Make a database in ms access

Assignment Help Computer Engineering

Reference no: EM1336102

Develop a database in MS Access and a set of reports to support a business . The following business rules should be addressed.
· Customer's may order multiple items
· Customer browsing should be monitored so they can be emailed relevant advertising.
· Track inventory (Books, authors, publishers, availability)
· Support customer reviews of books
· Customer may have multiple credit cards on file
· Customers may have a wish list
· Customers can be friends of other customers, and view comments on wish list of their friends.
The following reports should be developed:
· List customer names and email addresses from the customer with the most sales to the least.
· List all books where quantity on hand is below 5.
· Report on books purchased by other customer's who purchased the same book as a particular customer.
· List a customer's friends and their wish list items showing Title, price and availability
· List book titles and total revenue from highest revenue producer to lowest

Reference no: EM1336102

Questions Cloud

Main reasons for it project failure : What are the main reasons for IT project failure? What is the most important thing that management can do to increase the likelihood of IT project success?

Assume the effects on salaries and employment : Assume the effects on salaries and employment of such agreements. Also, indicate some of the reasons why they may be difficult to enforce.

Find a commercial or shareware product : Find a commercial or shareware product, explain how it works, and discuss its security.

Explain mixed accounting : Explain Mixed Accounting and Explain how should Defiance account for the initial sale of the season tickets

Make a database in ms access : create a database in MS Access and a set of reports to support a business . The following business rules should be addressed.

Impact of your organizations reward system : How does your organization motivates and rewards employees, and assess the impact of your organizations reward system on organizational performance.

Discussion of terrorist as victim : Discuss in detail how terrorism creates "indirect" victims. Include a discussion of the terrorist as victim. Please include references and two articles on terrorism.

Explain how have these policies affected the employment : Explain how have these policies affected the employment rates for the housing industry.

Expected net present value for project : What was Salem's expected net present value for this project?

User Account

All Pages