Search code examples
databaserowtuplesrecord

What is the difference between a row, record and tuple?

I am studying in a database development course at the moment and I am having trouble getting my head this!

My course notes describe a tuple as: A tuple is a row of a relation

From what I have understood since working with MySQL you search for row(s). Or when browsing through a database you are looking through rows in a table.

And from what I understood a record is information within a row.

Is there any distinct differences between the three?

I know someone has posted something similar but I couldn't really understand his answer.

Thanks for all help in advnce!

Peter

Solution

  • In your context they are different words to mean exactly the same thing.

    A tuple, in general, means an ordered list with possibly repeated elements (as contrasted to a set, which has all unique elements and is not ordered)