Answer: – RDBMS is a software package used to store and retrieve data that is organized in the form of tables in words RDBMS stores information in rows and columns and conduct searches by using data in specified column and rows of one table as well as to find additional data to another table.
Two-dimensional table is a natural way to represent data to a user. A table must be set up in a way that no information about the relations among data elements is lost.
A table should contain the following properties –
- Each entry in a table should only represent one data item and no two-column heading with the same name.
- In each column, the data items are of the same data type.
- Each column is assigned with a distinct heading.
- All rows are distinct, duplicate rows are not allowed.
- Both the rows and columns can be viewed in any sequence at any time without affecting the information.
A RDBMS has the following properties –
- Stores data from a table.
- Does not require the user to understand its physical implementation.
- Properties information about its content and structure in the system table.
- Support the concept of NULL values.
Any organization, be it a bank, manufacturing company, hospital, university, or a governments department require huge amount of data in some form or other. All such organization need to collect data, manipulate them and store them for future use. All such types of organization require data for a number of purposes –
- Preparing sales report
- For casting sales
- Preparing accounts report.
- Getting medical histories of patients.
Thus, we can say that data are very vital corporate resources. The amount of data used these days in organization can be measured in the range of son billions of bytes or characters. The financial investment involved is also very high. Many organizations have become critically dependent on the continued and successful operations of databases.
Various types of relational database management system arc hierarchical database management system, network database management system, relational data base management system, object oriented database management system and distributed database management system.