FREE DOWNLOAD OPEN BOOKS

Database Design

Database Design

by Adrienne Watt


DOWNLOAD EBOOK READ ONLINE SHARE BOOK QR CODE

Book Description

Database Design, 2nd Edition covers database systems and database design concepts. New to this edition are SQL info, additional examples, key terms and review exercises at the end of each chapter.

Topics include:The history of databases; Characteristics and benefits of databases; Data models; Data modelling; Classification of database management systems; Integrity rules and constraints; Functional dependencies; Normalization; Database development process.

This open book is licensed under a Creative Commons License (CC BY). You can download Database Design ebook for free in PDF format (2.8 MB).

Report an issue

Table of Contents

Chapter 1
Before the Advent of Database Systems
Chapter 2
Fundamental Concepts
Chapter 3
Characteristics and Benefits of a Database
Chapter 4
Types of Data Models
Chapter 5
Data Modelling
Chapter 6
Classification of Database Management Systems
Chapter 7
The Relational Data Model
Chapter 8
The Entity Relationship Data Model
Chapter 9
Integrity Rules and Constraints
Chapter 10
ER Modelling
Chapter 11
Functional Dependencies
Chapter 12
Normalization
Chapter 13
Database Development Process
Chapter 14
Database Users
Chapter 15
SQL Structured Query Language
Chapter 16
SQL Data Manipulation Language
Appendix A
University Registration Data Model Example
Appendix B
Sample ERD Exercises
Appendix C
SQL Lab with Solution

Book Details

Subject
Computer Science
Publisher
BCcampus
Published
2014
Pages
153
Edition
2
Language
English
PDF Size
2.8 MB
License
CC BY

Related Books

SQL Server Metadata Succinctly
SQL Server Metadata Succinctly

by Joseph D. Booth

SQL Server is a very complex and powerful product, but it provides tremendous amounts of data about itself. You can use this metadata to improve your database design, increase performance, review security, and more. Joseph D. Booth will show readers sample scripts and queries using information schema views as well as SQL Server-specific views in SQ...

Designing Sustainable Energy for All
Designing Sustainable Energy for All

by Carlo Vezzoli, Fabrizio Ceschin, Lilac Osanjo, Mugendi M’Rithaa, Richie Moalosi, Venny Nakazibwe, Jan Carel Diehl

This book addresses the issue of diffusing sustainable energy access inlow- and middle-income contexts. Access to energy is one of the greatest challenges for many people living in low-income and developing contexts, as around 1.4 billion people lack access to electricity.Distributed Renewable Energy systems (DRE) are considered a promising approa...

Digital Transformation of the Design, Construction and Management Processes of the Built Environment
Digital Transformation of the Design, Construction and Management Processes of the Built Environment

by Bruno Daniotti, Marco Gianinetto, Stefano Della Torre

This open access book focuses on the development of methods, interoperable and integrated ICT tools, and survey techniques for optimal management of the building process. The construction sector is facing an increasing demand for major innovations in terms of digital dematerialization and technologies such as the Internet of Things, big data, advan...

Data-Driven Policy Impact Evaluation
Data-Driven Policy Impact Evaluation

by Nuno Crato, Paolo Paruolo

In the light of better and more detailed administrative databases, this book provides statistical tools for evaluating the effects of public policies advocated by governments and public institutions. Experts from academia, national statistics offices and various research centers present modern econometric methods for an efficient data-driven policy...

Graph Databases
Graph Databases

by Ian Robinson, Jim Webber, Emil Eifrem

Discover how graph databases can help you manage and query highly connected data. With this practical book, you'll learn how to design and implement a graph database that brings the power of graphs to bear on a broad range of problem domains. Whether you want to speed up your response to user queries or build a database that can adapt as your busin...