Database Solutions: A step by step guide to building databases (2nd Edition)

Database Solutions: A step-by-step guide to building databases 2/eAre 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 necessaryFeatures Includes hints and tips for success with comprehensive guidance on avoiding pitfalls and traps Shows how to create data models using the UML design notation Includes two full-length coded example databases written on Microsoft Access 2002 and Oracle 9i, plus 15 sample data models to adapt to your needs, chosen from seven common business areasNew for this edition! New chapters on SQL (St Cover......Page 1 Database Solutions......Page 4 Brief contents......Page 8 Contents......Page 10 Preface......Page 18 Part 1 Background......Page 26 Introduction......Page 28 Examples of the use of database systems......Page 29 Database approach......Page 32 Functions of a DBMS......Page 37 Advantages and disadvantages of DBMSs......Page 42 Chapter summary......Page 44 Review questions......Page 45 The relational model......Page 46 Terminology......Page 47 Relational integrity......Page 57 Relational languages......Page 59 Review questions......Page 60 SQL and QBE......Page 62 Structured Query Language (SQL)......Page 63 Data manipulation......Page 66 Data definition......Page 88 Query-by-Example (QBE)......Page 92 Chapter summary......Page 98 Exercises......Page 100 The software crisis......Page 103 The information systems lifecycle......Page 104 Database planning......Page 105 System definition......Page 107 Requirements collection and analysis......Page 108 Database design......Page 111 DBMS selection......Page 113 Application design......Page 114 Prototyping......Page 115 Implementation......Page 116 Data conversion and loading......Page 117 Testing......Page 118 Chapter summary......Page 119 Review questions......Page 121 Database administration and security......Page 122 Data administration and database administration......Page 123 Database security......Page 125 Chapter summary......Page 136 Review questions......Page 137 Part 2 Database analysis and design techniques......Page 138 Fact-finding......Page 140 What facts are collected?......Page 141 Fact-finding techniques......Page 143 The StayHome case study......Page 148 Review questions......Page 169 Entity–Relationship modeling......Page 171 Entities......Page 172 Relationships......Page 173 Attributes......Page 176 Multiplicity constraints on relationships......Page 180 Attributes on relationships......Page 187 Design problems with ER models......Page 188 Chapter summary......Page 193 Exercises......Page 194 Normalization......Page 196 Data redundancy and update anomalies......Page 197 First normal form (1NF)......Page 200 Second normal form (2NF)......Page 202 Third normal form (3NF)......Page 205 Chapter summary......Page 210 Exercises......Page 211 Part 3 Logical database design......Page 214 Logical database design – Step 1......Page 216 Introduction to the database design methodology......Page 217 Overview of the database design methodology......Page 219 Introduction to Step 1 of the logical database design methodology......Page 221 Chapter summary......Page 242 Exercise......Page 243 Step 2 Map ER model to tables......Page 244 Chapter summary......Page 268 Review questions......Page 269 Exercise......Page 270 Enhanced ER modeling techniques......Page 271 Specialization/Generalization......Page 272 Creating tables to represent specialization/generalization......Page 279 Chapter summary......Page 281 Exercises......Page 282 Part 4 Physical database design......Page 284 Physical database design – Step 3......Page 286 Comparison of logical and physical database design......Page 287 Overview of the physical database design methodology......Page 288 Step 3 Translate logical database design for target DBMS......Page 289 Chapter summary......Page 301 Exercise......Page 302 Physical database design – Step 4......Page 303 Step 4 Choose file organizations and indexes......Page 304 File organizations and indexes for StayHome with Microsoft Access 2002......Page 317 Chapter summary......Page 319 Exercise......Page 320 Step 5 Design user views......Page 321 Step 6 Design security mechanisms......Page 323 Chapter summary......Page 328 Exercise......Page 329 Step 7 Consider the introduction of controlled redundancy......Page 330 Chapter summary......Page 343 Physical database design – Step 8......Page 344 Step 8 Monitor and tune the operational system......Page 345 Chapter summary......Page 351 Review questions......Page 352 Part 5 Second worked example......Page 354 PerfectPets......Page 356 Using the logical database design methodology......Page 360 Using the physical database design methodology......Page 375 Part 6 Current and emerging trends......Page 400 Current and emerging trends......Page 402 Advanced database applications......Page 403 Weaknesses of Relational DBMSs (RDBMSs)......Page 406 Distributed DBMSs and replication servers......Page 408 Object-oriented DBMSs and object-relational DBMSs......Page 415 Data warehousing......Page 420 OnLine Analytical Processing (OLAP)......Page 424 Data mining......Page 426 Web–database integration and XML......Page 427 Chapter summary......Page 432 Review questions......Page 434 Appendices......Page 436 ER modeling using the Crow’s Feet notation......Page 438 Summary of the database design methodology......Page 445 Advanced logical database design......Page 453 The Business user views of StayHome......Page 454 Step 2.6 Build and check global logical data model......Page 456 Appendix summary......Page 466 File organizationsand indexes......Page 467 Basic concepts......Page 468 Ordered files......Page 470 Hash files......Page 472 Indexes......Page 473 Guidelines for selecting file organizations......Page 478 Clustered and non-clustered tables......Page 481 Appendix summary......Page 485 Common data models......Page 487 Customer order entry......Page 488 Inventory control......Page 491 Asset management......Page 493 Project management......Page 494 Course management......Page 497 Human resource management......Page 500 Payroll management......Page 503 Vehicle rentals......Page 506 Student accommodation......Page 508 Client transportation......Page 511 Publisher printing......Page 513 County library......Page 515 Real estate rentals......Page 518 Travel agent......Page 521 Student results......Page 524 Glossary......Page 528 References......Page 538 Index......Page 540

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

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 successTake 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 The second edition of this book incorporates two relational database design methodologies to teach readers how databases can be implemented in Microsoft Access and Oracle. Not only does the book provide a comprehensive methodology for relational database design, but the authors also show readers how to use the latest installation of UML. Fifteen sample database designs chosen from seven common business areas are located in an Appendix, and an evaluation copy of Rational Rose software is included on the accompanying CD-ROM. Database designers wanting to learn more about relational database theory as well as those just wanting to expand there general database technology knowledge. 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 th 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 should make the database design and build process smoother, quicker and more reliable. The database is now the underlying framework of the information system and has fundamentally changed the way many companies and individuals work. This text explains how to analyze, design and implement a database in a clear and concise way