The James River Jewelry Co. is a small jewelry shop that specializes n 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 recieve a credit of 50% of the sum of their 10 most recent purchases. The company would also like to record artists and styles and to keep track of what customers are intersted in (artists and styles).
Also most of the jewelry is sold on consignment so the company does not pay the artist of a piece of jewelry until it is sold. Typically the company pays artist 60 percent of the sales prices but the terms are negotiated separaately for each item. For some items the artists 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 slaes percentage.
-Create a report of customers and purchases and customers and credit, and artists and items. Your report should include data that 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 shold have an appropriate set of parameters.
-Create a GUI that permits company pesonnel to graphically query the database. Results of the query should be formatted correctly, and important queries presented as reports(see previous)
For extra credit 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) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).