Database is an organized collection of structured information or data. So that it can be easily accessed and managed.
Data is a piece of information about something, which can be processed to make a meaningful information.
For example: Data can be personal details of anyone in the form of text, picture, audio or video.
In the beginning. data was being stored in the files like spreadsheet etc. So we can say file system used as a database to store the data in organized way.
Relational database is a collection of data, organized in a predefined relationship where data is stored in one or more tables of columns & rows or relations, making it easy to access the data to find meaningful information and easy to understand how different data structure relate to each other.
Relationship/Relation is a logical interconnection between different tables, established based on interaction among these tables.
DBMS: A software used to facilitate the relational database and following the relational model to store the data, is called the database management system.
Relational Model : represent the database as a collection of relation, a relation is a table of values. Every row in the tables represent the collection of related data value. These row in table denotes a entity or relationship. The table name and column name help to interpret the meaning of value in each row. The data is represent as a set of relations.
In the relational model, data has been stored in the tables. Although, the physical Storage of data will be independent of the way the data are organized in logical way.
Popular RDBMS:
- Oracle
- MySQL
- Microsoft SQL server
- PostgreSQL
- SQLite
- etc.
Excellent job !!
ReplyDelete