Introduction to database management systems
Chapters
What is data schema?
A database schema in a database system is structure described in a formal language which is supported by database management system (DBMS) and refers to organization of data as a blueprint of how a database is constructed (divided into database tables in case of Relational Databases). The formal definition of database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of schema. It Includes descriptions of database structure, data types and constraints of database.
A database schema divided broadly into two categories:
- Physical Database Schema: The schema pertains to actual storage of data and its form of storage like files, indices etc. It defines how data will be stored in a secondary storage.
- Logical Database Schema: The schema defines all logical constraints that need to be applied on stored data. It defines views, tables and integrity constraints.
Description
This free tutorial covers the basics of database management system to help you with your understanding on the topic, Please note that this tutorial assumes that either you are a beginner or just want to brush up your understanding on DBMS
Tutorial covers the topics below
- What is DBMS?
- Architecture
- Data Models
- Data Schemas
- Data Independence
- Entity-Relation Model Basic Concept
- Entity-Relation Diagram Representation
- Generalization, Aggregation
- Codd's 12 Rules
- Relational Data Model
- Relational Algebra
- Structured Query Language
- Normalization
- Database Joins
- Storage System
- Indexing
- Hashing
- Transaction
- Concurrency Control and Deadlock
- Data Backup and Recovery
Audience
Absolute beginners or students who wish to brush up their understanding on DBMSes
Author: Subject Coach
Added on: 16th Sep 2015
You must be logged in as Student to ask a Question.
None just yet!