Flylib.com
Designing Relational Database Systems (Dv-Mps Designing)
Designing Relational Database Systems (Dv-Mps Designing)
ISBN: 073560634X
EAN: 2147483647
Year: 1999
Pages: 124
Authors:
Rebecca M. Riordan
BUY ON AMAZON
Cover
LOC Page
Foreword
Acknowledgments
Introduction
Chapter 1 -- Basic Concepts
What Is a Database?
Database Tools
The Relational Model
Relational Terminology
The Data Model
Summary
Chapter 2 -- Database Structure
Basic Principles
First Normal Form
Second Normal Form
Third Normal Form
Further Normalization
Summary
Chapter 3 -- Relationships
Terminology
Modeling Relationships
One-to-One Relationships
One-to-Many Relationships
Many-to-Many Relationships
Unary Relationships
Ternary Relationships
Relationships of Known Cardinality
Summary
Chapter 4 -- Data Integrity
Integrity Constraints
Implementing Data Integrity
Summary
Chapter 5 -- Relational Algebra
Nulls and Three-Valued Logic (One More Time)
Relational Operators
Set Operators
Special Relational Operators
Summary
Chapter 6 -- The Design Process
Life Cycle Models
The Database Design Process
A Note on Design Methodologies and Standards
Chapter 7 -- Defining the System Parameters
Determining the System Goals
Developing the Design Criteria
Determining the System Scope
Summary
Chapter 8 -- Defining the Work Processes
Determining Current Work Processes
Analyzing Work Processes
Documenting Work Processes
User Scenarios
Summary
Chapter 9 -- The Conceptual Data Model
Identifying the Data Objects
Defining Relationships
Reviewing Entities
Domain Analysis
Normalization
Summary
Chapter 10 -- The Database Schema
Systems Architectures
Database Schema Components
Security
Summary
Chapter 11 -- Communicating the Design
Audience and Purpose
Document Structure
Executive Summary
System Overview
Work Processes
Conceptual Data Model
Database Schema
User Interface
Change Management
Special Tools
Summary
Chapter 12 -- The Interface as Mediator
Effective Interfaces
Interface Models
User Levels
Putting Users in Charge
Minimizing the Memory Load
Being Consistent
Summary
Chapter 13 -- User Interface Architectures
Supporting the Work Processes
Document Architectures
Summary
Chapter 14 -- Representing Entities in Form Design
Simple Entities
One-to-One Relationships
One-to-Many Relationships
Hierarchies
Many-to-Many Relationships
Summary
Chapter 15 -- Choosing Windows Controls
Representing Logical Values
Representing Sets of Values
Representing Numbers and Dates
Representing Text Values
Summary
Chapter 16 -- Maintaining Database Integrity
Classes of Integrity Constraints
Intrinsic Constraints
Business Constraints
Summary
Chapter 17 -- Reporting
Sorting, Searching, and Filtering Data
Producing Standard Reports
Producing Ad Hoc Reports
Summary
Chapter 18 -- User Assistance
Passive Assistance Mechanisms
Reactive Assistance Mechanisms
Proactive Assistance
User Training
Summary
Footnotes
Glossary
Bibliography
About the Author
Designing Relational Database Systems (Dv-Mps Designing)
ISBN: 073560634X
EAN: 2147483647
Year: 1999
Pages: 124
Authors:
Rebecca M. Riordan
BUY ON AMAZON
Visual C# 2005 How to Program (2nd Edition)
Web Resources
UML Class Diagram with a Property
Algorithms
sealed Methods and Classes
Exercises
MySQL Cookbook
WHERE Clauses and Column Aliases
Creating Temporary Tables
Finding Dates for Days of the Current Week
Sorting by Fixed-Length Substrings
Per-Group Descriptive Statistics
Special Edition Using Crystal Reports 10
Using the Report Creation Wizards
Printing Reports from the Browser
Deploying RAS Environments
Loading Report Files
Installing the RAS SDK
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Getting to Know AutoCAD
Gaining Drawing Strategies: Part 1
Grouping Objects into Blocks
Generating Elevations
Dimensioning a Drawing
Java Concurrency in Practice
Sharing Objects
Part II: Structuring Concurrent Applications
Summary
Summary
Avoiding Liveness Hazards
The Oracle Hackers Handbook: Hacking and Defending Oracle
Attacking the TNS Listener and Dispatchers
Attacking the Authentication Process
Oracle and PL/SQL
Running Operating System Commands
Appendix A Default Usernames and Passwords
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies