Scribd
Upload
4 views2 pages

Class 10 RDBMS Summary Notes

A database is an organized electronic collection of data managed by a Database Management System (DBMS) like MySQL or Oracle. DBMS offers advantages such as organized storage, reduced redundancy, and improved data security. The Relational Database Model, proposed by E. F. Codd, stores data in tables linked by common fields, utilizing keys like primary and foreign keys to manage relationships.

Uploaded by

akhtaraliya147
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
4 views2 pages

Class 10 RDBMS Summary Notes

A database is an organized electronic collection of data managed by a Database Management System (DBMS) like MySQL or Oracle. DBMS offers advantages such as organized storage, reduced redundancy, and improved data security. The Relational Database Model, proposed by E. F. Codd, stores data in tables linked by common fields, utilizing keys like primary and foreign keys to manage relationships.

Uploaded by

akhtaraliya147
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

Class 10 - RDBMS (Relational Database

Management System) Summary Notes

1. What is a Database?

• A database is an organized electronic collection of data.

• A DBMS (Database Management System) is software used to store, manage, and retrieve
data.

• Examples: LibreOffice Base, MS Access, Oracle, MySQL.

2. Advantages of DBMS

• Organized storage of data.

• Reduces data redundancy.

• Improves data consistency and accuracy.

• Allows data sharing.

• Provides data security.

3. Data Models

• Hierarchical Data Model – Tree-like structure.

• Network Data Model – Records connected in many-to-many relationships.

• Relational Data Model – Data stored in tables connected by common fields.

4. Relational Database Model

• Proposed by E. F. Codd in 1970.

• Data is stored in tables (rows and columns).

• Tables are linked using common fields.

5. Key RDBMS Terminology


• Entity – Real-world object (e.g., Student).

• Table – Collection of records.

• Field (Column) – Specific type of data.

• Record (Row) – Set of related data fields.

• Data Values – Individual pieces of information.

6. Keys in RDBMS

• Primary Key – Uniquely identifies each record.

• Foreign Key – Links one table to another.

• Candidate Key – Field that can become primary key.

• Alternate Key – Candidate key not selected as primary key.

7. Objects in RDBMS

• Table – Stores data.

• Form – Used to enter data.

• Query – Retrieves specific data.

• Report – Displays formatted output.

You might also like