IRIS EDUCATION

D. Answer the following questions 1. What is database? A database is an organised way of storing information. It helps us to manage and access large amount of information quickly and efficiently. 2. What do you understand by term RDBMS? A DBMS that stores data in the form of tables and enables you to join the tables by creating a link between them is called Relational Database Management System (RDBMS). 3. Explain any two advantages of database. The advantages of database are given below: (i) Facilitates sharing of data – Different users can use the same database to extract data based on their individual needs. (ii) Ensures data security – In a DBMS the database administrator has complete control over the database and ensures that the data is accessible only to authorized people. 4. Define the term ‘tables’. Tables are the building blocks of a database. They store the complete data in a structured manner in the forms of rows and columns. 5. What do you mean by the t...

Query A query is a method of getting answers to questions about the data. The query can involve a single table or multiple tables to answer a question about the data. Some of the examples are: The list of students who got greater than 80 percentage. The list of students who have submitted the March month fee. You can create queries in two ways: Query Wizard and Query Design Steps to create query using Query Wizard Click on Create Tab Click on Query Wizard option in the Queries group. A New Query dialog box appears. Select Simple Query Wizard and click on the OK button. The Simple Query Wizard screen appears. Select the table that contains your data in the Tables/ Queries box. Now add the fields you want in the query results. Make use of arrows to add or remove the fields. Then click on Next button. Now select Detail or Summary option from the dialog box. Click Next. Type a query name in the text box, and select Open the query to view information optio...