This should be a small software to manage a computer shop goods.
All items that is buyed from the reseller should be loaded into goods table, and when are sold to its customer should be downloaded from the table. Some additional table to contain data are needed like distibutor, vendor, customer, vat table and so on.
Some reports should be generated to help computer shopper to print its data (about 5).
The project is based on creation of 10 main forms (4 forms are used to supply data rarely) and 2 details forms to link data beetween data (that can be done upon two of the previous forms). May be some forms can be added, but actually there are 10.
There are few parameters that we can discuss along the way.
Solution should be provided in this way:
- c# 2.0 code with full source code released
- 3 tier infrastructure built in separate dll, data should pass between the DataLayer dll and the ObjectDataSource .net provider, so a future database switch can be done without problems.
- use only .net 2005 components.
Attached there is the db structure (SQL 2005 express) that should be used to create the project. That is just the structure, no trigger as well as no constraints has been created except the relationship.
Project it's a very small project. According to your experience and future improvement we can switch it to a small one improving the fee.