eBooks-it.org Logo
eBooks-IT.org Inner Image

Beginning Database Design

From Novice to Professional

2nd Edition
Beginning Database Design Image

Book Details:

Publisher:Apress
Series: Apress , From Novice To Professional
Author:Clare Churcher
Edition:2
ISBN-10:1430242094
ISBN-13:9781430242093
Pages:252
Published:Jun 26 2012
Posted:Nov 19 2014
Language:English
Book format:PDF
Book size:13.33 MB

Book Description:

Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, youll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language What youll learn Avoid the most common pitfalls in database design. Create clear use cases from project requirements. Design a data model to support the use cases. Apply generalization and specialization appropriately. Secure future flexibility through a normalized design. Ensure integrity through relationships, keys, and constraints. Successfully implement your data model as a relational schema. Who this book is for Beginning Database Design, Second Edition is aimed at desktop power users, developers, database administrators, and others who are charged with caring for data and storing it in ways that preserve its meaning and integrity. Desktop users will appreciate the coverage of Excel as a plausible database for research systems and lab environments. Developers and database designers will find insight from the clear discussions of design approaches and their pitfalls and benefits. All readers will benefit from learning a modern notation for documenting designs that is based upon the widely used and accepted Universal Modeling Language. Table of Contents What Can Go Wrong? Guided Tour of the Development Process Initial Requirements and Use Cases Learning from the Data Model Developing a Data Model Generalization and Specialization From Data Model to Relational Schema Normalization More on Keys and Constraints Queries User Interface Other Implementations

Download Link:

Related Books:

Beginning Database Design

Beginning Database Design Image
The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficientlyShows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and OracleCovers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performanceProvides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements...

Database Design for Mere Mortals

A Hands-On Guide to Relational Database Design
Database Design for Mere Mortals Image
2nd Edition
'This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike's approach whilst simple is completely professional, and I can recommend this book to any novice database designer.' Sandra Barker, Lecturer, University of South Australia, Australia 'Databases are a critical infrastructure technology for information systems and today's business. Mike Hernandez has written a literate explanation of database technologya topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase pr...

Physical Database Design

The database professional's guide to exploiting indexes, views, storage, and more
Physical Database Design Image
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be impr...



2007 - 2021 © eBooks-IT.org