i need a free software that can normalize tables and shows the steps it takes.
我需要一个可以规范表格并显示所需步骤的免费软件。
2 个解决方案
#1
2
CASE tools of that kind used to be pretty common but are less common today. If you define a set of attributes and dependencies then it isn't difficult to write code to put them into a given Normal Form - the algorithms to do it are well known and straightforward.
这种CASE工具过去很常见,但今天不太常见。如果您定义了一组属性和依赖关系,那么编写代码将它们放入给定的Normal Form中并不困难 - 执行此操作的算法是众所周知且直截了当的。
However, for most practical purposes such tools are of limited value. Most of the analysis effort needs to be put into identifying the right attributes and desired dependencies in the first place. So actually normalizing them is a fairly simple part of the design process.
然而,对于大多数实际目的而言,这种工具的价值有限。大多数分析工作需要首先确定正确的属性和所需的依赖关系。因此,实际规范化它们是设计过程中相当简单的一部分。
#2
1
Seeing as database normalization requires good analysis skills, understanding the problem domain and being able to decide when to stop normalizing (seeing as there is a trade-off between speed and space savings), you are unlikely find a piece of software that will automatically normalize a database.
看作数据库规范化需要良好的分析技能,理解问题领域并能够决定何时停止规范化(看到速度和空间节省之间存在权衡),您不太可能找到一个会自动规范化的软件一个数据库。
#1
2
CASE tools of that kind used to be pretty common but are less common today. If you define a set of attributes and dependencies then it isn't difficult to write code to put them into a given Normal Form - the algorithms to do it are well known and straightforward.
这种CASE工具过去很常见,但今天不太常见。如果您定义了一组属性和依赖关系,那么编写代码将它们放入给定的Normal Form中并不困难 - 执行此操作的算法是众所周知且直截了当的。
However, for most practical purposes such tools are of limited value. Most of the analysis effort needs to be put into identifying the right attributes and desired dependencies in the first place. So actually normalizing them is a fairly simple part of the design process.
然而,对于大多数实际目的而言,这种工具的价值有限。大多数分析工作需要首先确定正确的属性和所需的依赖关系。因此,实际规范化它们是设计过程中相当简单的一部分。
#2
1
Seeing as database normalization requires good analysis skills, understanding the problem domain and being able to decide when to stop normalizing (seeing as there is a trade-off between speed and space savings), you are unlikely find a piece of software that will automatically normalize a database.
看作数据库规范化需要良好的分析技能,理解问题领域并能够决定何时停止规范化(看到速度和空间节省之间存在权衡),您不太可能找到一个会自动规范化的软件一个数据库。