Menu Expand
Database Solutions

Database Solutions

Thomas Connolly | Carolyn Begg

(2007)

Additional Information

Book Details

Abstract

Are you responsible for designing and creating the databases that keep your business running? Or are you studying for a module in database design? If so, Database Solutions is for you! This fully revised and updated edition will make the database design and build process smoother, quicker and more reliable.

Recipe for database success

  • Take one RDMS Ð any of the major commercial products will do: Oracle, Informix, SQL Server, Access, Paradox
  • Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand
  • Use the design and implementation frameworks to plan your timetable, use a common data model that fits your requirements and adapt as necessary

Table of Contents

Section Title Page Action Price
Cover
Database Solutions iii
Brief contents vii
Contents ix
Preface xvii
Part 1 Background 1
Introduction 3
Examples of the use of database systems 4
Database approach 7
Functions of a DBMS 12
Database design 17
Advantages and disadvantages of DBMSs 17
Chapter summary 19
Review questions 20
The relational model 21
What is a data model? 22
Terminology 22
Relational integrity 32
Relational languages 34
Chapter summary 35
Review questions 35
SQL and QBE 37
Structured Query Language (SQL) 38
Data manipulation 41
Data definition 63
Query-by-Example (QBE) 67
Chapter summary 73
Review questions 75
Exercises 75
The database system development lifecycle 78
The software crisis 78
The information systems lifecycle 79
The database system development lifecycle 80
Database planning 80
System definition 82
Requirements collection and analysis 83
Database design 86
DBMS selection 88
Application design 89
Prototyping 90
Implementation 91
Data conversion and loading 92
Testing 93
Operational maintenance 94
Chapter summary 94
Review questions 96
Database administration and security 97
Data administration and database administration 98
Database security 100
Chapter summary 111
Review questions 112
Part 2 Database analysis and design techniques 113
Fact-finding 115
When are fact-finding techniques used? 116
What facts are collected? 116
Fact-finding techniques 118
The StayHome case study 123
Chapter summary 144
Review questions 144
Entity–Relationship modeling 146
Entities 147
Relationships 148
Attributes 151
Strong and weak entities 155
Multiplicity constraints on relationships 155
Attributes on relationships 162
Design problems with ER models 163
Chapter summary 168
Review questions 169
Exercises 169
Normalization 171
Introduction 172
Data redundancy and update anomalies 172
First normal form (1NF) 175
Second normal form (2NF) 177
Third normal form (3NF) 180
Chapter summary 185
Review questions 186
Exercises 186
Part 3 Logical database design 189
Logical database design – Step 1 191
Introduction to the database design methodology 192
Overview of the database design methodology 194
Introduction to Step 1 of the logical database design methodology 196
Chapter summary 217
Review questions 218
Exercise 218
Logical database design – Step 2 219
Step 2 Map ER model to tables 219
Chapter summary 243
Review questions 244
Exercise 245
Enhanced ER modeling techniques 246
Specialization/Generalization 247
Creating tables to represent specialization/generalization 254
Chapter summary 256
Review questions 257
Exercises 257
Part 4 Physical database design 259
Physical database design – Step 3 261
Comparison of logical and physical database design 262
Overview of the physical database design methodology 263
Step 3 Translate logical database design for target DBMS 264
Chapter summary 276
Review questions 277
Exercise 277
Physical database design – Step 4 278
Step 4 Choose file organizations and indexes 279
File organizations and indexes for StayHome with Microsoft Access 2002 292
Chapter summary 294
Review questions 295
Exercise 295
Physical database design – Steps 5 and 6 296
Step 5 Design user views 296
Step 6 Design security mechanisms 298
Chapter summary 303
Part 5 Second worked example 329
PerfectPets – Logical database design 331
PerfectPets 331
Using the logical database design methodology 335
PerfectPets – Physical database design 350
Using the physical database design methodology 350
Part 6 Current and emerging trends 375
Current and emerging trends 377
Advanced database applications 378
Weaknesses of Relational DBMSs (RDBMSs) 381
Distributed DBMSs and replication servers 383
Object-oriented DBMSs and object-relational DBMSs 390
Data warehousing 395
OnLine Analytical Processing (OLAP) 399
Data mining 401
Web–database integration and XML 402
Chapter summary 407
Review questions 409
Appendices 411
Alternative datamodeling notations 413
ER modeling using the Chen notation 413
ER modeling using the Crow’s Feet notation 413
Summary of the database design methodology 420
Advanced logical database design 428
The Business user views of StayHome 429
Step 2.6 Build and check global logical data model 431
Appendix summary 441
File organizationsand indexes 442
Basic concepts 443
Heap files 445
Ordered files 445
Hash files 447
Indexes 448
Guidelines for selecting file organizations 453
Clustered and non-clustered tables 456
Appendix summary 460
Common data models 462
Customer order entry 463
Inventory control 466
Asset management 468
Project management 469
Course management 472
Human resource management 475
Payroll management 478
Vehicle rentals 481
Student accommodation 483
Client transportation 486
Publisher printing 488
County library 490
Real estate rentals 493
Travel agent 496
Student results 499
Glossary 503
References 513
Index 515