Briefly Explain the following terms: (i) Tuple (ii) Relation (iii) Degree (iv) Foreign Key
Answers
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
Relation:relation is a two-dimensional table i.e the information is arranged in rows and columns. It is called a relation because the data values in the table are not homogenous i.e not if the same type or we can say that, the values in a row are not homogenous.
Degree:degree describes the level, intensity or seriousness of something. You could say there are many degrees
Foregin key:foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.