数据库设计与关系理论

内容简介

[

　　《数据库设计与关系理论（影印版）》的每一章都包含一组练习，它或者展示了如何把理论知识应用到实践中，或者提供了更多的信息，或者要求你验证一些简单的理论结果。如果你非常熟悉数据库的关系模式，并且你希望深入了解数据库设计，那么这本书就完全适合你。

]

目录

prefacepart i setting the scenechapter 1 preliminariessome quotes from the literaturea note on terminologythe running examplekeysthe place of design theoryaims of this bookconcluding remarksexerciseschapter 2 prerequisitesoverviewrelations and relvarspredicates and propositionsmore on suppliers and partsexercisespart ii functional dependencies， boyce/codd normal form，and related matterschapter 3 normalization： some generalitiesnormalization serves two purposesupdate anomaliesthe normal form hierarchynormalization and constraintsconcluding remarksexerciseschapter 4 fds and bcnf （informal）first normal formfunctional dependencieskeys rex， isitedsecond normal formthird normal formboyce/codd normal formexerciseschapter 5 fds and bcnf （formal）preliminary definitionsfunctional dependenciesboyce/codd normal formheath’s theoremexerciseschapter 6 preserving fdsan unfortunate conflictanother example… and another… and still anothera procedure that worksidentity decompositionsmore on the conflictindependent projectionsexerciseschapter 7 fd axiomatizationarmstrong’s axiomsadditional rulesproving the additional rulesanother kind of closureexerciseschapter 8 denormalization”denormalize for performance”?what does denormalization mean?what denormalization isn’t （i）what denormalization isn’t （ii）denormalization considered harmful （i）denormalization considered harmful （ii）a final remarkexercisespart iii join dependencies， fifth normal form，and related matterschapter 9 jds and 5nf （informal）join dependencies——the basic ideaa relvar in bcnf and not 5nfcyclic rulesconcluding remarksexerciseschapter 10 jds and 5nf （formal）join dependenciesfifth normal formjds implied by keysa useful theoremfds aren’t jdsupdate anomalies revisitedexerciseschapter 11 implicit dependenciesirrelevant componentscombining componentsirreducible jdssummary so farthe chase algorithmconcluding remarksexerciseschapter 12 mvds and 4nfan introductory examplemultivalued dependencies （informal）multivalued dependencies （formal）fourth normal formaxiomatizationembedded dependenciesexerciseschapter 13 additional normal formsequality dependenciessixth normal formsuperkey normal formredundancy free normal formdomain-key normal formconcluding remarksexercisespart iv orthogonalitychapter 14 the principle of orthogonal designtwo cheers for normalizationa motivating examplea simpler exampletuples vs. propositionsthe firstexample revisitedthe second example revisitedthe final versiona clarificationconcluding remarksexercisespart v redundancychapter 15 we need more sciencea little historydatabase design is predicate designexample 1example 2example 3example 4example 5example 6example 7example 8example 9example 10example 11example 12managing redundancyrefining the definitionconcluding remarksexercisesappendixesappendix a primary keys are nice but not essentialarguments in favor of the pk：ak distinctionrelvars with more than one keythe invoices and shipments exampleone primary key per entity type?the applicants and employees exampleconcluding remarksappendix b redundancy revisitedappendix c historical notesappendix d answers to exerciseschapter 1chapter 2chapter 3chapter 4chapter 5chapter 6chapter 7chapter 8chapter 9chapter 10chapter 11chapter 12chapter 13chapter 14chapter 15index

封面

书名:数据库设计与关系理论

作者:（英）戴特　著

页数:260

定价:¥49.0

出版社:东南大学出版社

出版日期:2013-01-01

ISBN:9787564138905

PDF电子书大小:58MB 高清扫描完整版