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 |