Database Development

Closed Posted Jun 13, 2011 Paid on delivery
Closed

PostgresSQL/mySQL & Microsoft Access Database Design

We want to design a database to assist in part of our business operations.

We want this database [along with its forms and queries] to be developed on both Microsoft Access (for local offline access) and on our webserver with MySQL/ PostgresSQL for our website

Both databases would be managed from a single frontend so that one can be copied/compared into the other e.g. DBMAN, DBSchema (more can be found here online)

##Forms.

#Form 1

New Order (which creates or adds to new customer)

New /in stock product (if old, select from list. If new, enter customer information)

New/Old Customer (if old, select from list. If new, enter customer information): request to print with agreement

#Form 2

New Products/service Form

##Tables

The main tables are the

Client table (describing client details)

Product table (describing whether it will be a product or a service with details)

Order list (not orders can be for products not in stock)

#Client table (with standard details)

#Order table (may end up unnecessary if designed as a query that pools data from Client and Product data)

ID

Type

Category -Service

SubCategory

Generic Name

Model #

Description

Estimated Weight

Status; (Pending, Approved, Cancelled, Purchased, Delivered)

Cost

Quantity

#Product Table

Model #

Description

Estimated Weight

Cost e.t.c

Purchase date

Sale date

##Queries

#Query 1

Customer Order1: Pending Orders that need approval

(note 1: We want to be able to print all pending orders separated by Daily purchases of each customer/client and let them print it,

read the agreement and sign it. We also want to the form to hide out internal cost but post the selling cost to the customer based on weight, purchase cost etc )

In essence ALL pending orders by customer

to print a report like and invoice to show.

#QUERY 2

Purchased but unsold products

#QUERY 3

Sales report

## Deliverables

### Skills Required:

Microsoft Access, PostgreSQL, MySQL, Database Modeling,

Please be prepared to answer the following

1. What web RDBMS would you prefer to use? MySQl or PostgresSQL?

[url removed, login to view] tool (or front end) would you use i.e. have experience in to access both the MS ACCESS & rdbms portion?

3. How long will you take in hours to complete both the MS Access portion as well as the web RDBMS portion?

4. What problems or issues do you forsee with the current setup as it is?

[url removed, login to view] you be willing to go further, after the current project by developing a more complex user RDBMS system

something like odesk (i.e. 3 different types of access like contractor, provider etc)

6. Are the questions or the project clear enough? What other questions do you have?

PHP

Project ID: #3377011

About the project

14 proposals Remote project Active Jul 5, 2011

14 freelancers are bidding on average $17/hour for this job

mauryacravings

See private message.

$10.92 USD / hour
(27 Reviews)
6.2
expertcoder1vw

See private message.

$11.83 USD / hour
(68 Reviews)
6.1
smartsallar

See private message.

$9.1 USD / hour
(26 Reviews)
5.4
moizjam

See private message.

$14.56 USD / hour
(15 Reviews)
3.9
shazbass

See private message.

$18.2 USD / hour
(9 Reviews)
3.9
vorticesoft

See private message.

$10.92 USD / hour
(5 Reviews)
3.5
xtosystem

See private message.

$7.28 USD / hour
(3 Reviews)
1.3
manjeetsharma

See private message.

$4.55 USD / hour
(2 Reviews)
0.9
briank158

See private message.

$45.5 USD / hour
(0 Reviews)
0.0
shahdeep1234vw

See private message.

$13.65 USD / hour
(0 Reviews)
0.0
itcsliveDev

See private message.

$4.55 USD / hour
(0 Reviews)
0.0
CodingStyleDr

See private message.

$18.2 USD / hour
(1 Review)
0.0
olasteve

See private message.

$31.85 USD / hour
(0 Reviews)
0.0
guruannamalai

See private message.

$36.4 USD / hour
(0 Reviews)
0.0
shahidhusainvw

See private message.

$13.65 USD / hour
(0 Reviews)
0.0