Class: 12 Subject: Computer Science Chapter: Relational Databases Topic: Database Assignment: 1

Download as pdf or txt
Download as pdf or txt
You are on page 1of 2

Class: 12th Subject: Computer Science

Chapter: Relational Databases Topic: Database


Assignment: 1

DATABASE : Database is a recordkeeping system Which holds interrelated data that can
be easily accessed, managed and updated.

RDBMS : A relational database management system (RDBMS) is a SOFTWARE that


allows you to create, update, and administer a relational database (Data is organized in
the form of table which contains rows and columns)

Some advantages of the relational database;

 Easy to categorize and store structured data for faster querying and filtering.
 Easy to scale and aren’t reliant on physical organization
 Mature and well-understood database model.
 High level of security
ADVANTAGES OF USING DBMS

 Reducing data redundancy – This ensures a consistent database and efficient


use of storage space.
 Aiding multiple views of the data: Database management system enables
different users to have a view of the data from their own perspective
 Implementation of data integrity The term data integrity refers to the
accuracy and consistency of data. When creating databases, attention needs to
be given to data integrity and how to maintain it.
 Data sharing and security – DBMS limits the accessibility of the data to the
authorized users only. This makes data sharing safer. Moreover shared data
makes it possible to fulfill data requirements with minimal modifications.
 Centralized data ensures a more effective backup and recovery process than
the conventional file processing systems.

 Program & Data independence: Programs and the data are not mutually
dependent. If a programmer wants to change the structure of the database then
he/she can do so without affecting the application programs that are using the
database.
 Data Abstraction: It ensures that the users get an abstract view of the data
without showing implementation details and the physical storage of the data.


1. What is the function of database management system?
Ans:Following are the function of To organize information - To store information - To retrieve
information As efficiently and effectively as possible.
2. What is data redundancy? What are the problems associated with it?
Ans:Data redundancy means duplication of data. It causes duplicate data at different locations which destroys
the integrity of the database and wastage of storage space.
3. How do database management system overcome the problems associated with data redundancy?
Ans: Database normalization prevents redundancy and makes the best possible usage of storage .Proper use of
foreign keys can minimize data redundancy and chance of destructive anomalies. However, concerns of efficiency
and convenience can sometimes result in redundant data design despite the risk of corrupting the data.
A solution to the problem is to place the redundant data in a separate table, one in which the data no longer
will be redundant.
4. How do database management system ensure data security and privacy ?
A database management system ensure data security and privacy by ensuring that only means of access to the
Database is through the proper channel and also by carrying out authorization checks whenever access to sensitive
data is attempted
5. Name the different data models available for database system. Which of them is the most preferred one ?
(ii) There are generally three data models available as following : (i)Relational Model Network Model
(iii) Hierarchical Model
Among these three level relational level is the most preferred one because it does not use pointers or
links. Instead, it relates records by the values they contain.

You might also like