Class: 12 Subject: Computer Science Chapter: Relational Databases Topic: Database Assignment: 1
Class: 12 Subject: Computer Science Chapter: Relational Databases Topic: Database Assignment: 1
Class: 12 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.
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
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.