2008-11-26 10:51:03 -
Research and Markets (www.researchandmarkets.com/research/bd8f42/beginning_database) has announced the addition of John Wiley and Sons Ltd's new report "Beginning Database Design Solutions" to their offering.
Beginning Database Design Solutions introduces IT professionals - both DBAs and database developers - to database design. It explains what databases are, their goals, and why proper design is necessary to achieve those goals. It tells
how to decide what should be in a database to meet the applications requirements. It tells how to structure the database so it gives good performance while minimizing the chance for error.
Each chapter begins with a list of topics covered and ends with a summary providing a descriptive and bulleted list of the key points described in the chapter. Each chapter them includes a list of review questions and a series of exercises to help beginners and students solidify the concepts presented in the chapter.
The book is presented in five parts.
Part 1 provides a quick overview of database and database design fundamentals.
Part 2 then moves quickly to explain the methods and techniques for creating an initial logical design and then refining it into a good database that meets users' requirements.
Part 3 shows how to implement the design using specific types of database platforms - MySQL and Microsoft Access - that should be readily available to beginners.
Part 4 then walks readers through a detailed, pragmatic case example illustrating all phases of the design process.
Part 5 covers advanced topics including how to build databases using SQL scripts, as well as guidelines for database maintenance and security.
The appendixes provide solutions to exercises, as well as sample database designs for common business functions such as order entry, tracking, and fulfillmnet, which readers can directly implement in their own database projects.
This concise introduction teaches database design concepts, methods, and techniques of high-quality database design. You'll explore creating an initial logical design and refining it into a superior database that meets users requirements. Plus, youll see how to implement the design using specific types of database platforms and build databases using SQL scripts. Each chapter begins with a list of topics that will be covered, closes with a summary that provides the key points described in the chapter, and includes a list of review questions and a series of helpful exercises.
Key Topics Covered: I. Introduction to Databases and Database Design. 1. Goals of Effective Database Design. 2. Database Types. 3. Relational Database Fundamentals. II. Database and Design Process Techniques. 4. Understanding User Needs. 5. Translating User Needs Into Data Models. 6. Extracting Business Rules. 7. Normalizing Data. 8. Designing Databases to Support Software Applications. 9. Common Design Patterns. 10. Common Design Pitfalls. III. A Detailed Case Study. 11. User Needs and Requirements. 12. Building a Data Model. 13. Building a Relastional Model. 14. Extracting Business Rules. 15. Normalization and Refinement. 16. Microsoft Access. 17. MySQL. IV. Advanced Topics. 18. Introdution to SQL. 19. Building Databases with SQL Scripts. 20. Databse Elements. 21. Database Security. For more information visit
www.researchandmarkets.com/research/bd8f42/beginning_database
Research and Markets
Laura Wood, Senior Manager,
press@researchandmarkets.com
U.S. Fax: 646-607-1907
Fax (outside U.S.): +353-1-481-1716