An Introduction to Relational Database Theory 4th Edition by Mari Dumitru ISBN 978-1430215738 1430215738
Original price was: $50.00.$35.00Current price is: $35.00.
An Introduction to Relational Database Theory 4th Edition by Mari Dumitru – Ebook PDF Instant Download/Delivery: 978-1430215738, 1430215738
Full download An Introduction to Relational Database Theory 4th Edition after payment
Product details:
ISBN 10: 1430215738
ISBN 13: 978-1430215738
Author: Mari Dumitru
An Introduction to Relational Database Theory (4th Edition) by Hugh Darwen is a textbook that explains the formal foundations of the relational model of data, independent of SQL or commercial systems. It covers core concepts such as relations, tuples, attributes, keys, functional dependencies, normalization, and relational algebra, with an emphasis on theory, logical rigor, and how the model should be applied in practice.
Table of contents:
1 Introduction
1.1 Introduction
1.2 What Is a Database?
1.3 “Organized Collection of Symbols”
1.4 “To Be Interpreted as a True Account”
1.5 “Collection of Variables”
1.6 What Is a Relational Database?
1.7 “Relation” Not Equal to “Table”
1.8 Anatomy of a Relation
1.9 What Is a DBMS?
1.10 What Is a Database Language?
1.11 What Does a DBMS Do?
1.12 Creating and Destroying Variables
1.13 Taking Note of Integrity Rules
1.14 – Taking Note of Authorisations
1.15 – Updating Variables
1.16 – Providing Results of Queries
Exercise
2 – Values, Types, Variables, Operators
2.1 – Introduction
2.2 – Anatomy of a Command
2.3 – Important Distinctions
2.4 – A Closer Look at a Read-Only Operator (+)
2.5 – Read-Only Operators in Tutorial D
2.6 – What Is a Type?
2.7 – What Is a Type Used For?
2.8 – The Type of a Relation
2.9 – Relation Literals
2.10 – Types and Representations
2.11 – What Is a Variable?
2.12 – Updating a Variable
2.13 – Conclusion
Exercises
3 – Predicates and Propositions
3.1 – Introduction
3.2 – What Is a Predicate?
3.3 – Substitution and Instantiation
3.4 – How a Relation Represents an Extension
3.5 – Deriving Predicates from Predicates
Exercises
4 – Relational Algebra – The Foundation
4.1 – Introduction
4.2 – Relations and Predicates
4.3 – Relational Operators and Logical Operators
4.4 – JOIN and AND
4.5 – RENAME
4.6 – Projection and Existential Quantification
4.7 – Restriction and AND
4.8 – Extension and AND
4.9 – UNION and OR
4.10 – Semidifference and NOT
4.11 – Concluding Remarks
Exercises
5 – Building on the Foundation
5.1 – Introduction
5.2 – Semijoin and Composition
5.3 – Aggregate Operators
5.4 – Relations within a Relation
5.5 – Using Aggregate Operators with Nested Relations
5.6 – SUMMARIZE
5.7 – GROUP and UNGROUP
5.8 – WRAP and UNWRAP
5.9 – Relation Comparison
5.10 – Other Operators on Relations and Tuples
Exercises
6 – Constraints and Updating
6.1 – Introduction
6.2 – A Closer Look at Constraints and Consistency
6.3 – Expressing Constraint Conditions
6.4 – Useful Shorthands for Expressing Constraints
6.5 – Updating Relvars
7 – Database Design I: Projection-Join Normalization
7.1 – Introduction
7.2 – Avoiding Redundancy
7.3 – Join Dependencies
7.4 – Fifth Normal Form
7.5 – Functional Dependencies
7.6 – Keys
7.7 – The Role of FDs and Keys in Optimization
7.8 – Boyce-Codd Normal Form (BCNF)
7.9 – JDs Not Arising from FDs
Exercises
8 – Database Design II: Other Issues
8.1 – Group-Ungroup and Wrap-Unwrap Normalization
8.2 – Restriction-Union Normalization
8.3 – Surrogate Keys
8.4 – Representing “Entity Subtypes”
People also search for:
introduction to relational databases sophia answers
introduction to relational databases milestone 2
introduction to relational database and sql coursera
introduction to relational database and sql coursera quiz answers
introduction to relational databases and sql programming