Data Modeling Essentials: Analysis, Design, and InnovationAn innovative "how-to" guide and design aid to data modeling. This book discusses the theory and practice of data modeling as a design activity, and shows the reader how to increase quality and stimulate creativity with new modeling approaches. The book is useful as both a basic learning tool, and a thought provoking guide to higher achievement in designing and executing data models. |
Contents
What Is Data Modeling? | 3 |
Basic Normalization | 25 |
The Entity Relationship Approach | 51 |
Copyright | |
10 other sections not shown
Other editions - View all
Common terms and phrases
allocated allow application approach basic BCNF Branch business rules business specialists candidate key Chapter Client Code columns common complex concepts constraints convention corporate data model corporate model creative Customer dassify data flow diagrams data management data structure database management systems Date definition diagram Dose Drug Name Drug Short Name Employee Number enforce entity instance example Fifth Normal Form Figure foreign key function model handle hierarchy Hospital Number identify implement information systems involve issues Item logical database design look look-up table many-to-many relationships nonkey nontransferable normal forms one-to-many relationships one-to-one relationships Operation Number Operation Type option performance Person physical database designer Policy primary key problem Product program logic Qualification real world record redundancy relational database relational model repeating group represent requirements result Salesperson Snapshot specify stable subtypes and supertypes Surgeon Number surrogate keys technique third normal form transferable update users weak entity