SQL Database Model/Design for Inventory Application


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.

Skills: SQL

See more: inventory database design sql, sales order table database, model design database, inventory database design sql server, we looking for sql server developer, user registration design, sql developer online, sql design online, rent sql server, product table design, products database design, product design on sales, product design customers design, product database design, online sql developer, need of sql developer, looking for an application developer, i am looking for a model, diagram design online, design for products, design basics, design and sales product online, abc company, user design experience, sql server online

Project ID: #4577764

47 freelancers are bidding on average $146 for this job


I have 10+ years SQL experience. I'm ready to do it.

$157 USD in 3 days
(69 Reviews)

Hello, I'm interested in your project. Would like to help. What tool should I create diagram or may be simply jpg file will be ok? I have several other questions as well. Best regards, Elena

$222 USD in 7 days
(105 Reviews)

Hi, I can help you in designing of the database. Regards

$144 USD in 3 days
(14 Reviews)

Hi. I'm 6 years experienced in Database design. Let me do this for you quickly.

$189 USD in 3 days
(15 Reviews)

Please check your inbox. Thanks

$201 USD in 3 days
(3 Reviews)

Please, See my private Message.

$157 USD in 3 days
(1 Review)

Hi, Since last 8 year, i am extensively using SQL Server 2000/2005/2008R2. I have expertise in writing Stored Procedures, Triggers, Views and Functions. Involved in designing database, index strategy, table partitio More

$166 USD in 20 days
(6 Reviews)

Database expert with more than 7 years of experience. Did lots of project like this.

$166 USD in 4 days
(3 Reviews)

Hi I have more than nine years experience in Database design and administration. Please check PMB. Thanks.

$155 USD in 4 days
(4 Reviews)

Hi, I am interested and more than qualified to deliver your needs. Please check inbox.

$210 USD in 3 days
(5 Reviews)

Hi I am interested and I have 7 years of database design experience I can do this Thanks

$64 USD in 3 days
(12 Reviews)

Hi! I have more than 12 year exeprience in MS SQL and in the trade Regards.

$244 USD in 3 days
(4 Reviews)

Hi, Please check your PM and hoping your early reply to discuss further.

$236 USD in 6 days
(2 Reviews)

Hello, I have 12 years of experience in software development and business analysis and have worked extensively with database designs. I have gone through your requirements and will be happy to design the database fo More

$150 USD in 3 days
(2 Reviews)

Hi I am having nearly 5 years experience in database design and currently working with a world's top IT giant. I can create a database schema (Logical Database model) for you which will be in 3NF. If you want any More

$130 USD in 3 days
(6 Reviews)

Can handle this. Please read details sent by private message

$50 USD in 2 days
(1 Review)

Hi, I am Professional Freelancer having 5+ years experience in Software design and development. I have done similar application with many futures. So I would like to do with you. Please check private message for comple More

$111 USD in 4 days
(1 Review)

Hi, Please read the Private Message. Regards, Shael.

$45 USD in 1 day
(1 Review)

lol,very easy work dude, I'm a computer engineer I can do it for you ;)

$210 USD in 1 day
(1 Review)

Very easy project for me.

$111 USD in 6 days
(1 Review)