Encerrado

Database

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.

## Deliverables

-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).

## Platform

.

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: slaes, renegotiate, it river, find work artist, buyer loyalty, clientele software, river, permits, loyalty program, engineering artist, database system, database queries, create report database php, queries database, customer loyalty database, database track, consignment sales database, loyalty program database system, initial database, code create database record, customer database package, jewelry sales, enabled data source, web platform jewelry, shop database

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

ID do Projeto: #3015006

20 freelancers estão ofertando em média $222 para este trabalho

Prashantskin

See private message.

$68 USD in 10 dias
(527 Comentários)
7.1
indiaguru

See private message.

$128.35 USD in 10 dias
(41 Comentários)
5.4
miguelgarcia78

See private message.

$42.5 USD in 10 dias
(79 Comentários)
5.2
vw945025vw

See private message.

$340 USD in 10 dias
(30 Comentários)
5.1
nickzam

See private message.

$85 USD in 10 dias
(37 Comentários)
4.5
techjunc

See private message.

$42.5 USD in 10 dias
(21 Comentários)
3.6
bapanghosh

See private message.

$212.5 USD in 10 dias
(6 Comentários)
3.4
bigursusvw

See private message.

$85 USD in 10 dias
(12 Comentários)
2.9
timothyvw

See private message.

$63.75 USD in 10 dias
(15 Comentários)
2.7
stolevw

See private message.

$25.5 USD in 10 dias
(28 Comentários)
2.6
maqronvw

See private message.

$255 USD in 10 dias
(3 Comentários)
2.1
jvmvw

See private message.

$170 USD in 10 dias
(3 Comentários)
1.3
bstechvw

See private message.

$255 USD in 10 dias
(1 Comentário)
0.5
zambio

See private message.

$29.75 USD in 10 dias
(1 Comentário)
0.9
radovanklimo

See private message.

$42.5 USD in 10 dias
(0 Comentários)
0.0
aairamvw

See private message.

$425 USD in 10 dias
(0 Comentários)
0.0
piotrkabath

See private message.

$170 USD in 10 dias
(0 Comentários)
0.0
dmitrygoldshtein

See private message.

$297.5 USD in 10 dias
(0 Comentários)
0.0
vgrubman

See private message.

$1275 USD in 10 dias
(0 Comentários)
0.0
arwaseemvw

See private message.

$425 USD in 10 dias
(0 Comentários)
0.0