BalbharatiMaharashtra State Board Class 11 Information Technology SolutionsChapter 2 Introduction to DBMS Textbook Exercise Questions and Answers.
Maharashtra State Board Class 11 Information Technology Solutions Chapter 2 Introduction to DBMS
1. Complete the following activity.
2. Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.
Column A (Field Name) | Column B (DataType) |
Passenger Name | Varchar |
Age | Int |
Gender | Char |
Mobile Number | Int |
3. Write the use of the following SQL command.
4. Create a table for the information given below by choosing appropriate data types. Specify proper primary key for the table (1) Movie (2) Actor
5. Consider the following table Stationary. Write SQL commands for the following statements.
Table: Stationary
6. Answer the following questions.
Various types of control systems within the DBMS make sure that the database continues to function properly. They Include Integrity system Security system Concurrency control system Recovery control system Some DBMS enables us to define “views” of the database. A view is how the database appears to the user. This enables us to show only the relevant information to different types of users and it increases security, as certain users will not be able to see data which they are not meant to see.
2. Sharing of Data: In a database, the users of the database can share the data among themselves. There are various levels of authorization to access the data. And consequently, the data can only be shared based on the correct authorization protocols being followed.
3. Data Security: Data Security is a vital concept in a database. Only authorized users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorized users should not be allowed to access the database under any circumstances as it violates the integrity constraints.
4. Enforces integrity constraints: Constraints are used to store accurate data because there are many users who feed data in the database. Data stored in the database should always be correct and accurate. DBMS provides the capability to enforce these constraints on the database.
5. Provides backup and recovery of data: Data loss is a very big problem for all organizations. In a traditional tile processing system, a user needs to back up the database after a regular interval of time that wastes lots of time and resources. If the volume of data is large then this process may take a very long time.
Relational Model:
It is the most popular data model in DBMS. The relational model is the primary data model. Which is widely used for data processing. This model has all properties required to Process data with storage efficiency.
7. In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field?
Field Name | Data Type |
Employee Name | Char |
Last Name | Char |
Address | Varchar |
Date of Birth | Date |
8. Multiple choice select three correct answers.
9. Complete the following.
Use | Command |
To remove access rights or privileges from the database | Revoke |
Extracts data from a table | Insert into Select |