Objects of RDBMS


☞ In a relational model, the entire processing is based on a centralized database which constitutes the following objects :

1. Table
2. Form
3. Query
4. Report

Table

☞ It is the basic and most extensively used component of a database.

☞ The data is organized in the form of rows (records/tuples) and columns (attributes/fields) in a table.

☞ It acts as a container that holds data related to a specific topic, purpose or object.


Form

☞ It allows you to enter data.

☞ It a window or screen that contains numerous fields or spaces to enter data, edit and display it from a table or query.

☞ Each field holds a field label.


Query

☞ It is defined as a request made to a database for retrieving required information.

☞ The outcome of the database query is the filtered information that matches the criteria/condition to find exactly the data you want.


Report

☞ It is a formal and formatted representation of data obtained as a result of database queries.

☞ It contains useful data for decision-making and analysis.

☞ It displays the data in summarized manner.