Help me in making the database

Question

0.00/5 (No votes)

See more:

I had made an database in MS SQL server 2008 for inventory control and Sale system.
I am leaving a link to rapidshare it is just picture of my database.

Database Picture

i need to know that if there is error in it or not. If there is error or it is logically incorrect kindly assist me in making it perfect.

Thanks
Waleed Hassan

Posted 7-May-12 4:40am

Waleed_Hassan

Add a Solution

Comments

Sandeep Mewara 7-May-12 11:11am

I doubt if anyone will spend time reviewing your database. This is a quick question section. If you have any doubt or issue related to same then share it across.

Waleed_Hassan 7-May-12 11:17am

It is just really small database. how can i just send you the picture to just review it. it is not so big.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ekolis · Answer 1 · 2012-05-07T05:36:00

Just a few recommendations:

1. ID's should probably not be nvarchar(50); they would be better as int or guid. This way you can have them be autogenerated by the database.
2. Spaces in column and table names are going to make writing queries messy, since you need to use the square brackets around them. I'd recommend removing the spaces.
3. The name of the Suppliers table is misspelled (Supplers).
4. Some of the table names are singular, while others are plural. I'd recommend standardizing on one or the other.

Mehdi Gholam · Answer 2 · 2012-05-07T05:11:00

Solution 1

Please ask specific questions, we do not have the time to review your work.

Logically correct can mean many things and the important thing is that your customers are happy.

Posted 7-May-12 5:11am

Mehdi Gholam