James River Jewelry is a small jewelry shop that specializes in hard to find Oriental Jewelry. It has a small but loyal clientele, and it wants to further increase customer loyalty by creating a frequent buy program. In this program after every 10 purchases customers will receive a credit of 50% of the sum of their most recent purchases. The company would also like to record artists and styles and to keep track of what customers are interested in (artists and styles)
Also most of the jewelry is sold on consignment so the company does not pay the artist a piece of jewelry until it is sold. Typically the company pays artists 60% of the sales prices but the terms are negotiated separately for each item. For some items the artists earn a large percentage and for others less. Artists and James River personnel agree on the initial sales prices at the time the item is brought in. When the item has been in the shop for some time, James River may reduce the price or renegotiate the sales percentage.
1)Create a report of customers and purchases and customers and credit, and artists and items. Your report should include data you think would be important to James River. Credit data should include the date of credit, the total amount of the 10 purchases used as the basis of the credit and the credit amount. Similarly sales data should have an appropriate set of parameters.
2)Create a GUI that permits company personnel to graphically query the database. Results of the query should be formatted correctly, and important queries presented as reports.
3)Implement the system as a web enabled database system.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Preferable use access database , VB script and active server pages(ASP)
3) Should be web enabled
windows 2000 or windows XP