What is Database? Write the names of different types of Database.
Database is a software which is used to store data in an organized way in form of tables.
 |
| Types of Database |
There are two
types of Database:
1) Flat File
Database
2) Database
Management System
--------------------------------------------------
Other Topic of this Chapter
- Database
- Primary key / Foreign Key
- Create Database in Open Office Base
- Create Table in Open Office Base
- Update Table in Open Office Base
- Create Query in Open Office Base
- Creating Form in Open Office Base
- Report in Open Office Base
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
-------------------------------------------------
What is FFD (Flat File Database)?
Software that is
used for creating documents and it can be used to store Data in a table. For
example MS Word can be used to store one class Data like students name, Age, DOB,
Address, Father Name, and Mother Name etc. For example MS Word, MS Excel
 |
| Flat File Database |
Features of FFD
1) FFD is good for
small record like one class data in a school.
2) FFD is not
primarily designed to store Data so management of record is quite difficult on
it.
3) It is difficult to manage large data in a table.
4) It is not secure, so anyone can manipulate it.
Sample Paper of Class 10
- English Sample Paper 2022 - 23
- Hindi A Sample Paper 2022 - 23
- Maths (Standard) Sample Paper 2022 - 23
- Maths (Basic) Sample Paper 2022 - 23
- Science Sample Paper 2022 - 23
- Social Science Sample Paper 2022 - 23
What is DBMS (Database Management System)?
DBMS is
software that is primarily designed to store large amount of Data in an
organized way. It helps to store, update, delete and retrieve data in an easy
manner, so websites, application software use DBMS to store large amount of
data. For example Open Office Base, SQL.
--------------------------------------------------
MCQs of Chapter - Database
Explain Advantages of DBMS (Database Management System).
1) Data Duplicity: In database particular information is stored centrally at one place, so duplicity of data is reduced.
2) Data Sharing: In a centralized database, data can be shared with different websites as well as with application software.
3) Better Security: Database is
more secure as the users are divided into different categories. Some of the
users may be given authority to read and use the data; other may be given
authority to update data.
4) Data Integrity: Take an example of a database that contains marks scored by students in an examination. The maximum marks are 100. The marks secured by a student can’t exceed 100. Integrity checks can be inbuilt into the database such that it will accept numbers only in the range of 0 to 100.
5) Backup and Recovery: Database provides backup and recovery feature. So in
case disk crashes, power failures, or software gives errors, the database can
be recovered to the previous state.
--------------------------------------------------
Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application
--------------------------------------------------
Explain Disadvantages of a DBMS (Database Management System).
1) Complexity: Database systems are
complex, difficult and time consuming to design.
2) Training: Initial training is required for all programmers and users.
 |
| Type of DBMS |
Explain different types of DBMS (Database Management System).
1) Distributed Database
In distributed Database, the data isn’t stored in single system, but it is distributed in multiple systems, so it provides more reliability, good speed, and easy of expansion.
2) Centralized Database
In Centralized Database data is stored at one system unlike distributed database where data is stored in multiple systems. Users can access data from multiple systems using network. This database is generally used by big organization or universities.
3) Cloud Database
Cloud database is quite popular these days, and it works online, so it’s easy to get data from anywhere. For this service users can setup their own network or can get paid services. Data security is the essential part of this service as data transfer online.
4) Relational Database Management System (RDBMS)
In Relational Database data is stored in structural way in a form of table logical setup a relationship among them. It helps to integrate your data and you don’t bother about its scalability.
For example
MS Access, Open office Base, MySQL
(Structured Query Language)
Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application
Sample Paper of Class 10 IT 402
- Sample Paper 2020 - 21
- Sample Paper 2021 - 22
- Sample Paper 2021 - 22
- Sample Paper 2022 - 23
- Sample Paper 2022 - 23
No comments:
Post a Comment