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
A Practical Guide to Database Design, Second Edition. Preview this item
ClosePreview this item
Checking...

A Practical Guide to Database Design, Second Edition.

Author: Rex Hogan
Publisher: Boca Raton, FL : CRC Press, 2018.
Edition/Format:   eBook : Document : English : Second editionView all editions and formats
Summary:
"Fully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition, is intended for those involved in the design or development of a database system or application. It begins by focusing on how to create a logical data model where data is stored "where it belongs." Next, data usage is reviewed to transform the logical model into a physical data model that will satisfy user  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

Genre/Form: Electronic books
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Rex Hogan
ISBN: 9781351265485 1351265482 9781351265478 1351265474 9781351265461 1351265466 9781351265454 1351265458
OCLC Number: 1022754337
Description: 1 online resource : text file, PDF
Contents: Cover; Half Title; Title Page; Copyright Page; Dedication; Table of Contents; Introduction; Author; CHAPTER 1: Overview of Databases; 1.1 WHATâ#x80;#x99;S A â#x80;#x9C;DATABASEâ#x80;#x9D;?; 1.2 GUARANTEED ACCURACY AND AVAILABILITY OF DATA; 1.2.1 Atomicity; 1.2.2 Consistency; 1.2.3 Isolation; 1.2.4 Durability; 1.3 DYNAMIC ALTERATION OF DESIGN; 1.4 DYNAMIC QUERIESâ#x80;#x94;ANY DATA, ANY TIME; 1.5 REFERENTIAL INTEGRITY ENFORCEMENT; 1.6 BACKUP/RECOVERY; 1.7 FAILOVER; 1.8 TYPICAL INSTALLATION; QUESTIONS; REFERENCES; CHAPTER 2: Data Normalization; 2.1 INTRODUCTION; 2.2 THE LANGUAGE OF NORMALIZATION. 2.3 CREATING THE ENTITY/ATTRIBUTE LIST2.3.1 The Order Entry Model; 2.4 CLEANING UP THE ENTITY/ATTRIBUTE LIST; 2.4.1 Problem Type 1â#x80;#x94;Synonyms; 2.4.2 Problem Type 2â#x80;#x94;Homonyms; 2.4.3 Problem Type 3â#x80;#x94;Redundant Information; 2.4.4 Problem Type 4â#x80;#x94;Mutually Exclusive Data; 2.4.5 Problem Type 1â#x80;#x94;Synonyms; 2.4.6 Problem Type 2â#x80;#x94;Homonyms; 2.4.7 Problem Type 3â#x80;#x94;Redundant Information; 2.4.8 Problem Type 4â#x80;#x94;Mutually Exclusive Data; 2.5 NORMALIZATION; 2.5.1 First Normal Form; 2.5.1.1 Requirement 1â#x80;#x94;Keys to Create Uniqueness; 2.5.1.2 Requirement 2â#x80;#x94;Attributes Can Have Only One Value. 2.5.2 Second Normal Form2.5.3 Third Normal Form; 2.6 CREATING THE DATA MODEL; 2.7 FOURTH NORMAL FORM; 2.8 FIFTH NORMAL FORM; QUESTIONS; REFERENCES; CHAPTER 3: Database Implementation; 3.1 LOGICAL TO PHYSICAL DESIGN; 3.2 USAGE PATH ANALYSIS; 3.3 TABLE KEY AND COLUMN DATA TYPES; 3.4 INDEXES; 3.5 TABLE CREATION; 3.5.1 Using Microsoft Access; 3.5.2 Using SQL Server; 3.5.3 Using Oracle; QUESTIONS; CHAPTER 4: Normalization and Physical Design Exercise; 4.1 INTRODUCTION; 4.2 CREATING THE ENTITY/ATTRIBUTE LIST; 4.3 MOVING TO THIRD NORMAL FORM; 4.4 THE PHYSICAL DATA MODEL; QUESTIONS. CHAPTER 5: The erwin Data Modeling Tool5.1 WHAT IS A DATA MODELING TOOL?; 5.2 WHY DO I NEED A DATA MODELING TOOL?; 5.3 REVERSE ENGINEERING; 5.4 CHANGE MANAGEMENT; 5.5 DOWNLOAD AND INSTALL ERWIN TRIAL SOFTWARE; 5.6 CREATE THE UNIVERSITY LOGICAL DATA MODEL; 5.7 CREATE THE UNIVERSITY PHYSICAL DATA MODEL; 5.8 CREATE AN SQL SERVER UNIVERSITY DATABASE; QUESTIONS; REFERENCE; CHAPTER 6: Using Microsoft Access; 6.1 OVERVIEW; 6.2 MODIFICATIONS TO THE DATABASE DESIGN; 6.3 LOADING DATA INTO TABLES; 6.4 CREATING QUERIES; 6.4.1 Create a Customer-Credit_Card Query; 6.4.2 Create a Query Using SQL Commands. 6.4.3 Filtering Query Results6.5 USING FORMS; 6.5.1 Create a Form to Update Advertised_Items; 6.5.2 Create a Form to Add a New Customer; 6.5.3 Generating a Master Screen for Users; 6.6 GENERATING REPORTS; 6.6.1 Using Reports to View a Customer Order; 6.7 DEPLOYING ACCESS FOR A TEAM OF USERS; 6.7.1 Linking to an SQL Server or Oracle Database; 6.8 THE ROLE OF PASS-THROUGH QUERIES; QUESTIONS; CHAPTER 7: Using SQL Server; 7.1 OVERVIEW; 7.1.1 Advantages; 7.1.2 Change Management for SQL Server; 7.2 DATABASE CREATION/INSTALLATION; 7.2.1 Installation Planning; 7.2.2 Software Installation.

Abstract:

"Fully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition, is intended for those involved in the design or development of a database system or application. It begins by focusing on how to create a logical data model where data is stored "where it belongs." Next, data usage is reviewed to transform the logical model into a physical data model that will satisfy user performance requirements. Finally, it describes how to use various software tools to create user interfaces to review and update data in a database.Organized into 11 chapters, the book begins with an overview of the functionality of database management systems and how they guarantee the accuracy and availability of data. It then describes how to define and normalize data requirements to create a logical data model, then map them into an initial solution for a physical database. The book next presents how to use an industry-leading data modeling tool to define and manage logical and physical data models. After that, it describes how to implement a physical database using either Microsoft Access or SQL Server and how to use Microsoft Access to create windows interfaces to query or update data in tables. The last part of the book reviews software tools and explores the design and implementation of a database using as an example a much more complex data environment for a University. The book ends with a description of how to use PHP to build a web-based interface to review and update data in a database."--Provided by publisher.

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\/1022754337<\/a>> # A Practical Guide to Database Design, Second Edition.<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a>, schema:MediaObject<\/a>, schema:Book<\/a> ;\u00A0\u00A0\u00A0\nlibrary:oclcnum<\/a> \"1022754337<\/span>\" ;\u00A0\u00A0\u00A0\nlibrary:placeOfPublication<\/a> <http:\/\/id.loc.gov\/vocabulary\/countries\/flu<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/WB075\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/SCCM4520\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/WB057\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/355741841#Topic\/database_design<\/a>> ; # Database design<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/WB070\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/WB058\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/355741841#Topic\/computers_databases_general<\/a>> ; # COMPUTERS--Databases--General<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/WB074\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/SCCM4510\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:author<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/355741841#Person\/hogan_rex<\/a>> ; # Rex Hogan<\/span>\n\u00A0\u00A0\u00A0\nschema:bookEdition<\/a> \"Second edition.<\/span>\" ;\u00A0\u00A0\u00A0\nschema:bookFormat<\/a> schema:EBook<\/a> ;\u00A0\u00A0\u00A0\nschema:datePublished<\/a> \"2018<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Cover; Half Title; Title Page; Copyright Page; Dedication; Table of Contents; Introduction; Author; CHAPTER 1: Overview of Databases; 1.1 WHAT\u00E2#x80;#x99;S A \u00E2#x80;#x9C;DATABASE\u00E2#x80;#x9D;?; 1.2 GUARANTEED ACCURACY AND AVAILABILITY OF DATA; 1.2.1 Atomicity; 1.2.2 Consistency; 1.2.3 Isolation; 1.2.4 Durability; 1.3 DYNAMIC ALTERATION OF DESIGN; 1.4 DYNAMIC QUERIES\u00E2#x80;#x94;ANY DATA, ANY TIME; 1.5 REFERENTIAL INTEGRITY ENFORCEMENT; 1.6 BACKUP\/RECOVERY; 1.7 FAILOVER; 1.8 TYPICAL INSTALLATION; QUESTIONS; REFERENCES; CHAPTER 2: Data Normalization; 2.1 INTRODUCTION; 2.2 THE LANGUAGE OF NORMALIZATION.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"\"Fully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition, is intended for those involved in the design or development of a database system or application. It begins by focusing on how to create a logical data model where data is stored \"where it belongs.\" Next, data usage is reviewed to transform the logical model into a physical data model that will satisfy user performance requirements. Finally, it describes how to use various software tools to create user interfaces to review and update data in a database.Organized into 11 chapters, the book begins with an overview of the functionality of database management systems and how they guarantee the accuracy and availability of data. It then describes how to define and normalize data requirements to create a logical data model, then map them into an initial solution for a physical database. The book next presents how to use an industry-leading data modeling tool to define and manage logical and physical data models. After that, it describes how to implement a physical database using either Microsoft Access or SQL Server and how to use Microsoft Access to create windows interfaces to query or update data in tables. The last part of the book reviews software tools and explores the design and implementation of a database using as an example a much more complex data environment for a University. The book ends with a description of how to use PHP to build a web-based interface to review and update data in a database.\"--Provided by publisher.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:exampleOfWork<\/a> <http:\/\/worldcat.org\/entity\/work\/id\/355741841<\/a>> ;\u00A0\u00A0\u00A0\nschema:genre<\/a> \"Electronic books<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:inLanguage<\/a> \"en<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isSimilarTo<\/a> <http:\/\/worldcat.org\/entity\/work\/data\/355741841#CreativeWork\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"A Practical Guide to Database Design, Second Edition.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:productID<\/a> \"1022754337<\/span>\" ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/public.ebookcentral.proquest.com\/choice\/publicfullrecord.aspx?p=5320110<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.vlebooks.com\/vleweb\/product\/openreader?id=none&isbn=9781351265461<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.vlebooks.com\/vleweb\/product\/openreader?id=none&isbn=9781351265478<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/www.taylorfrancis.com\/books\/e\/9781351265485<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/0-www-taylorfrancis-com.pugwash.lib.warwick.ac.uk\/books\/9781351265478<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/www.taylorfrancis.com\/books\/e\/9781351265478<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <https:\/\/search.ebscohost.com\/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1728865<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/VH7QX3XE2P.search.serialssolutions.com\/?V=1.0&L=VH7QX3XE2P&S=JCs&C=TC0001960364&T=marc&tab=BOOKS<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/dx.doi.org\/10.1201\/b22522<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781351265478<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781351265461<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781351265485<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9781351265454<\/a>> ;\u00A0\u00A0\u00A0\nwdrs:describedby<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/1022754337<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Related Entities<\/h3>\n
<http:\/\/dewey.info\/class\/SCCM4510\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/SCCM4520\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/WB057\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/WB058\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/WB070\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/WB074\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/WB075\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dx.doi.org\/10.1201\/b22522<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:IndividualProduct<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/355741841#Person\/hogan_rex<\/a>> # Rex Hogan<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Hogan<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"Rex<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Rex Hogan<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/355741841#Topic\/computers_databases_general<\/a>> # COMPUTERS--Databases--General<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"COMPUTERS--Databases--General<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/355741841#Topic\/database_design<\/a>> # Database design<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Database design<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/id.loc.gov\/vocabulary\/countries\/flu<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Place<\/a> ;\u00A0\u00A0\u00A0\ndcterms:identifier<\/a> \"flu<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/entity\/work\/data\/355741841#CreativeWork\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nschema:isSimilarTo<\/a> <http:\/\/www.worldcat.org\/oclc\/1022754337<\/a>> ; # A Practical Guide to Database Design, Second Edition.<\/span>\n\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781351265454<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1351265458<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781351265454<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781351265461<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1351265466<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781351265461<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781351265478<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1351265474<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781351265478<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9781351265485<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"1351265482<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9781351265485<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/title\/-\/oclc\/1022754337<\/a>>\u00A0\u00A0\u00A0\u00A0a \ngenont:InformationResource<\/a>, genont:ContentTypeGenericResource<\/a> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/www.worldcat.org\/oclc\/1022754337<\/a>> ; # A Practical Guide to Database Design, Second Edition.<\/span>\n\u00A0\u00A0\u00A0\nschema:dateModified<\/a> \"2020-03-16<\/span>\" ;\u00A0\u00A0\u00A0\nvoid:inDataset<\/a> <http:\/\/purl.oclc.org\/dataset\/WorldCat<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n