March 2003
Beginner
672 pages
14h
English
book
Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
by Michael J. Hernandez
Content preview from Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
The Purpose of This Book
In general terms, there are three phases to the overall database-development process.
-
Logical design: The first phase involves determining and defining tables and their fields, establishing primary and foreign keys, establishing table relationships, and determining and establishing the various levels of data integrity.
-
Physical implementation: The second phase entails creating the tables, establishing key fields and table relationships, and using the proper tools to implement the various levels of data integrity.
-
Application development: The third phase involves creating an application that allows a single user or group of users to interact with the data stored in the database. The application-development phase ...