Book description
Essential Skills--Made Easy!
Learn how to create data models that allow complex data to be analyzed, manipulated, extracted, and reported upon accurately. Data Modeling: A Beginner's Guide teaches you techniques for gathering business requirements and using them to produce conceptual, logical, and physical database designs. You'll get details on Unified Modeling Language (UML), normalization, incorporating business rules, handling temporal data, and analytical database design. The methods presented in this fast-paced tutorial are applicable to any database management system, regardless of vendor.
Designed for Easy Learning
- Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter
- Ask the expert--Q&A sections filled with bonus information and helpful tips
- Try This--Hands-on exercises that show you how to apply your skills
- Notes--Extra information related to the topic being covered
- Self Tests--Chapter-ending quizzes to test your knowledge
Andy Oppel has taught database technology for the University of California Extension for more than 25 years. He is the author of Databases Demystified, SQL Demystified, and Databases: A Beginner's Guide, and the co-author of SQL: A Beginner's Guide, Third Edition, and SQL: The Complete Reference, Third Edition.
Table of contents
- Cover Page
- Data Modeling A Beginner’s Guide
- Copyright Page
- Contents
- Acknowledgments
- Introduction
-
Part I Data Modeling Concepts
- 1 Introduction to Data Modeling
- 2 Relational Model Components
- 3 Data and Process Modeling
- 4 Organizing Database Project Work
-
Part II Data Modeling Details
- 5 Conceptual Data Modeling
- 6 Logical Database Design Using Normalization
- 7 Beyond Third Normal Form
- 8 Physical Database Design
-
Part III Design Alternatives
- 9 Alternatives for Incorporating Business Rules
- 10 Alternatives for Handling Temporal Data
- 11 Modeling for Analytical Databases
- 12 Enterprise Data Modeling
-
Part IV Appendixes
- A Answers to Self Tests
-
B Solutions to Try This Exercises
- Try This 1-1: Refining a Conceptual Model
- Try This 2-1: Conceptual Model Modification
- Try This 3-1: Drawing a Conceptual Model with Nested Subtypes
- Try This 4-1: The Database Life Cycle
- Try This 5-1: Conceptual Model for International Addresses
- Try This 6-1: UTLA Academic Tracking
- Try This 6-2: Computer Books Company
- Try This 7-1: Complex Logical Data Model
- Try This 8-1: Drawing a Physical Data Model
- Try This 8-2: Mapping a Logical Model to a Physical Database Design
- Try This 9-1: Modeling Business Rules
- Try This 10-1: Adding History to Data Structures
- Try This 11-1: Design Star Schema Fact and Dimension Tables
- Try This 12-1: Enterprise Conceptual Model Development
- Index
Product information
- Title: Data Modeling, A Beginner's Guide
- Author(s):
- Release date: November 2009
- Publisher(s): McGraw-Hill
- ISBN: 9780071623995
You might also like
book
Data Architecture: A Primer for the Data Scientist, 2nd Edition
Over the past 5 years, the concept of big data has matured, data science has grown …
book
The Data Model Resource Book, Volume 1
A quick and reliable way to build proven databases for core business functions Industry experts raved …
book
Patterns of Data Modeling
Best-selling author and database expert with more than 25 years of experience modeling application and enterprise …
book
Relational Database Design and Implementation, 4th Edition
Relational Database Design and Implementation: Clearly Explained, Fourth Edition, provides the conceptual and practical information necessary …