web enabled database

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.

## Deliverables

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

## Platform

windows 2000 or windows XP

Habilidades: ASP, PHP

Veja mais: web artists, the web artists, that web company, styles for less, renegotiate, personnel source, keep track of customers, it river, find a work as an artist, find the artist, river, permits, Loyalty program, gui asp, database system, database queries, keep record access, access creating reports, php web gui, create access database reports, create report database php, queries database, customer loyalty database, web query time, database track

Acerca do Empregador:
( 2 comentários ) United States

ID do Projeto: #3016727

Concedido a:


See private message.

$42.5 USD em 4 dias
(2 Comentários)

2 freelancers estão ofertando em média $43 para esse trabalho


See private message.

$42.5 USD in 4 dias
(10 Comentários)