Database Development

終了済み 投稿 Jun 13, 2011 着払い
終了済み

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

プロジェクトID: #3377011

プロジェクトについて

14個の提案 リモートプロジェクト アクティブ Jul 5, 2011

14 人のフリーランサーが、平均$17/時間で、この仕事に入札しています。

mauryacravings

See private message.

$10.92 USD / 時間
(27件のレビュー)
6.2
expertcoder1vw

See private message.

$11.83 USD / 時間
(68件のレビュー)
6.1
smartsallar

See private message.

$9.1 USD / 時間
(26件のレビュー)
5.4
moizjam

See private message.

$14.56 USD / 時間
(15件のレビュー)
3.9
shazbass

See private message.

$18.2 USD / 時間
(9件のレビュー)
3.9
vorticesoft

See private message.

$10.92 USD / 時間
(5件のレビュー)
3.5
xtosystem

See private message.

$7.28 USD / 時間
(3件のレビュー)
1.3
manjeetsharma

See private message.

$4.55 USD / 時間
(2件のレビュー)
0.9
briank158

See private message.

$45.5 USD / 時間
(0件のレビュー)
0.0
shahdeep1234vw

See private message.

$13.65 USD / 時間
(0件のレビュー)
0.0
itcsliveDev

See private message.

$4.55 USD / 時間
(0件のレビュー)
0.0
CodingStyleDr

See private message.

$18.2 USD / 時間
(レビュー1件)
0.0
olasteve

See private message.

$31.85 USD / 時間
(0件のレビュー)
0.0
guruannamalai

See private message.

$36.4 USD / 時間
(0件のレビュー)
0.0
shahidhusainvw

See private message.

$13.65 USD / 時間
(0件のレビュー)
0.0