表的规范化 [英] Normalization of an table

问题描述

对于下表:

图书(图书，体裁，作者，生日，作者的生日，出版日期，版本，作者的姓名，
AddressOfTheAuthor，出版商，BookTitle，Price，ThePublisher的名称，TypeOfPress)

和

功能依赖项:

类型，新闻类型->价格
作者-> birthDateOfTheAuthor，NameOfTheAuthor，AddressOfTheAuthor
版本->发布者，PublicationDate，TypeOfPress，
书->所有属性，

i)查找表格的归一化形式
ii)对表格进行规范化.

For the next table:

Book(Book,Genre,Author, birthDateOfTheAuthor, PublicationDate, Edition, NameOfTheAuthor,
AddressOfTheAuthor, Publisher, BookTitle, Price,nameOfThePublisher, TypeOfPress)

and

functional dependencies:

Genre,TypeOfPress -> Price
Author -> birthDateOfTheAuthor,NameOfTheAuthor,AddressOfTheAuthor
Edition -> Publisher, PublicationDate, TypeOfPress,
Book -> all atributes,

i) find in which normalization form is the table
ii) do the normalization of the table.

推荐答案

没什么不礼貌，但我想指出一些规则，当您在问答环节中提问时，以防您错过了.

1.您是否已搜索或搜索过解决方案?
7.如果您有学校或大学的作业，请假设您的老师或讲师也在阅读这些论坛.

现在，去谷歌寻求解决方案.如果您只是主动搜索，那里的材料很多.祝你好运.

Not to be rude but I would like to point out some of the rules when asking questions here in Q&A, incase you missed it.

1. Have you searched or Googled for a solution?
7. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.

Now go and Google for a solution. There''s plenty of materials there if you just have the initiative to search. Good luck.

这篇关于表的规范化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！