Order Processing System

[ankit.goenka]

Kindly help me design a database for the solution below:



I am looking for a simple solution - please help and oblige
I need a small day to day application which
1. has a vendor master with vendor name and phone no. - people who supply us material
2. has a item master with list of items we deal in




1st thing we need is we have two list boxes, where the user selects (also can search) items he/she need to order ,
the items get saved to items to order.




2nd the admin user - sees what is to be ordered and then - in a datagrid view enters quantity which has to be ordered.
3rd the admin user - assigns items to vendors by selecting vendors from a drop down and again this screen has two list views
the items which are assigned to the selected vendor is saved.


4th a report is generated
with Vendor name and phone number on top and the item list along with quantity below it.


also if sms feature can be added so that a usb modem / data card - having a com port can send sms to the vendors to who
order has to be placed with item name and quantity.

[June7]

For starters, work through these tutorials http://www.rogersaccesslibrary.com/

Identify your data entities and relationships then start building tables.

Explore database templates published by Microsoft.

Code can send emails by various methods. Never seen any code for SMS.

[ankit.goenka]

thanks mate
i need the database design diagram

[orange]

see the free data models here

But you really need to work through some of the tutorials June7 suggested in post#2.

You have to understand the concepts in order to build/design the database diagram.