skip to content
Covid-19 virus
COVID-19 Resources

Reliable information about the coronavirus (COVID-19) is available from the World Health Organization (current situation, international travel). Numerous and frequently-updated resource results are available from this WorldCat.org search. OCLC’s WebJunction has pulled together information and resources to assist library staff as they consider how to handle coronavirus issues in their communities.

Image provided by: CDC/ Alissa Eckert, MS; Dan Higgins, MAM
Database design and relational theory : normals forms and all that jazz Preview this item
ClosePreview this item
Checking...

Database design and relational theory : normals forms and all that jazz

Author: C J Date
Publisher: Sebastopol, Calif. : O'Reilly Media, ©2012.
Series: Theory in practice (Sebastopol, Calif.)
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
"What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand - drawing on lessons learned over four decades of experience to demonstrate why proper  Read more...
Rating:

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

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

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

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Date, C.J.
Database design and relational theory.
Sebastopol, CA : O'Reilly Media, 2012
(OCoLC)781679191
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: C J Date
ISBN: 9781449330217 1449330215 9781449330200 1449330207 1449328016 9781449328016
OCLC Number: 794190158
Description: 1 online resource (xiii, 260 pages) : illustrations.
Contents: Part I. Setting the scene --
part II. Functional dependencies, Boyce/Codd normal form, and related matters --
part III. Join dependencies, fifth normal form, and related matters --
part IV. Orthogonality --
part V. Redundancy.
Series Title: Theory in practice (Sebastopol, Calif.)
Responsibility: C.J. Date.

Abstract:

Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid subtle errors or performance problems.  Read more...

Reviews

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

Tags

Be the first.

Similar Items

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


\n\n

Primary Entity<\/h3>\n
<http:\/\/www.worldcat.org\/oclc\/794190158<\/a>> # Database design and relational theory : normals forms and all that jazz<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Book<\/a>, schema:CreativeWork<\/a>, schema:MediaObject<\/a> ;\u00A0\u00A0\u00A0\nlibrary:oclcnum<\/a> \"794190158<\/span>\" ;\u00A0\u00A0\u00A0\nlibrary:placeOfPublication<\/a> <http:\/\/id.loc.gov\/vocabulary\/countries\/cau<\/a>> ;\u00A0\u00A0\u00A0\nlibrary:placeOfPublication<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Place\/sebastopol_calif<\/a>> ; # Sebastopol, Calif.<\/span>\n\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Warning: This malformed URI has been treated as a string - \'https:\/\/www.safaribooksonline.com\/library\/view\/-\/9781449336370\/?ar?orpq&email=^u\'<\/span>\" ;\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Warning: This malformed URI has been treated as a string - \'http:\/\/images.contentreserve.com\/ImageType-100\/2858-1\/{67C0A0EB-2CCD-4D9E-820A-11F7A3B77629}Img100.jpg\'<\/span>\" ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Topic\/relational_databases_design_and_construction<\/a>> ; # Relational databases--Design and construction<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/005.756\/e23\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Topic\/computers_programming_languages_sql<\/a>> ; # COMPUTERS--Programming Languages--SQL<\/span>\n\u00A0\u00A0\u00A0\nschema:bookFormat<\/a> schema:EBook<\/a> ;\u00A0\u00A0\u00A0\nschema:copyrightYear<\/a> \"2012<\/span>\" ;\u00A0\u00A0\u00A0\nschema:creator<\/a> <http:\/\/viaf.org\/viaf\/101729193<\/a>> ; # C. J. Date<\/span>\n\u00A0\u00A0\u00A0\nschema:datePublished<\/a> \"2012<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"\"What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand - drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.\"--Publisher\'s website.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Part I. Setting the scene -- part II. Functional dependencies, Boyce\/Codd normal form, and related matters -- part III. Join dependencies, fifth normal form, and related matters -- part IV. Orthogonality -- part V. Redundancy.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:exampleOfWork<\/a> <http:\/\/worldcat.org\/entity\/work\/id\/1110805363<\/a>> ;\u00A0\u00A0\u00A0\nschema:genre<\/a> \"Electronic books<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:inLanguage<\/a> \"en<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isPartOf<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Series\/theory_in_practice<\/a>> ; # Theory in practice<\/span>\n\u00A0\u00A0\u00A0\nschema:isPartOf<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Series\/theory_in_practice_sebastopol_calif<\/a>> ; # Theory in practice (Sebastopol, Calif.)<\/span>\n\u00A0\u00A0\u00A0\nschema:isSimilarTo<\/a> <http:\/\/www.worldcat.org\/oclc\/781679191<\/a>> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Database design and relational theory : normals forms and all that jazz<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:productID<\/a> \"794190158<\/span>\" ;\u00A0\u00A0\u00A0\nschema:publication<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/794190158#PublicationEvent\/sebastopol_calif_o_reilly_media_2012<\/a>> ;\u00A0\u00A0\u00A0\nschema:publisher<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Agent\/o_reilly_media<\/a>> ; # O\'Reilly Media<\/span>\n\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.myilibrary.com?id=612535<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/www.dawsonera.com\/guard\/protected\/dawson.jsp?name=https:\/\/idp.shu.ac.uk\/shibboleth&dest=http:\/\/www.dawsonera.com\/abstract\/9781449330217<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/proxy.library.carleton.ca\/login?url=http:\/\/proquest.safaribooksonline.com\/?uiCode=carleton&xmlId=9781449330187<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/samples.overdrive.com\/?crid=67C0A0EB-2CCD-4D9E-820A-11F7A3B77629&.epub-sample.overdrive.com<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.vlebooks.com\/vleweb\/product\/openreader?id=none&isbn=9781449330217<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/site.ebrary.com\/id\/10758863<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.vlebooks.com\/vleweb\/product\/openreader?id=none&isbn=9781449330200<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> \"http:\/\/images.contentreserve.com\/ImageType-100\/2858-1\/{67C0A0EB-2CCD-4D9E-820A-11F7A3B77629}Img100.jpg<\/span>\" ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/excerpts.cdn.overdrive.com\/FormatType-410\/2858-1\/67C\/0A0\/EB\/DatabaseDesignandRelationalTheoryNorm9781449330200.epub<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/ebooks.kcls.org\/ContentDetails.htm?ID=67C0A0EB-2CCD-4D9E-820A-11F7A3B77629<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> \"https:\/\/www.safaribooksonline.com\/library\/view\/-\/9781449336370\/?ar?orpq&email=^u<\/span>\" ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/londonmet.eblib.com\/patron\/FullRecord.aspx?p=896077<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/proquest.tech.safaribooksonline.de\/9781449330187<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/proquest.safaribooksonline.com\/9781449330187<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/www.overdrive.com\/search?q=67C0A0EB-2CCD-4D9E-820A-11F7A3B77629<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/overdrive.bpl.org\/ContentDetails.htm?ID=67C0A0EB-2CCD-4D9E-820A-11F7A3B77629<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/www.safaribooksonline.com\/library\/view\/-\/9781449330187\/?ar<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/search.ebscohost.com\/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=450538<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/VH7QX3XE2P.search.serialssolutions.com\/?V=1.0&L=VH7QX3XE2P&S=JCs&C=TC0000667378&T=marc&tab=BOOKS<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/proquestcombo.safaribooksonline.com\/9781449330187<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/public.ebookcentral.proquest.com\/choice\/publicfullrecord.aspx?p=896077<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781449328016<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781449330200<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781449330217<\/a>> ;\u00A0\u00A0\u00A0\nwdrs:describedby<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/794190158<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Related Entities<\/h3>\n
<http:\/\/dewey.info\/class\/005.756\/e23\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/ebooks.kcls.org\/ContentDetails.htm?ID=67C0A0EB-2CCD-4D9E-820A-11F7A3B77629<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Borrow this eBook from OverDrive<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Agent\/o_reilly_media<\/a>> # O\'Reilly Media<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nbgn:Agent<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"O\'Reilly Media<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Place\/sebastopol_calif<\/a>> # Sebastopol, Calif.<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Place<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Sebastopol, Calif.<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Series\/theory_in_practice<\/a>> # Theory in practice<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nbgn:PublicationSeries<\/a> ;\u00A0\u00A0\u00A0\nschema:hasPart<\/a> <http:\/\/www.worldcat.org\/oclc\/794190158<\/a>> ; # Database design and relational theory : normals forms and all that jazz<\/span>\n\u00A0\u00A0\u00A0\nschema:name<\/a> \"Theory in practice<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Series\/theory_in_practice_sebastopol_calif<\/a>> # Theory in practice (Sebastopol, Calif.)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nbgn:PublicationSeries<\/a> ;\u00A0\u00A0\u00A0\nschema:hasPart<\/a> <http:\/\/www.worldcat.org\/oclc\/794190158<\/a>> ; # Database design and relational theory : normals forms and all that jazz<\/span>\n\u00A0\u00A0\u00A0\nschema:name<\/a> \"Theory in practice (Sebastopol, Calif.)<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Topic\/computers_programming_languages_sql<\/a>> # COMPUTERS--Programming Languages--SQL<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"COMPUTERS--Programming Languages--SQL<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Topic\/relational_databases_design_and_construction<\/a>> # Relational databases--Design and construction<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:hasPart<\/a> <http:\/\/id.loc.gov\/authorities\/subjects\/sh86007768<\/a>> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Relational databases--Design and construction<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/id.loc.gov\/vocabulary\/countries\/cau<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Place<\/a> ;\u00A0\u00A0\u00A0\ndcterms:identifier<\/a> \"cau<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/londonmet.eblib.com\/patron\/FullRecord.aspx?p=896077<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"E-book - Full text from ebookcentral<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/proxy.library.carleton.ca\/login?url=http:\/\/proquest.safaribooksonline.com\/?uiCode=carleton&xmlId=9781449330187<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Safari (Access restricted to 5 simultaneous users)<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/VH7QX3XE2P.search.serialssolutions.com\/?V=1.0&L=VH7QX3XE2P&S=JCs&C=TC0000667378&T=marc&tab=BOOKS<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"VIEW FULL TEXT<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/viaf.org\/viaf\/101729193<\/a>> # C. J. Date<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Date<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"C. J.<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"C. J. Date<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781449328016<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1449328016<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781449328016<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781449330200<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1449330207<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781449330200<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781449330217<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1449330215<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781449330217<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/oclc\/781679191<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nrdfs:label<\/a> \"Database design and relational theory.<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Print version:<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isSimilarTo<\/a> <http:\/\/www.worldcat.org\/oclc\/794190158<\/a>> ; # Database design and relational theory : normals forms and all that jazz<\/span>\n\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/title\/-\/oclc\/794190158<\/a>>\u00A0\u00A0\u00A0\u00A0a \ngenont:InformationResource<\/a>, genont:ContentTypeGenericResource<\/a> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/www.worldcat.org\/oclc\/794190158<\/a>> ; # Database design and relational theory : normals forms and all that jazz<\/span>\n\u00A0\u00A0\u00A0\nschema:dateModified<\/a> \"2020-06-12<\/span>\" ;\u00A0\u00A0\u00A0\nvoid:inDataset<\/a> <http:\/\/purl.oclc.org\/dataset\/WorldCat<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/title\/-\/oclc\/794190158#PublicationEvent\/sebastopol_calif_o_reilly_media_2012<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:PublicationEvent<\/a> ;\u00A0\u00A0\u00A0\nschema:location<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Place\/sebastopol_calif<\/a>> ; # Sebastopol, Calif.<\/span>\n\u00A0\u00A0\u00A0\nschema:organizer<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/1110805363#Agent\/o_reilly_media<\/a>> ; # O\'Reilly Media<\/span>\n\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<https:\/\/www.dawsonera.com\/guard\/protected\/dawson.jsp?name=https:\/\/idp.shu.ac.uk\/shibboleth&dest=http:\/\/www.dawsonera.com\/abstract\/9781449330217<\/a>>\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Go to eBook via Dawsonera<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n