帮助我制作数据库 [英] Help me in making the database

问题描述

我在MS SQL Server 2008中建立了一个用于库存控制和销售系统的数据库.
我留下了一个指向rapidshare的链接，它只是我的数据库的图片.

数据库图片

我需要知道是否有错误.如果有错误或逻辑上不正确，请协助我使其完美.

谢谢
Waleed Hassan

解决方案

只有几点建议:

1. ID可能不应为nvarchar(50)；他们会更好int或guid.这样，您可以让数据库自动生成它们.
2.列名和表名中的空格将使编写查询变得混乱，因为您需要使用方括号将它们括起来.我建议删除空格.
3. Suppliers表的名称拼写错误(供应商).
4.一些表名是单数，而另一些是复数.我建议对两者进行标准化.

逻辑上正确意味着很多事情，重要的是您的客户满意.

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

解决方案

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.

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.

这篇关于帮助我制作数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！