现有数据库是否可以规范化? [英] Is normalisation possible with the existing database?

问题描述

在我们公司中，在.NET中开发了一种产品作为前端，而在SQL Server 2005中则开发了一种产品.

最初，当他们开始项目时，他们没有遵循DB规范化技术.现在他们考虑进行数据库归一化，其中数据库仅包含一个包含数千行的表.

是否可以拆分此现有表并实现规范化?

In our company, a product was developed in .NET as front end and SQL Server 2005 as backend.

Initially when they started the project they didn''t follow the DB normalization techniques. Now they thought to go for DB normalization in which the database contains only one table that contains thousands of rows.

Is it possible to split this existing table and implement normalization?

Can any one tell me how to go step by step?

推荐答案

现在很难做到这一点.涉及的成本很高，因为很可能需要更改整个应用程序.
但是，您只需要在Internet上搜索，就可以逐步获取大量有关标准化的信息.

It will be quite difficult to do this now. The cost involved is high, as most likely your entire application will need to be changed.
However, you can just search the internet, you will get tons of information on normalizing step by step.

这篇关于现有数据库是否可以规范化?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！