Basics of Database Part 01
What is Database?
A database is a collection of information organized for easy access, management, and maintenance.
Exp: Customer data
Product Inventory etc.
Types of Data Models
- Record-based logical model
- Hierarchical Data Model
- Network Data Model
- Relational Data Model
- Object-based logical model
- Entity relationship model
DBMS Operations
- Adding new files
- Inserting data
- Retrieving data
- Modifying data
- Removing data
- Removing files
Advantages of DBMS
- Sharing of data across applications
- Enhanced security mechanism
- Enforce integrity constraints
- Better transaction support
- Backup and recovery features
Introduction to RDBMS
- A relational database refers to a database that stores data in a structured format, using rows and columns.
- This makes it easier to locate and access specific values within the database.
- It is "relational" because the values within each table are related to each other. tables may also be related to other tables.
- The Relational structure makes it possible to run queries across multiple tables at once.
Features of RDBMS
- Every piece of information is stored in the form of tables.
- Has primary key for unique identification of rows.
- Has foreign keys to ensure data integrity.
- Provide SQL for data access.
- Uses indexes for faster data retrieval.
- Gives access privileges to ensure data security.
#data #database #management #security #maintenance #day1 #basics #datasecurity
mail id: arpitmishra1629.ftp@gmail.com
Contact no: 8127430702
Informative.
ReplyDelete