数据库创建实践 [英] practises for database creating

问题描述

我对数据库的体系结构有疑问.
如果您有一个表，并且这些表中有项目，则这些项目将根据类型进行划分.为这些类型创建另一个表是否值得，即使这意味着在该表中仅包含id和类型的名称，还是在现有表中使用名称更好?也许没什么不同吗?还是您知道我可以从中读到的有关此员工的教程?我对最佳做法很感兴趣.

I have a question about the architecture of the database.
If you have a table and in these table are items, which are divided according to types. Is it worthy to create for these types another table even if it means that in that table would be just id and the name of the type, or is it better just to have a name in the existing table? Maybe it’s not a difference? Or do you know a tutorial where I could read about this staff? I''m interested about the best practises.

推荐答案

对于Normaliztion，您应该为此创建单独的表.


将来会有所帮助.您必须在多个表中使用这些类型.

但是同样，它也取决于您的需求！！！

For Normaliztion you should create seprate table for this.


In future it will help you.Whn you have to use these types in multiple table.

But again its depends upon your requirement also !!!

正如Anuj所说，规范化表将解决您的问题. http://en.wikipedia.org/wiki/Database_normalization [

As Anuj said normalizing the tables will solve your problem. http://en.wikipedia.org/wiki/Database_normalization[^]

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