Theory and Practice of Relational Databases

Front Cover
CRC Press, Aug 23, 2001 - Computers - 264 pages
The study of relationship databases is a core component of virtually every undergraduate computer science degree course. This new edition of Theory and Practice of Relationship Databases retains all the features that made the previous edition such as success, and goes on to give even more comprehensive and informative coverage.
Written in a tutorial style and containing a great many examples and exercises as well as extensively using illustrative and explanatory graphics, the author has produced an undergraduate textbook of great depth and clarity that is very easy to follow. The subject of relational databases is brought to life by the writing style and the inclusion of an homogenous case study that reinforces the issues dealt with in each chapter.

The primary objective of the book is to present a comprehensive explanation of the process of development of database application systems within the framework of a set processing paradigm. Since the majority of these applications are built as relationship systems, a complete though reasonably concise account of that model is presented. Dr. Stanczyk has achieved this by concentrating on the issues that contribute significantly to the application development while de-emphasizing purely theoretical aspects of the subject. This has led to an imaginative and highly practical textbook that will be an excellent read for the undergraduate computer science student.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction
1
12 DATABASE ARCHITECTURE
5
13 LOGICAL DATABASE MODELS
8
Data modelling
11
22 ENTITY ATTRIBUTE RELATIONSHIP MODELLING
13
23 EXERCISES
26
The relational model
30
32 NORMALIZED RELATIONS
36
74 TRANSITIVE DEPENDENCIES THIRD NORMAL FORM
136
75 EXERCISES
143
Structured Query Language
144
82 DEFINING DATABASE OBJECTS
145
83 QUERYING THE DATABASE
155
84 MODIFYING THE DATA
168
85 EXERCISES
175
Object databases
176

33 INTEGRITY CONSTRAINTS
40
34 REPRESENTATION OF EAR MODELS BY RELATIONS
44
35 EXERCISES
52
Relational algebra
53
42 PRIMITIVE RETRIEVAL OPERATIONS
56
43 QUERIES AS COMPOUND ALGEBRAIC EXPRESSIONS
71
44 OPTIMIZATION OF ALGEBRAIC EXPRESSIONS
75
45 EXERCISES
85
LEAP the algebraic DBMS
87
52 LEAP ARCHITECTURE
88
53 A SAMPLE RUN OF LEAP
97
54 EXERCISES
100
Normalization
101
62 FUNCTIONAL DEPENDENCY BCNF NORMALIZATION
103
63 EXERCISES
120
Further normalization
121
72 JOIN DEPENDENCY FIFTH NORMAL FORM
125
73 AXIOMS OF DEPENDENCY THEORY
131
92 THE OBJECTORIENTED PARADIGM
179
93 MODELLING COMPLEX OBJECTS FOR DATABASES
180
94 DATA DEFINITION AND MANIPULATION
185
95 OBJECTRELATIONAL DATABASES
189
SQL extensions
194
102 BASIC PROGRAMMING STRUCTURES
195
103 PROCEDURES FUNCTIONS AND TRIGGERS
203
Case study implementation
205
112 SOFTWARE INSTALLATION
207
113 IMPLEMENTATION
208
114 EXERCISES
231
Solutions to exercises
233
Denotations logic sets
243
ALGEBRA OF PROPOSITIONS
244
SET OPERATIONS
245
Bibliography
247
Index
251
Copyright

Other editions - View all

Common terms and phrases

Bibliographic information