• Title Database Design, 2nd Edition
• Author(s) Adrienne Watt, Nelson Eng
• Publisher: The BCcampus Open Textbook Project; eBook (Creative Commons Licensed)
• License(s): Attribution 4.0 International (CC BY 4.0)
• Hardcover/Paperback: N/A
• eBook: HTML, PDF (142 pages), ePub, Mobi (Kindle), etc.
• Language: English
• ISBN-10: N/A
• ISBN-13: N/A
• Share This:  

Book Description

This book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers.

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. This book 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.

• Adrienne Watt worked as an IT professional in a variety of senior positions including project manager, database designer, administrator and business analyst. Recently she has been exploring a wide range of technology-related tools and processes to improve delivery methods and enhance learning for her students.
• Nelson Eng spent 11 years as a computer systems coordinator with Science World of B.C. and 14 years as a computer science and information systems instructor with Douglas College.

• Amazon

• Database Theory and Systems
• SQL - The Structured Query Language
• Linux and Unix

• Database Design, 2nd Edition (Adrienne Watt, et al)
• The Mirror Site (1) - HTML
• The Mirror Site (2) - PDF

• Database Performance at Scale: A Practical Guide

  Discover critical considerations and best practices for improving database performance based on what has worked, and failed, across thousands of teams and use cases in the field.

• Database Systems for Management (James F. Courtney, et al)

  This book provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field.

• Database Fundamentals (Neeraj Sharma, et al)

  Learn the basics of relational database theory and other information models. This book discusses database logical and physical design, and introduces you to the SQL language. Practice with hands-on exercises!

• Build Your Own Database From Scratch (James Smith)

  This book contains a walk-through of a minimal persistent database implementation. The implementation is incremental. We start with a B-Tree, then add a new concept with each chapter, and eventually go from a simple KV to a mini relational DB.

• Databases, Types, and the Relational Model: The Third Manifesto

  This book can be seen as an abstract blueprint for the design of a DBMS and the language interface to such a DBMS. In particular, it serves as a basis for a model of type inheritance. This book is essential reading for database professionals.

• Theory of Relational Databases (David Maier)

  The book is intended for a second course in databases, but is an excellent reference for researchers in the field. The material covered includes relational algebra, functional dependencies, multivalued and join dependencies, normal forms, etc.

• Foundations of Databases: The Logical Level (Alice's book)

  Written by three leading researchers in the field, this book provides in-depth coverage of the theory concerning the logical level of database management systems, including both classical and advanced topics.

• Readings in Database Systems, Fifth Edition (Peter Bailis, et al.)

  This book provides both students and professionals with a grounding in database research and a technical context for understanding recent innovations in the field. The readings included treat the most important issues in the database area for any DBMS professional.

• Database Lifecycle Management: Achieving Continuous Delivery

  This book describes how to apply the business and technical approaches of Database Lifecycle Management (DLM) in order to make database change management processes more visible, predictable and measurable.

• An Introduction to Relational Database Theory, 2nd Edition

  This book delivers a thorough discussion of the foundations of the relational model of database design along with a systematic treatment of the formal theory for the model, introduces you to the theory of relational databases, and SQL.

• Database Design with UML and SQL, 4th Edition (Alvaro Monge)

  This book teaches you how to use the Unified Modeling Language (UML) and Structured Query Language (SQL) to develop and implement the best possible design for your databases. It is also designed to be used as an individual self-study tutorial.

• 45 Database Performance Tips for Developers (Phil Factor, et al)

  Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.