Muutke küpsiste eelistusi

E-raamat: Database Design for Mere Mortals: 25th Anniversary Edition

3.93/5 (535 hinnangut Goodreads-ist)
  • Formaat: 640 pages
  • Sari: For Mere Mortals
  • Ilmumisaeg: 02-Dec-2020
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780136788171
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 42,11 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Database Design for Mere Mortals: 25th Anniversary EditionSuurem pilt
  • Formaat: 640 pages
  • Sari: For Mere Mortals
  • Ilmumisaeg: 02-Dec-2020
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780136788171
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez&;s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he&;s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , 25th Anniversary, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You&;ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules. This edition has been updated to reflect the current landscape for databases and their prevalent uses in the world. 

 

Coverage includes

  • Understanding database types, models, and design terminology
  • Discovering what good database design can do for you&;and why bad design can make your life miserable
  • Setting objectives for your database, and transforming those objectives into real designs
  • Analyzing a current database so you can identify ways to improve it
  • Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views
  • Ensuring the appropriate level of data integrity for each application
  • Identifying and establishing business rules

Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.


Foreword xix
Preface xxi
Introduction xxix
What's New in the Fourth Edition xxxi
Who Should Read This Book xxxii
The Purpose of This Book xxxiii
How to Read This Book xxxvi
How This Book Is Organized xxxvii
A Word about the Examples and Techniques in This Book xl
PART I RELATIONAL DATABASE DESIGN
1(64)
Chapter 1 The Relational Database
3(14)
Topics Covered in This
Chapter
3(1)
What Is a Database?
3(2)
The Relational Database
5(6)
Retrieving Data
7(2)
Advantages of a Relational Database
9(1)
Relational Database Management Systems
10(1)
What's Next?
11(2)
Summary
13(1)
Review Questions
14(3)
Chapter 2 Design Objectives
17(16)
Topics Covered in This
Chapter
17(1)
Why Should You Be Concerned with Database Design?
17(2)
The Importance of Theory
19(2)
The Advantage of Learning a Good Design Methodology
21(1)
Objectives of Good Design
22(1)
Benefits of Good Design
23(1)
Database-Design Methods
24(3)
Traditional Design Methods
24(2)
The Design Method Presented in This Book
26(1)
Normalization
27(3)
Summary
30(1)
Review Questions
31(2)
Chapter 3 Terminology
33(32)
Topics Covered in This
Chapter
33(1)
Why This Terminology Is Important
33(2)
Value-Related Terms
35(6)
Data
35(1)
Information
35(2)
Null
37(1)
The Value of Null
38(1)
The Problem with Null
39(2)
Structure-Related Terms
41(9)
Table
41(3)
Field
44(1)
Record
45(1)
View
46(2)
Keys
48(2)
Index
50(1)
Relationship-Related Terms
50(9)
Relationships
50(2)
Types of Relationships
52(5)
Types of Participation
57(1)
Degree of Participation
57(2)
Integrity-Related Terms
59(2)
Field Specification
59(1)
Data Integrity
59(2)
Summary
61(1)
Review Questions
62(3)
PART II THE DESIGN PROCESS
65(388)
Chapter 4 Conceptual Overview
67(14)
Topics Covered in This
Chapter
67(1)
The Importance of Completing the Design Process
68(1)
Defining a Mission Statement and Mission Objectives
69(1)
Analyzing the Current Database
70(2)
Creating the Data Structures
72(1)
Determining and Establishing Table Relationships
73(1)
Determining and Defining Business Rules
74(1)
Determining and Defining Views
75(1)
Reviewing Data Integrity
75(2)
Summary
77(1)
Review Questions
78(3)
Chapter 5 Starting the Process
81(26)
Topics Covered in This
Chapter
81(1)
Conducting Interviews
82(9)
Participant Guidelines
84(2)
Interviewer Guidelines (These Are for You)
86(5)
Defining the Mission Statement
91(5)
The Well-Written Mission Statement
91(2)
Composing a Mission Statement
93(3)
Defining the Mission Objectives
96(7)
Well-Written Mission Objectives
97(2)
Composing Mission Objectives
99(4)
Summary
103(1)
Review Questions
104(3)
Chapter 6 Analyzing the Current Database
107(58)
Topics Covered in This
Chapter
107(1)
Getting to Know the Current Database
107(6)
Paper-Based Databases
111(1)
Legacy Databases
111(2)
Conducting the Analysis
113(1)
Looking at How Data Is Collected
113(3)
Looking at How Information Is Presented
116(4)
Conducting Interviews
120(8)
Basic Interview Techniques
121(7)
Before You Begin the Interview Process
128(1)
Interviewing Users
128(15)
Reviewing Data Type and Usage
129(2)
Reviewing the Samples
131(4)
Reviewing Information Requirements
135(8)
Interviewing Management
143(5)
Reviewing Current Information Requirements
144(1)
Reviewing Additional Information Requirements
145(1)
Reviewing Future Information Requirements
146(1)
Reviewing Overall Information Requirements
147(1)
Compiling a Complete List of Fields
148(14)
The Preliminary Field List
148(8)
The Calculated Field List
156(1)
Reviewing Both Lists with Users and Management
156(6)
Summary
162(2)
Review Questions
164(1)
Chapter 7 Establishing Table Structures
165(68)
Topics Covered in This
Chapter
165(1)
Defining the Preliminary Table List
166(8)
Identifying Implied Subjects
166(2)
Using the List of Subjects
168(4)
Using the Mission Objectives
172(2)
Defining the Final Table List
174(15)
Refining the Table Names
176(6)
Indicating the Table Types
182(1)
Composing the Table Descriptions
182(7)
Associating Fields with Each Table
189(2)
Refining the Fields
191(17)
Improving the Field Names
191(5)
Using an Ideal Field to Resolve Anomalies
196(3)
Resolving Multipart Fields
199(2)
Resolving Multivalued Fields
201(7)
Refining the Table Structures
208(21)
A Word about Redundant Data and Duplicate Fields
208(1)
Using an Ideal Table to Refine Table Structures
209(7)
Establishing Subset Tables
216(13)
Summary
229(2)
Review Questions
231(2)
Chapter 8 Keys
233(30)
Topics Covered in This
Chapter
233(1)
Why Keys Are Important
234(1)
Establishing Keys for Each Table
234(17)
Candidate Keys
235(8)
Primary Keys
243(6)
Alternate Keys
249(1)
Non-keys
250(1)
Table-Level Integrity
251(1)
Reviewing the Initial Table Structures
251(8)
Summary
259(1)
Review Questions
260(3)
Chapter 9 Field Specifications
263(30)
Topics Covered in This
Chapter
263(1)
Why Field Specifications Are Important
264(2)
Field-Level Integrity
266(1)
Anatomy of a Field Specification
267(16)
General Elements
267(8)
Physical Elements
275(3)
Logical Elements
278(5)
Using Unique, Generic, and Replica Field Specifications
283(4)
Defining Field Specifications for Each Field in the Database
287(4)
Summary
291(1)
Review Questions
292(1)
Chapter 10 Table Relationships
293(76)
Topics Covered in This
Chapter
293(1)
Why Relationships Are Important
294(1)
Types of Relationships
295(17)
One-to-One Relationships
296(2)
One-to-Many Relationships
298(3)
Many-to-Many Relationships
301(7)
Self-Referencing Relationships
308(4)
Identifying Existing Relationships
312(11)
Establishing Each Relationship
323(20)
One-to-One and One-to-Many Relationships
323(8)
The Many-to-Many Relationship
331(6)
Self-Referencing Relationships
337(5)
Reviewing the Structure of Each Table
342(1)
Refining All Foreign Keys
343(6)
Elements of a Foreign Key
343(6)
Establishing Relationship Characteristics
349(12)
Defining a Deletion Rule for Each Relationship
349(5)
Identifying the Type of Participation for Each Table
354(3)
Identifying the Degree of Participation for Each Table
357(3)
Verifying Table Relationships with Users and Management
360(1)
A Final Note
360(1)
Relationship-Level Integrity
361(5)
Summary
366(2)
Review Questions
368(1)
Chapter 11 Business Rules
369(42)
Topics Covered in This
Chapter
369(1)
What Are Business Rules?
370(5)
Types of Business Rules
373(2)
Categories of Business Rules
375(3)
Field-Specific Business Rules
375(1)
Relationship-Specific Business Rules
376(2)
Defining and Establishing Business Rules
378(16)
Working with Users and Management
378(1)
Defining and Establishing Field-Specific Business Rules
379(7)
Defining and Establishing Relationship-Specific Business Rules
386(8)
Validation Tables
394(6)
What Are Validation Tables?
394(1)
Using Validation Tables to Support Business Rules
395(5)
Reviewing the Business Rule Specifications Sheets
400(8)
Summary
408(1)
Review Questions
409(2)
Chapter 12 Views
411(34)
Topics Covered in This
Chapter
411(1)
What Are Views?
411(2)
Anatomy of a View
413(11)
Data View
413(5)
Aggregate View
418(4)
Validation View
422(2)
Determining and Defining Views
424(17)
Working with Users and Management
425(1)
Defining Views
426(8)
Reviewing the Documentation for Each View
434(7)
Summary
441(1)
Review Questions
442(3)
Chapter 13 Reviewing Data Integrity
445(8)
Topics Covered in This
Chapter
445(1)
Why You Should Review Data Integrity
446(1)
Reviewing and Refining Data Integrity
446(3)
Table-Level Integrity
447(1)
Field-Level Integrity
447(1)
Relationship-Level Integrity
448(1)
Business Rules
448(1)
Views
448(1)
Assembling the Database Documentation
449(2)
Done at Last!
451(1)
Summary
452(1)
PART III OTHER DATABASE DESIGN ISSUES
453(22)
Chapter 14 Bad Design--What Not to Do
455(10)
Topics Covered in This
Chapter
455(1)
"Flat-File" Design
456(1)
Spreadsheet Design
457(4)
Dealing with the Spreadsheet View Mindset
459(2)
Database Design Based on the Database Software
461(2)
A Final Thought
463(1)
Summary
463(2)
Chapter 15 Bending or Breaking the Rules
465(8)
Topics Covered in This
Chapter
465(1)
When May You Bend or Break the Rules?
465(4)
Designing an Analytical Database
465(1)
Improving Processing Performance
466(3)
Documenting Your Actions
469(2)
Summary
471(2)
Chapter 16 In Closing
473(2)
PART IV APPENDIXES
475(78)
Appendix A Answers to Review Questions
477(24)
Appendix B Diagram of the Database Design Process
501(18)
Appendix C Design Guidelines
519(10)
Appendix D Documentation Forms
529(4)
Appendix E Database-Design Diagram Symbols
533(2)
Appendix F Sample Designs
535(6)
Appendix G On Normalization
541(10)
Appendix H Recommended Reading
551(2)
Glossary 553(14)
References 567(2)
Index 569
Michael J. Hernandez is a man with many talents and has done quite a bit in his life, and he continues to do many things to keep him busy. You could say he's a modern-day Renaissance Man.

For instance, he has been an independent database consultant with more than 25 years of experience in the technology industry, and has been a contributing author to a wide variety of magazine articles, white papers, books, and periodicals. Mike has also been a top-rated and noted technical instructor for two national training organizations, the government, the military, the private sector, and companies throughout the United States, and he has been a top-rated speaker and presenter at numerous national and international conferences. He also worked full-time at Microsoft for seven years as a program manager, product manager, and marketing manager in the Visual Studio Group.

Mike is mainly pursuing his artistic side at this point in his life. He is currently a professional actor (with more than seven years of experience as of this writing), performing in commercials for the likes of U.S. Bank, Allstate Insurance, and Subaru; in TV for shows such as Veep, American Crime, and Unbelievable; and feature films such as Ernesto's Manifesto, The Honor List, and Almost Home.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97801367881716e.html
Märksõnad: