Database Design
by Adrienne Watt
DescriptionTable of ContentsDetailsHashtagsReport an issue
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. 
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).
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
Title
Database Design
Subject
Computer Science
Publisher
BCcampus
Published
2014
Pages
153
Edition
2
Language
English
PDF Size
2.8 MB
License
Related Books
The way a user might perceive and use data and the optimal way a computer system might store it are often very different. In this Database Design Succinctly, learn how to model the user's information into data in a computer database system in such a way as to allow the system to produce useful results for the end user. Joseph D. Booth will cov...
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...
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
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...
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...
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 ...