Column ‘A
Column ‘B’
(1) RDBMS
(B) Collection of interrelated
data
(2) Table
(A) Storage unit in a
Relational database
(3) Database designer
(D) Decides the name of the
table and titles of Columns
(4) Record
(C) Tuple
Column ‘A
Column ‘B’
(1) SELECT
(B) Extracts data from a table
(2) UPDATE
(A) Updates data in a table
(3) DELETE
(C) Deletes data from a table
(4) INSERT INTO
(D) Insert data into a table
1. Relationships link data from individual tables to increase the usefulness of the database.
2. A Relationship in the context of databases is a situation that exists between two relational database...
1. In a One-to-One relationship, one record in a table is associated with one and only one record in another table.
2. One-to-Many relationships can also be viewed as Many-to-One relationships,...