Muutke küpsiste eelistusi

E-raamat: Theory and Practice of Relational Databases 2nd edition [Taylor & Francis e-raamat]

(Oxford Brookes University, UK), , (Oxford Brookes University, UK)
  • Formaat: 264 pages
  • Ilmumisaeg: 23-Aug-2001
  • Kirjastus: CRC Press
  • ISBN-13: 9781315272832
Teised raamatud teemal:
  • Taylor & Francis e-raamat
  • Hind: 180,03 €*
  • * hind, mis tagab piiramatu üheaegsete kasutajate arvuga ligipääsu piiramatuks ajaks
  • Tavahind: 257,19 €
  • Säästad 30%
  • Formaat: 264 pages
  • Ilmumisaeg: 23-Aug-2001
  • Kirjastus: CRC Press
  • ISBN-13: 9781315272832
Teised raamatud teemal:
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.
Preface vii
Introduction
1(10)
The concept of database
1(4)
Database architecture
5(3)
Logical database models
8(3)
Data modelling
11(19)
Modelling the real world
11(2)
Entity - Attribute --- Relationship modelling
13(13)
Exercises
26(4)
The relational model
30(23)
Fundamental concepts
30(6)
Normalized relations
36(4)
Integrity constraints
40(4)
Representation of EAR models by relations
44(8)
Exercises
52(1)
Relational algebra
53(34)
Processes and their abstractions
53(3)
Primitive retrieval operations
56(15)
Queries as compound algebraic expressions
71(4)
Optimization of algebraic expressions
75(10)
Exercises
85(2)
LEAP - the algebraic DBMS
87(14)
Introduction
87(1)
Leap architecture
88(9)
A sample run of LEAP
97(3)
Exercises
100(1)
Normalization
101(20)
Designing relations
101(2)
Functional dependency. BCNF normalization
103(17)
Exercises
120(1)
Further normalization
121(23)
Multivalued dependency. Fourth normal form
121(4)
Join dependency. Fifth normal form
125(6)
Axioms of dependency theory
131(5)
Transitive dependencies. Third normal form
136(7)
Exercises
143(1)
Structured Query Language
144(32)
Introduction
144(1)
Defining database objects
145(10)
Querying the database
155(13)
Modifying the data
168(7)
Exercises
175(1)
Object databases
176(18)
Rationale
176(3)
The object-oriented paradigm
179(1)
Modelling complex objects for databases
180(5)
Data definition and manipulation
185(4)
Object-relational databases
189(5)
SQL extensions
194(11)
Introduction
194(1)
Basic programming structures
195(8)
Procedures, functions and triggers
203(2)
Case study - implementation
205(28)
Introduction
205(2)
Software installation
207(1)
Implementation
208(23)
Exercises
231(2)
Appendix A: Solutions to exercises 233(10)
Appendix B: Denotations, logic, sets 243(4)
Denotations
243(1)
Algebra of propositions
244(1)
Set operations
245(2)
Bibliography 247(4)
Index 251
Stefan Stanczyk, Bob Champion and Richard Leyton