define the following terms
1. tuple .
2. foreign key.
3.DBMS
Answers
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:
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.