Scribd
Upload
1 views45 pages

Dbms Notes

The document outlines a comprehensive curriculum on Database Systems, covering topics such as the distinction between data and information, the evolution of data models, and the relational database model. It discusses key concepts including normalization, integrity rules, and various data manipulation commands. Additionally, it introduces practical tools like ER diagrams and functions for handling different data types.

Uploaded by

subhulakshmi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1 views45 pages

Dbms Notes

The document outlines a comprehensive curriculum on Database Systems, covering topics such as the distinction between data and information, the evolution of data models, and the relational database model. It discusses key concepts including normalization, integrity rules, and various data manipulation commands. Additionally, it introduces practical tools like ER diagrams and functions for handling different data types.

Uploaded by

subhulakshmi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

UNIT 1

Database Systems

Data vs Information
Introducing the database
File System

Problems with file system


Data models - Importance
Basic Building Blocks
Business rules
Evolution of Data models
Degrees of Data Abstraction.
UNIT 2

Relational database model


Logical view of data
keys

Integrity rules
Relational set operators
Data dictionary and the system catalog
Data redundancy revisited

indexes
codd's rules.
Entity relationship model
ER diagram.
UNIT 3

Database tables and Normalization


The Need for Normalization
The Normalization Process
Higher level Normal Form.
Data Definition Commands
Data Manipulation Commands
Data Definition Commands
Joining Database Tables
Sub Queries and Correlated Queries:
Date & Time Functions
Numeric Function
String Function
Conversion Function.

You might also like