skip to content
Relational database design : a practitioner's guide Preview this item
ClosePreview this item
Checking...

Relational database design : a practitioner's guide

Author: Charles J Wertz
Publisher: Boca Raton, Fla. : CRC Press ; Greenwich, CT : Manning Publications, 1992.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:

Covers the practical and theoretical aspects of database and systems design. Interrelated topics are presented, including a review of basic systems and database concepts, design methodologies, the  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Additional Physical Format: Online version:
Wertz, Charles J.
Relational database design.
Boca Raton, Fla. : CRC Press ; Greenwich, CT : Manning Publications, 1992
(OCoLC)624418542
Document Type: Book
All Authors / Contributors: Charles J Wertz
ISBN: 0849374502 9780849374500
OCLC Number: 26545111
Description: xiii, 298 pages : illustrations ; 25 cm
Contents: CONCEPTS. What is a Database? What is a Database Management System? What are Data Models? What are the Basic Data Building Blocks? A METHODOLOGY? Why Have a Method? Systems Analysis Methods. Now, What About Database Design? Do the Two Cycles Fit Together? Is Anything Missing? An Annotated Example. Additional Comments-Does One Size Fit All? RELATIONAL DATABASE. Why the Relational Model? The Relational Model. Domains. Keys. Relational Data Manipulations. Structured Query Language. SQL Data Definition. SQL Data Manipulation. Some Additional Data Manipulations. Update Commands. Embedded SQL. Views. Data Security. Other SQL Facilities. Criticisms of SQL. Is it Really Relational? Does it Matter? NORMALIZATION. What is Normalization? Mathematical Functions. Functional Dependencies. First Normal Form. Second Normal Form. Third Normal Form. Boyce/Codd Normal Form. Multivalued Facts. Fourth Normal Form. Fifth Normal Form. One, Two, Three, Four, Five Normal Forms. Is That All There is to It? ENTITY RELATIONSHIP MODELS. What is an Entity Relationship Model? Why Introduce This? Definitions. The Technique We Will Use. Why Entities and Relationships? How Can We Tell Them Apart? Entities vs. Attributes. What Are We Really Doing Here? Examples. Let's Review. Alternative Techniques. ADVANCED MODELLING CONCEPTS. Why Do We Have Problems with Data Models? What is Really Going on Here? OK, Now What? Examples. Relating Two Entities of the Same Type-(Bill of Materials). Structured Methodology Revisited. Global Models, Integration, Disparate Views, and All That. View Integration. Concluding Remarks. DEFINITIONS AND CONSTRAINTS. Definitions. Entity Definitions. Relationship Definitions. Data Element Definitions-Domains. Data Element Definitions-Attributes of Entities and Relationships. Now, What's in a Name? Keys and Identifiers. Data Encoding. Referential and Entity Integrity. Other Constraints. Security. What's Next. PHYSICAL DESIGN. The Media. Hashing Functions. Indexed Access. Significance of Hardware Related Issues. Access Map. To Normalize or Not (With a Digression Regarding Optimizers). File Size and Placement. Calculating Space Required. Backup, Journaling, Recovery, Concurrency. Structure Changes, Change Management. Extracts. DISTRIBUTED SYSTEMS. What is a Distributed System? What are the Physical Design Issues for Distributed Systems? How Can We Decide? What About Clients and Servers? DESIGN METHODOLOGY. On Methods in General. The Recommended Approach. Identify a Problem and Propose a Solution. Research Existing Situation. Identify Entities, Relationships, and Data Elements. Identify User Views and Elements Contained in User Views. Revaluate and Redefine If Necessary. Develop Details of Proposed Solution. Normalize. Determine Volumes, Access Patterns. Final Database Design. Technical Design, Programming. Test, Document, Convert, Train, Implement. Final Comments. EXAMPLE. The Business Situation. Context Diagram. Domains. Entities and Relationships Version 1. Data Flow Diagram. Entities and Relationships Version 2. Normalization. Determine Volumes, Access Patterns. Final Database Design. Parting Thoughts. Bibliography.
Responsibility: Charles J. Wertz.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/26545111> # Relational database design : a practitioner's guide
    a schema:Book, schema:CreativeWork ;
    library:oclcnum "26545111" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/365281655#Place/greenwich_ct> ; # Greenwich, CT
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/365281655#Place/boca_raton_fla> ; # Boca Raton, Fla.
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/flu> ;
    schema:about <http://dewey.info/class/005.756/e20/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/365281655#Topic/diseno_de_bases_de_datos> ; # Diseño de bases de datos
    schema:about <http://experiment.worldcat.org/entity/work/data/365281655#Topic/relationele_databanken> ; # Relationele databanken
    schema:about <http://experiment.worldcat.org/entity/work/data/365281655#Topic/bases_de_datos_relacionales> ; # Bases de datos relacionales
    schema:about <http://experiment.worldcat.org/entity/work/data/365281655#Topic/gedistribueerde_gegevensverwerking> ; # Gedistribueerde gegevensverwerking
    schema:about <http://id.worldcat.org/fast/888032> ; # Database design
    schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
    schema:bookFormat bgn:PrintBook ;
    schema:creator <http://viaf.org/viaf/17299697> ; # Charles J. Wertz
    schema:datePublished "1992" ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/365281655> ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/624418542> ;
    schema:name "Relational database design : a practitioner's guide"@en ;
    schema:productID "26545111" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/26545111#PublicationEvent/boca_raton_fla_crc_press_greenwich_ct_manning_publications_1992> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/365281655#Agent/crc_press> ; # CRC Press
    schema:publisher <http://experiment.worldcat.org/entity/work/data/365281655#Agent/manning_publications> ; # Manning Publications
    schema:workExample <http://worldcat.org/isbn/9780849374500> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/26545111> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/365281655#Agent/manning_publications> # Manning Publications
    a bgn:Agent ;
    schema:name "Manning Publications" ;
    .

<http://experiment.worldcat.org/entity/work/data/365281655#Place/boca_raton_fla> # Boca Raton, Fla.
    a schema:Place ;
    schema:name "Boca Raton, Fla." ;
    .

<http://experiment.worldcat.org/entity/work/data/365281655#Place/greenwich_ct> # Greenwich, CT
    a schema:Place ;
    schema:name "Greenwich, CT" ;
    .

<http://experiment.worldcat.org/entity/work/data/365281655#Topic/bases_de_datos_relacionales> # Bases de datos relacionales
    a schema:Intangible ;
    schema:name "Bases de datos relacionales"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/365281655#Topic/diseno_de_bases_de_datos> # Diseño de bases de datos
    a schema:Intangible ;
    schema:name "Diseño de bases de datos"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/365281655#Topic/gedistribueerde_gegevensverwerking> # Gedistribueerde gegevensverwerking
    a schema:Intangible ;
    schema:name "Gedistribueerde gegevensverwerking"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/365281655#Topic/relationele_databanken> # Relationele databanken
    a schema:Intangible ;
    schema:name "Relationele databanken"@en ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/888032> # Database design
    a schema:Intangible ;
    schema:name "Database design"@en ;
    .

<http://viaf.org/viaf/17299697> # Charles J. Wertz
    a schema:Person ;
    schema:familyName "Wertz" ;
    schema:givenName "Charles J." ;
    schema:name "Charles J. Wertz" ;
    .

<http://worldcat.org/isbn/9780849374500>
    a schema:ProductModel ;
    schema:isbn "0849374502" ;
    schema:isbn "9780849374500" ;
    .

<http://www.worldcat.org/oclc/624418542>
    a schema:CreativeWork ;
    rdfs:label "Relational database design." ;
    schema:description "Online version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/26545111> ; # Relational database design : a practitioner's guide
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.