A Practical Guide To Database Design Practical.Guide.To.Database.Design.From.UBC.Library

User Manual:

Open the PDF directly: View PDF .
Page Count: 431 [warning: Documents this large are best viewed by clicking the View PDF Link!]

Scroll down to view the document on your mobile browser.

Cover
Half Title
Title Page
Copyright Page
Dedication
Table of Contents
Introduction
Author
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.6 BACKUP/RECOVERY
- 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.3.1 The Order Entry Model
- 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.6.1 Using Reports to View a Customer Order
- 6.7 DEPLOYING ACCESS FOR A TEAM OF USERS
  - 6.7.1 Linking to an SQL Server or Oracle Database
- 6.8 THE ROLE OF PASS-THROUGH QUERIES
- QUESTIONS
CHAPTER 7: Using SQL Server
- 7.1 OVERVIEW
  - 7.1.1 Advantages
  - 7.1.2 Change Management for SQL Server
- 7.2 DATABASE CREATION/INSTALLATION
  - 7.2.1 Installation Planning
  - 7.2.2 Software Installation
- 7.3 CREATING DATABASES
  - 7.3.1 Create an SQLSvrLogs Database
  - 7.3.2 Create the University Database
- 7.4 USER ROLES
- 7.5 AUTHORIZED USERS
- 7.6 BACKUP/RECOVERY
- 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
  - 11.4.1 Warning Records Logic
  - 11.4.2 Error Records 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

Navigation menu