Theory and Practice of Relational DatabasesThe 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. |
Contents
1 | |
2 Data modelling | 10 |
3 The relational model | 28 |
4 Relational algebra | 50 |
5 LEAPthe algebraic DBMS | 83 |
6 Normalization | 97 |
7 Further normalization | 116 |
8 Structured Query Language | 139 |
9 Object databases | 170 |
10 SQL extensions | 186 |
11 Case studyimplementation | 197 |
Solutions to exercises | 223 |
Denotations logic sets | 233 |
237 | |
240 | |
Other editions - View all
Theory and Practice of Relational Databases Stefan Stanczyk,Bob Champion,Richard Leyton No preview available - 2001 |
Theory and Practice of Relational Databases Stefan Stanczyk,Bob Champion,Richard Leyton No preview available - 2001 |
Common terms and phrases
ADDRESS allows application associated attributes BCNF called Chapter CODE complex concept condition consider contains corresponding course create data structures database DBMS defined definition delete described developed domains employee entity example execution exists expressions functional dependencies further given hence holds identify illustrated implemented insert instance integrity join language LECTURER logical means Message method module natural necessarily Normal Note null object object type occurrence operations original particular possible presented primary key principle processing produce programming properties query Real World record refer REGISTER relation relational algebra relational model relationship relevant represent representation require result retrieval rules shown in Fig simple specified stored string structure student TITLE true tuples typically unique University update values variable