问题描述
对于下表:
图书(图书,体裁,作者,生日,作者的生日,出版日期,版本,作者的姓名,
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.
推荐答案
这篇关于表的规范化的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!