Description
Book SynopsisFully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition is intended for those involved in the design or development of a database system or application. It begins by illustrating how to develop a Third Normal Form data model where data is placed “where it belongs”. The reader is taken step-by-step through the Normalization process, first using a simple then a more complex set of data requirements. Next, usage analysis for each Logical Data Model is reviewed and a Physical Data Model is produced that will satisfy user performance requirements. Finally, each Physical Data Model is used as input to create databases using both Microsoft Access and SQL Server.
The book next shows how to use an industry-leading data modeling tool to define and manage logical and physical data models, and how to create Data Definition Language statements to create or update a database running in SQL Server, Orac
Table of Contents
1. Overview of Databases 2. Normalization 3. Database Implementation 4. Normalization and Physical Design Exercise 5. The erwin Data Modeling Tool 6. Using Microsoft Access 7. Using SQL Server 8. Using Perl to Extract and Load Data 9. Building User Interfaces 10. Creating the University Database Application 11. PHP Implementation and Used
