What is meant by RDBMS? Which facilities are provided by RDBMS? RDBMS stands for relational database management system. It is a collection of programs which are used to create and maintain relational databases. A database in which data is stored in relations is called relational database. Relation is another term used for table. A table in a database has a unique name that identifies its contents.
The RDBMS software translates the user’s requests into commands. These commands locate and retrieve requested data. An important component of RDBMS is data dictionary. The data dictionary stores information about data. It stores the description of the structure of the relation in the database. It also stores the description of data relationships and the integrity constrains on data.
Facilities Provided by RDBMS
A good RDBMS provides the following facilities:
- Data security
- Data integrity
- Easy access
- Backup and recovery etc.
How is MS Access started or loaded?
The following procedure can be used to start MS Access:
- Click start button on Taskbar and select programs menu item. The programs submenu will be displayed.
- Click Microsoft Access program item. MS Access will be started. OR
- Double click on Microsoft Access icon on Desktop if it appears.
What is database wizard? Write the procedure to create database using database wizard.
A database wizard is a set of steps that guides the user to create a database easily. The following procedure is used to create database using database wizard:
- Start Microsoft Access. It will display a dialog box with three option:
- Select Access database wizards, pages and projects option and click OK. A dialog box will appear.
- Select the database type in Databases tab.
- Click OK. The Files New Database will appear.
- Type the name and location for the database.
- Click Create. The database will be created and Database wizard will appear.