Database Design
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.
Table of contents
- Before the Advent of Database Systems
- Fundamental Concepts
- Characteristics and Benefits of a Database
- Types of Data Models
- Data Modelling
- Classification of Database Management Systems
- The Relational Data Model
- The Entity Relationship Data Model
- Integrity Rules and Constraints
- ER Modelling
- Functional Dependencies
- Normalization
- Database Development Process
- Database Users
- SQL Structured Query Language
- SQL Data Manipulation Language
- University Registration Data Model Example
- Sample ERD Exercises
- SQL Lab with Solution
| Pages | 153 |
|---|---|
| Size | 2.8 MB |
| File type | |
| Downloads | 204 |
| Created | 2022-02-02 |
| License | CC BY |
| Author(s) | Adrienne Watt |
Others database tutorials
Others related eBooks about Database Design
-
Migrating SQL Server Databases to Azure
Download free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....
-
SQL Notes for Professionals
SQL is a standard language for storing, manipulating and retrieving data in relational databases....
-
Oracle database tutorials for professionals
Download free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
-
Getting started with Oracle 8
This pdf tutorial is about fundamental of relational database with Oracle , a free training document for Beginners....
-
Data Science with Microsoft SQL Server 2016
Download free course Data Science with Microsoft SQL Server 2016, pdf file on 90 pages by Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok....
-
Introduction to Access 2010
Start to learn Microsoft Access 2010 with this free PDF tutorial and more about new useful features insides including designing databases and queries,training document for download under 24 ....
-
Introducing Microsoft SQL Server 2016
Download free course Introducing Microsoft SQL Server 2016, pdf file on 215 pages by Stacia Varga, Denny Cherry, Joseph D'Antoni....
-
Oracle Advanced PL/SQL Developer Professional Guide
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta ....
-
Guide to NoSQL with Azure Cosmos DB
Download free course Guide to NoSQL with Azure Cosmos DB, pdf file on 205 pages by Gaston C. Hillar , Daron Yöndem....
-
PostgreSQL Administration
Learn how to administrate PostgreSQL,a free course training material in PDF By Bruce Momjian....