Page 60 - 2611_SmartGPT Pro V(5.0) C-8

DBMS vs RDBMS
Table Table

Table
xml Table Table
xml
xml Table
xml
xml
DBMS RDBMS

COMPONENTS OF RELATIONAL DATABASE

The key components of a relational database are as follows:

Student Table

Fields

Student_ First_ Last_ Date of Email Course_ID
ID Name Name Birth
1 Aarav Sharma 15-Mar-2012 aarav.sharma@gmail.com C101
Table 2 Priya Patel 20-May-2012 priya.patel@gmail.com C102 Records
Verma
Rahul
3
C103
rahul.verma@gmail.com
10-Mar-2012
4 Sneha Iyer 25-Nov-2011 sneha.iyer@gmail.com C101
5 Dev Kapoor 12-Jul-2012 dev.kapoor@gmail.com C102
The different components of a relational database are as follows:
Tables: A table is a collection of related records arranged in rows and columns. Each column
represents a specific type of information (attribute) and each row represents a record (tuple)

containing related data.
Fields: A field represents one related part of a table. It contains the same kind of data in a
table. For example, Student_ID, First_Name, Last_Name, Date of Birth, Email and Course_ID
are fields in the table.

Records: A record is a collection of related data stored in different fields, treated as a single
unit. It represents the data which is entered in a set of different fields which are related to a
particular item. For example, 1, Aarav, Sharma, 15-Mar-2012, aarav.sharma@gmail.com and

C101 is one of the records of the table.

KEYS IN DATABASE

A key is a column or set of columns that identifies records in a table. It is also called a key field and
can link data between tables. The most common types of keys in SQL are the primary key and the
foreign key.

58 Computer Science (V5.0)-VIII