A Practical Guide to Database Design

Book PDF Download

Table of Contents

Half Title

Dedication

Introduction

CHAPTER 1: Overview of Databases

1.1 WHAT’S A “DATABASE”?

1.2 GUARANTEED ACCURACY AND AVAILABILITY OF DATA

1.3 DYNAMIC ALTERATION OF DESIGN

1.4 DYNAMIC QUERIES—ANY DATA, ANY TIME

1.5 REFERENTIAL INTEGRITY ENFORCEMENT

1.7 FAILOVER

1.8 TYPICAL INSTALLATION

QUESTIONS

REFERENCES

CHAPTER 2: Data Normalization

2.1 INTRODUCTION

2.2 THE LANGUAGE OF NORMALIZATION

2.3 CREATING THE ENTITY/ATTRIBUTE LIST

2.4 CLEANING UP THE ENTITY/ATTRIBUTE LIST

2.5 NORMALIZATION

2.6 CREATING THE DATA MODEL

2.7 FOURTH NORMAL FORM

2.8 FIFTH NORMAL FORM

QUESTIONS

REFERENCES

CHAPTER 3: Database Implementation

3.1 LOGICAL TO PHYSICAL DESIGN

3.2 USAGE PATH ANALYSIS

3.3 TABLE KEY AND COLUMN DATA TYPES

3.4 INDEXES

3.5 TABLE CREATION

QUESTIONS

CHAPTER 4: Normalization and Physical Design Exercise

4.1 INTRODUCTION

4.2 CREATING THE ENTITY/ATTRIBUTE LIST

4.3 MOVING TO THIRD NORMAL FORM

4.4 THE PHYSICAL DATA MODEL

QUESTIONS

CHAPTER 5: The erwin Data Modeling Tool

5.1 WHAT IS A DATA MODELING TOOL?

5.2 WHY DO I NEED A DATA MODELING TOOL?

5.3 REVERSE ENGINEERING

5.4 CHANGE MANAGEMENT

5.5 DOWNLOAD AND INSTALL ERWIN TRIAL SOFTWARE

5.6 CREATE THE UNIVERSITY LOGICAL DATA MODEL

5.7 CREATE THE UNIVERSITY PHYSICAL DATA MODEL

5.8 CREATE AN SQL SERVER UNIVERSITY DATABASE

QUESTIONS

REFERENCE

CHAPTER 6: Using Microsoft Access

6.1 OVERVIEW

6.2 MODIFICATIONS TO THE DATABASE DESIGN

6.3 LOADING DATA INTO TABLES

6.4 CREATING QUERIES

6.5 USING FORMS

6.6 GENERATING REPORTS

6.7 DEPLOYING ACCESS FOR A TEAM OF USERS

6.8 THE ROLE OF PASS-THROUGH QUERIES

QUESTIONS

CHAPTER 7: Using SQL Server

7.1 OVERVIEW

7.2 DATABASE CREATION/INSTALLATION

7.3 CREATING DATABASES

7.4 USER ROLES

7.7 LOADING DATA INTO TABLES

7.8 CREATING VIEWS

7.9 MANUAL QUERIES AND EDITS

7.10 USING STORED PROCEDURES

7.11 USING SQL SERVER AGENT

QUESTIONS

CHAPTER 8: Using Perl to Extract and Load Data

8.1 WHY PERL?

8.2 PERL VERSUS PYTHON

8.3 WINDOWS VERSUS UNIX

8.4 REVIEW KEY MATCHING FEATURES

8.5 MONITOR SQL SERVER LOGS

8.6 MONITORING WINDOWS LOGS

8.7 OTHER APPLICATIONS AND USES

8.8 LOADING DATA INTO TABLES

8.9 SUMMARY

QUESTIONS

REFERENCE

CHAPTER 9: Building User Interfaces

9.1 MICROSOFT ACCESS IN A TYPICAL OFFICE ENVIRONMENT

9.2 USE MICROSOFT ACCESS AS GUI

9.3 .NET FRAMEWORK

9.4 PHP

9.5 JAVA

QUESTIONS

CHAPTER 10: Creating the University Database Application

10.1 CREATE TABLES FOR UNIVERSITY ENVIRONMENT

10.2 CREATE RELATIONSHIPS TO ENFORCE REFERENTIAL INTEGRITY

10.3 DESIGN A SCREEN TO ADD NEW STUDENTS

10.4 CREATE A SCREEN TO ENROLL STUDENTS IN A CLASS

10.5 CREATE A SCREEN TO ASSIGN GRADES

10.6 CREATE SCREENS TO ENTER MIDTERM AND FINAL GRADES

10.7 CREATE A “MAIN” MENU

10.8 DEVELOPING APPLICATIONS FOR UNIVERSITY ADMINISTRATORS

QUESTIONS

CHAPTER 11: PHP Implementation and Use

11.1 WHY PHP?

11.2 SYSTEM COMPONENTS

11.3 DESIGN OF WEB-BASED INTERFACE

11.4 SCRIPT LOGIC

QUESTIONS

REFERENCES

APPENDIX A: WARNING MESSAGES

APPENDIX B: ERROR MESSAGES

APPENDIX C: UNIVERSITY DDL

APPENDIX D: SEARCH FOR TERMS

APPENDIX E: SQL SERVER LOG CHECK

INDEX

A Practical Guide to
HBATABASE
DESIEN

Second Edition

Related