Scribd
Upload
6 views4 pages

Dbms Notes

The document provides an overview of Database Management Systems (DBMS), defining key concepts such as data, information, and the structure of databases. It discusses the advantages of DBMS over traditional file systems, including data integrity and efficient access, and outlines various data models and database languages. Additionally, it covers the Entity-Relationship model, including entities, attributes, relationships, and the conversion of ER diagrams to tables.

Uploaded by

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

Dbms Notes

The document provides an overview of Database Management Systems (DBMS), defining key concepts such as data, information, and the structure of databases. It discusses the advantages of DBMS over traditional file systems, including data integrity and efficient access, and outlines various data models and database languages. Additionally, it covers the Entity-Relationship model, including entities, attributes, relationships, and the conversion of ER diagrams to tables.

Uploaded by

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

Database Management Systems (DBMS)

Notes

UNIT I: INTRODUCTION TO DBMS

1. What is DBMS?

- Data: Raw facts and figures

- Information: Processed data

- Database: Collection of related data

- DBMS: Software to create and manage databases

2. Why Study Databases?

- Used in banking, airlines, universities, sales, etc.

- Handles large structured and unstructured data

3. File System vs DBMS

Problems with file systems:

- Data redundancy

- Data inconsistency

- Difficulty accessing data

- Security issues

Advantages of DBMS:

- Data independence

- Efficient data access


- Data integrity and security

- Concurrent access and recovery

4. Levels of Abstraction

- Physical level

- Logical level

- View level

5. Schemas and Instances

- Schema: Structure of database

- Instance: Actual data at a given time

6. Data Models

- Entity-Relationship Model

- Relational Model

- Object-Oriented Model

7. Database Languages

- DDL: Define database structure

- DML: Manipulate data

- DCL: Control access

- TCL: Manage transactions

8. DBMS Architecture

- Query Processor

- Storage Manager
--------------------------------------------------

UNIT II: ENTITY RELATIONSHIP MODEL

1. Entities and Attributes

- Entity: Real-world object

- Attribute: Property of entity

- Types: Simple, composite, multivalued, derived

2. Relationships

- Binary, Ternary, N-ary

- Cardinalities: 1:1, 1:N, M:N

3. Keys

- Super key

- Candidate key

- Primary key

4. ER Diagrams

- Rectangles: Entities

- Diamonds: Relationships

- Ellipses: Attributes

5. Advanced Concepts

- Weak entities
- Specialization & Generalization

- Aggregation

6. ER to Tables Conversion

- Entities → Tables

- Relationships → Tables

You might also like