I need a complete database design for an online inventory application based on the following assumptions.
The online application will have a user registration to create an account.
Then the user can setup his company named ABC. Under his company, user can setup his products in that company. Each product will have one or many vendors. User can setup vendors for his products in his company ABC. There should be a table for customers who can place the order for products. Moreover, the products can be leased or rent out too. We need to distinguish between sales orders to sell items and sales order for items that are leased out. I am not looking for a very extensive design for sales order table with line items etc but a simple design covering all the basics of a sales order.
I am only interested in PK and FKs of tables and the relationships between tables. All the rest of the information like firstname, lastname, address can be skipped.
I am looking for a database developer who has strong experience of designing databases.
I need complete SQL script including diagram for the database. I prefer the design in SQL Server 2008r2.
Please do not bid if you don't have at least 5 years of database design experience.