# Database design theory

Material type: TextPublication details: Houndmills, Basingstoke, Hampshire : Macmillan, 1992Description: xv, 259 p. : illustrationsISBN: 0333538137 :; 9780333538135Subject(s): Database designDDC classification: 005.74Item type | Current library | Collection | Call number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|---|

Reference Books | Main Library Reference | Reference | 005.74 LEO (Browse shelf(Opens below)) | Available | 003689 |

##### Browsing Main Library shelves, Shelving location: Reference, Collection: Reference Close shelf browser (Hides shelf browser)

005.74 HEL The science of database management | 005.74 HOC The official guide to Informix/Red Brick data warehousing | 005.74 KRO Database processing : fundamentals, design and implementation | 005.74 LEO Database design theory | 005.74 MAC Modern database management / | 005.74 MAN Database design, application development, and administration | 005.74 MAR Principles of Data-Base Management |

Translation of: Structures des bases de données.

Included Index.

Part 1 Data modelling: a relational data model; concepts of the relational data model, operations defined on a set of relations, normal operations defined on a set of instances, synthesis - data dictionary, example - production workshop, integrity rules; integrity rule, introduction to dependencies, functional and dimensional dependencies, join and decomposition dependencies, inclusion dependencies, relation cycles, other integrity rules, table of ir ranges. Part 2 Transformations: introduction and access paths graph; choice of an internal data model, accuracy of an internal structure, access paths graph, relation graph, join of embedded relations, plan of the second part, transformation of a decomposition into a relation graph, relation graph of a decomposition, use of hinges, from a relation graph to an internal data structure; choice of an access paths graphs, computing methods of embedding access paths. Part 3 Decomposition of a relation: choosing a relation decomposition; decomposing a relation, projection and extension of an integrity rule, qualities of a decomposition, choice crieria for a functional decomposition; introduction, problems encountered, structural elements, a solution - mechanisms for completeness of keys and entities, basic decomposition; introduction, keys to a relation, minimum fd equivalence classes, block of attributes and groups of fds, invariance of non-redundant bases, homogenous coverings and the basic covering, homogenous decompositions and the basic decomposition of a relation, completely homogenous decomposition, relation graph of a completely homogenous decomposition, FD appendix, Appendix: damping functional cycles; damping a functional cycle, validation of a damping. Part 4 Perspectives: perspectives; design process for databases, extended relational data model, control mechanisms, Appendix: use of this mechanism.

An examination of new subject matter called "Structured Information". It is a study of its properties to facilitate exchanges between information processing skills and control skills.

There are no comments on this title.