Saturday, December 16, 2006

Database Design

Database Design Books

  • Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design -- How to design databases that fit business requirements and make software construction easier. In addition to explaining relational database concepts, the author explains data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many), and data types.
  • Handbook of Relational Database Design -- Designing relational databases. It contains two complementary design methodologies: logical data modeling and relational database design. The design methodologies are independent of product-specific implementations and have been applied to numerous relational product environments.
  • Relational Database Design Clearly Explained -- Teaches database practitioners the principles of good relational database design. Discusses tradeoffs between theory and practice. Shows readers how to construct the SQL statements needed to install well-designed relational databases and design
  • Database Design -- Database Design is the book you need to master the fundamentals of relational database design in today's ever-evolving world of database technologies. This book takes an approach to database design to teach the reader how to reach into the inner depths of an organization to understand the business needs, data, and daily processes that will all blend together to formulate a successful database.
  • Database Design and Development: A Visual Approach -- For students in the introductory course in database who want to learn how to design rather than just manipulate relational databases.The book that balances database theory, business problem solving, and hands-on-practice. This book prepares student for the workplace without sacrificing rigorous academic theory.
  • Data Modeling: Database Design -- Data Modeling As Part of Database Design, Steps In Building the Data Model, Identifying Data Objects and Relationships.
  • Data Modeling Overview -- Data Modeling In the Context of Database Design, Components of A Data Model, Why is Data Modeling Important?
  • Database Design Tutorials -- Step-by-step guides to using databases , Database design from scratch
  • Design your own database -- A series of steps identify what your database is about, Summary of the characteristics of a relational database
  • Practical database design, Part 1 -- Primary keys and related matters, Alternate keys and visible identifiers, The problem of the Universally Unique Identifier, Complex datatypes
  • Practical database design, Part 2 -- Normalization, history, and event logging, First Normal Form, Functional dependency, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form, Many-to-many relationships and higher Normal Forms, History tables and event logging
  • Database Design Tutorial -- Relational database design - learn about tables, columns, indexes and foreign key relationships.
  • Designing and creating a Relational Database -- Practical advice about what you should do if you are going to create a database. The main emphasis is on methods of thinking about the data you have (or expect to have) so that it can be stored in the most effective way
  • Relational Database Design -- Decomposition, Normalization Using Functional Dependencies

No comments: