Skip to main content
Return to home
Publisher Logo: Click to return to the browse pagePublisher Logo: Click to return to the browse page
  • Home
  • Projects
Projects

Guide to Database Systems

by Clément Aubert

Developed for use in Database Systems courses as a result of a Round 13 Affordable Learning Georgia Mini-Grant, this document contains:

  • A large collection of exercises, exams, problems, as well as selected solutions,
  • A ""hands-on"" guide to install, configure and run various database management systems (MariaDB, MySQL, mongodb)
  • A compact guide to the most fundamental definitions and notions of the topic at stake, Organized and up-to-date references."

Start Reading
Original PublicationDownload HTML
Start Reading
Original PublicationDownload HTMLGrant Docs
Project Hero Cover
Grant Docs

Table of Contents

  • Preamble
    • Preamble
    • How to Use This Guide
    • Planned Schedule
    • Exams Yearbooks
    • Typesetting and Acknowledgements
    • Resources
    • Copyright
  • Introduction
    • Introduction
    • Resources
    • The Need for a Specialized Tool
    • Database
    • Database Management System (DMBS)
    • Subtasks
    • Life of a Project
    • An Example
    • Characteristics of the Database Approach
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Problems
  • The Relational Model
    • The Relational Model
    • Resources
    • Concepts
    • Domains, Attributes, Tuples and Relations
    • Constraints
    • Keys
    • Foreign Keys
    • Example
    • Transactions and Operations
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Selected Problems
  • The SQL Programming Language
    • The SQL Programming Language
    • Resources
    • Actors
    • First Commands
    • Useful Commands
    • Overview of Constraints
    • Foreign Keys
    • A First Look at Conditions
    • Three-Valued Logic
    • Various Tools
    • More Select Queries
    • More Procedures
    • More Triggers
    • Setting Up Your Work Environment
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Selected Problems
  • Designing a Good Database
    • Designing a Good Database
    • Resources
    • Interest for High-Level Design
    • Interest for High-Level Design
    • ER to Relational Models Mapping
    • Guidelines and Normal Form
    • Unified Modeling Diagrams
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Selected Problems
  • Database Applications
    • Database Applications
    • Resources
    • Overview
    • Java's Way
    • Flash Intro to Java
    • A First Program
    • Mapping Data Types
    • Differences Between executeQuery, executeUpdate, and execute
    • A Second Program
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Selected Problems
  • A Bit About Security
    • A Bit About Security
    • Usual Aspects
    • SQL Injections
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Selected Problems
  • Presentation of NoSQL
    • Presentation of NoSQL
    • Resources
    • A Bit of History
    • Comparison
    • Categories of NoSQL Systems
    • MongoDB
    • Principles
    • Exercises
    • Solutions to Exercises
    • Problems
    • Solutions to Selected Problems
  • References

Metadata

  • rights
    Creative Commons License
    This work is licensed under a Creative Commons Attribution 4.0 International License.
  • original publisher
    Augusta University
  • original publisher place
    Augusta, GA
  • publisher
    University System of Georgia
  • publisher place
    Athens, GA
Press Site
    • Log In
    • Projects
    • Home
    • Email
    • Twitter
    • Log In
    • Projects
    • Home
    • Email
    • Twitter
Powered by Manifold