I need a relatively simple SQL database project with a VB.Net GUI, with forms for queries and data input and the reports to go along with the queries. I have four tables right now but if you see a need for more to get it to work right, feel free to add them, or change existing ones.
Table Customers Table Product Table Cust_Prod
Cust_ID Prod_ID Cust_ID
Cust_name Prod_name Prod_ID
Cust_Address Prod_Price Invoice_Num
Invoice_pay (payment method cash, charge, etc)
Here is what it needs to do. I need to be able to go in and:
Add customer data Add Product data
Update Customer data Update Product data
Delete Customer data Delete product data
Input invoices Delete Invoices
Queries: List Customers from certain dates or all
List what certain customers have bought with dates and prices
List Products with prices
list Customers who bought certain products
List Products (all or individual items) bought during a time period or over all time
List Invoices all or individual over all time or certain time periods
I listed the tables I needed but if you find a better way of getting it done or need to add to the tables then feel free to do so.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
I need a SQL database with a VB.NET GUI, Forms, queries and reports. It needs to work on Windows XP Pro.