A Practical Guide to Database Design

ISBN-13: 9780367571931 / Angielski / Miękka / 2020 / 430 str.

Rex Hogan

Opis

This book contains a major update to the previous edition. It covers how to implement and manage the Database Management System (DBMS) itself, how to write scripts to extract and load data from source files, and how to develop user interfaces to view and update data within the database.

Spis treści

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

O autorze

Rex Hogan has over 40 years experience as a database administrator and as a software engineer. This includes over 17 years of experience with Southwestern Bell/AT&T where he became their lead database specialist. During this period, he also taught various undergraduate and graduate classes at Washington University’s Center for the Study of Data Processing in St. Louis, MO. He then worked for TRW/Northrop Grumman for 16 years, primarily as a DBA/senior software engineer where he became a specialist in the rapid design and development of database systems and applications. Finally, he worked for five years as a computer scientist for the Air Force Office of Special Investigations, where he developed computer systems to monitor usage of USAF internet traffic. He has authored and co-authored several books, including A Practical Guide to Database Design (first edition), Diagnostic Techniques for IMS DataBases,and Managing IMS Databases.