Beginning Database Design: From Novice to Professional

by Clare Churcher

Overview

This book uses clear and simple language to highlight the types of problems that can result from poor database design, to motivate readers to do good design. The focus is on implementing designs in relational databases such as Microsoft Access, PostgreSQL, MySQL.

Product Details

ISBN-13:	9781430203667
Publisher:	Apress
Publication date:	12/22/2007
Sold by:	Barnes & Noble
Format:	eBook
Pages:	300
File size:	5 MB

About the Author

Clare Churcher is currently a senior lecturer in the Department of Applied Computing at Lincoln University, New Zealand. She holds a degree in physics with first class honors and completed a Ph.D in physics at the University of Canterbury, New Zealand. She has done postdoctoral research in the Cavendish Laboratory at the University of Cambridge, England. Clare s research interests are in the management and visualization of data especially for scientific research. She has a background in database design, and has taught programming, analysis and design of information systems, and database management at undergraduate level, as well as software engineering and scientific visualization at post graduate level.

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.