preview

Relational Database Management System

Good Essays
Open Document

Relational Database Management System is a database where data is represented as a set of relations in which data is stored. RDBSM is the basic for SQL. RDBSM contains a table (Is where the data of RDBMS is stored in) and the table contains a field (It is the smaller pieces of the table/ attributes of the table.), records (Also known as a row. It is a single entry in the table. It lies horizontally on the table) and columns (Columns lie vertical on the table. It contains all of the information related to a single field/ attribute). Constraints (Rules) can be enforced on a RDBSM. Example: Unique constraint (To ensure that all the data in a column is of different values), Not Null constraints (Set in place to ensure that a columns cannot have a null value), Primary key (Ensures uniquely identified records in a table), Foreign key (Ensures that …show more content…

• Enables network access: this gives the user the advantage by connecting to the database via as server daemon (A piece of software that executes background tasks, like filtering in this instance). It provides the advantage to be connected to the database without logging in through a physical computer. Because you need to connect to a network, it provides additional security for the network.
• Multiple user access: this ensures that multiple users can connect to the database simultaneously. Transaction management enables the users to manipulate/ update/ alter the data all at the same time without causing the database to crash.
• Maintenance: RDBMS contains maintenance facilities that give the database administrator the means to fix, backup and maintain the database.
• Enables the user to use SQL (Structured Query language): SQL’s format is easy to learn and to use. It uses simple English terms to submit

Get Access
Related
Get Access