RDBMS Stands for "Relational Database Management System." An RDBMS is a DBMS designed specifically for relational databases.
A relational database refers to a database that stores data in a structured format, using rows and columns. This makes it easy to locate and access specific values within the database.
A relational database has following major components (terms):-
1. Relation or Table
2. Record or Tuple
3. Field or Column name or Attribute
4. Domain
5. Keys
1. Relation (Table):- All data and relationships are represented in a two dimensional table called a relation. A relation consists of number of records or row-wise information and column-wise information. For example, the following table “STUDENT” stores the information of students in database.
2. Record or Tuple:- Each row of a table is known as record. It is also known as tuple.
3.Field or Column name or Attribute:- An attribute is a named column of a relation. A relation is represented as a two-dimensional table in which the rows of the table correspond to individual records and the table columns correspond to attributes.
4.Domain: A domain is the set of allowed values for one or more attributes. A domain defines the kind of data represented by an attribute.
5. Key :- Key plays an important role in relational database; it is used for identifying unique rows from table. It also establishes relationship among tables.
0 Comments:
Post a Comment