Question

define the following terms
1. tuple .
2. foreign key.
3.DBMS

Answer 1

1.Tuple is row in a table of database

2. Foreign key is a column or group of columns in a relational database table that provides a link between data in two tables.

3.DBMS stands for database management system.DBMS is system software for creating and managing databases.

Answer 2

Answer:

 Tuple: In DBMS, horizontal subset/ information in a table is called tuple. The tuple is also known as a ' record ', which gives particular information of the relation ( table ).  

for example :

• in customer table, one row gives information about one customer only.
• in student table, one  row gives information about one student only.

Foreign key: A foreign key is a field in database table that is primary key in another table. It can accept multiple null and duplicate values.

A foreign key is a column which is added to one table to create a relationship with another table.

DBMS:   DBMS stands for Database Management System. DBMS is a collection of program which enables its user o access database, manipulate data and help in represent of data. It also helps control access to the database by various users.  

example: An online telephone directory would definitely use database management system to store data pertaining to people, phone numbers and other contact details.