Database management system pdf notes class 10

4 Data can be organized into two types: Flat File: Data is stored in a single table.
Usually suitable for less amount of data.
Relational: Data is stored in multiple tables and the tables are linked using a common field.
How will you design a database class 10?
The design process consists of the following steps:
1. Determine the purpose of your database
2. Find and organize the information required
3. Divide the information into tables
4. Turn information items into columns
5. Specify primary keys
6. Set up the table relationships
7. Refine your design
8. Apply the normalization rules

What is database management system & DBMS?

These database programs are used to organize the data as per our needs in the computer system

Database Management System (DBMS) – A database management system is a software package with computer programs that controls the creation, maintenance and use of a database

Categories

Database management system pdf notes class 10

How will you design a database class 10?

The design process consists of the following steps:

What is database management system & DBMS?