Database Design and Development: An Essential Guide for IT Professionals

The first and only database primer for today’s global economy

Today’s businesses depend on their databases to provide information essential for their day-to-day operations and to help them take advantage of today’s rapidly growing and maturing electronic commerce opportunities. The primary responsibility for the design and maintenance of these databases rests with a company’s information technology department.

Unlike other IT resources currently available that tend to focus on a particular product, Database Design and Development: An Essential Guide for IT Professionals was created to give today’s IT directors and other IT staff a solid basic knowledge of database design and development to help them make educated decisions about the right database environment for their companies. Today’s IT professionals must understand the fundamentals in order to determine their next steps for specializing in the vast field of database technology.

Database Design and Development: An Essential Guide for IT Professionals answers such common questions as:

• What is the purpose of a database system?
• What are the components of a database system?
• What type of data does your company need to capture?
• How do you design a database for a particular goal?
• How do you capture information through data modeling?
• How do you determine which database will best meet your business objectives?
• What’s involved in effective database management and maintenance?
• How are database systems used to interface with the Internet?

With more than twenty-five years of experience teaching IT courses and designing databases for some of America’s top institutions, the author has succeeded in creating an essential resource for today’s IT managers as well as for students planning a career in information technology.

Table of Contents

Preface.

PART I: BASIC DATABASE CONCEPTS.

1. The Database Approach.

2. Overview of Major Components.

PART II: DATABASE DEVOPMENT PROCESS.

3. Significance of the Database Environment.

4. Database Development Life Cycle.

PART III: CONCEPTUAL DATA MODELING.

5. Data Modeling Basics.

6. Object-Based Data Model: Principles and Components.

7. Entity-Relationship Data Model.

PART IV: THE RELATIONAL DATA MODEL.

8. Relational Data Model Fundamentals.

9. Sematic Data Model to Relational Data Model.

10. Data Normalization Method.

PART V: DESIGN AND IMPLEMENTATION.

11. Completing the Logical Design.

12. The Physical Design Process.

13. Special Implementation Considerations.

PART VI: DATABASE ADMINISTRATION AND MAINTENANCE.

14. Overview of Administration Functions.

15. Data Integrity.

16. Database Security.

17. Ongoing Maintenance and Growth.

PART VII: ADVANCED DATABASE TOPICS.

18. Distributed Database Systems.

19. Database Systems and the Web.

20. Trends in Database Technology.

Appendix A. Legacy System Models: Hierarchical and Network.

Appendix B. Codd's Relational Rules.

Appendix C. Diagramming Conventions and Symbols.

Appendix D. Use of CASE Tools.

Appendix E. Review of Major Commercial DBMSs.

Appendix F. Database Design and Development Summary.

References.

Glossary.

Index.