Scribd
Upload
5 views3 pages

Chapter8 DBMS Notes

Chapter 8 introduces Database Management Systems (DBMS), which are software used to efficiently store, manage, and organize data, allowing secure access for multiple users. It covers key concepts such as data, information, databases, and various types of keys, including primary, foreign, and composite keys, as well as different database models and objects. The advantages of using a DBMS include reduced data redundancy, improved data integrity, and simplified data sharing and retrieval.

Uploaded by

not550129
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
5 views3 pages

Chapter8 DBMS Notes

Chapter 8 introduces Database Management Systems (DBMS), which are software used to efficiently store, manage, and organize data, allowing secure access for multiple users. It covers key concepts such as data, information, databases, and various types of keys, including primary, foreign, and composite keys, as well as different database models and objects. The advantages of using a DBMS include reduced data redundancy, improved data integrity, and simplified data sharing and retrieval.

Uploaded by

not550129
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

Chapter 8 – Introduction to Database Management System (DBMS)

A Database Management System (DBMS) is software used to store, manage, and organize
data efficiently. It allows multiple users to access, retrieve, and update data securely.

---
📘 Key Concepts

1. **Data** – Collection of raw facts and figures.


2. **Information** – Processed data that has meaning.
3. **Database** – Organized collection of related data stored electronically.
4. **DBMS** – Software that manages and manipulates data in databases.

---
📋 Components of a Database

1. **Table:** Collection of rows (records) and columns (fields).


2. **Field (Attribute):** Column representing one type of data.
3. **Record (Tuple):** Row representing one entity’s data.
4. **Data Value:** Actual content stored in a field.

---
🔑 Keys in DBMS

1. **Primary Key:** Field that uniquely identifies each record (e.g., Roll_No).
2. **Candidate Key:** All fields that can uniquely identify a record.
3. **Alternate Key:** Candidate keys not chosen as Primary Key.
4. **Foreign Key:** Field linking two tables (refers to Primary Key of another table).
5. **Composite Key:** Combination of two or more fields uniquely identifying a record.
6. **Super Key:** One or more attributes that can uniquely identify a record.

---
📚 Database Models

1. **Hierarchical Model** – Tree structure.


2. **Network Model** – Multiple linked records.
3. **Relational Model** – Data stored in tables (used in RDBMS).

---
🧱 Database Objects
1. **Table** – Store data.
2. **Form** – For easy data entry.
3. **Query** – Retrieve specific data.
4. **Report** – Present formatted data.

---
✅ Advantages of DBMS

- Reduces data redundancy.


- Maintains data integrity and security.
- Enables data sharing and multi-user access.
- Simplifies data update and retrieval.

---
🧩 Summary Table

Term Meaning
Data ------- Raw facts

Information ------- Processed data


Database -------Organized data
DBMS ------- Software to manage data
Record ------- Row of data
Field ------- Column/attribute
Primary Key ------- Uniquely identifies a record
Foreign Key ------- Connects tables
Query ------- Data retrieval
Report ------- Data presentation

Detailed Explanation of Keys in DBMS

Keys are special fields used to identify, relate, or ensure uniqueness of data in a database.

11️⃣**Primary Key**
- Uniquely identifies each record.
- Cannot be NULL or duplicate.
- Example: Roll_No in Student table.

2️⃣**Candidate Key**
- All fields that can uniquely identify records.
- Example: Emp_ID, Aadhar_No, Phone_No in Employee table.
3️⃣**Alternate Key**
- Candidate key not chosen as primary key.
- Example: Aadhar_No (if Emp_ID is primary).

4️⃣**Foreign Key**
- Refers to primary key of another table to establish relationship.
- Example: Roll_No in Marks table refers to Roll_No in Student table.

5️⃣**Composite Key**
- Combination of multiple fields used to uniquely identify a record.
- Example: (Student_ID + Subject).

6️⃣**Super Key**
- One or more attributes that uniquely identify a record.
- Includes all types of keys.

You might also like