Beginning Database Design: From Novice to Professional

  • 4h 15m
  • Clare Churcher
  • Apress
  • 2007

Beginning Database Design: From Novice to Professional 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, you’ll learn how to discover and represent the details and scope of the problem in question.

Database design is not an exact science, and solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep it simple, but allow room for development as situations change or resources permit. The book also features an introduction for implementing the final design in a relational database.

About the Author

CLARE CHURCHER (B.Sc. [Hons], Ph.D. [Physics]) has designed, implemented, and maintained databases for a variety of large and small clients and research projects. She is currently a senior faculty member in the Applied Computing Group at Lincoln University and has recently completed a term as Head of Group. Clare has designed and delivered a range of subjects including analysis and design of information systems, databases, and programming. Her peers have nominated her for a teaching award in recognition of her expertise in communicating her knowledge. Clare has road-tested her design principles on more than 70 undergraduate group database design projects that she has supervised. Examples from these real-life situations are used to illustrate the ideas in this book.

In this Book

  • 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
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Course Database Fundamentals: Working with SQL Commands
Rating 4.7 of 212 users Rating 4.7 of 212 users (212)
Book SQL in 7 Days: A Quick Crash Course in Manipulating Data, Databases Operations, Writing Analytical Queries, and Server-Side Programming