All language subtitles for 33 - Rows English

All right, so what's so special about Rose?

Well, so far we've talked about tables and tables being a collection of columns and rows, and we kind

of talked about columns being special in that they have specific types of data that can be saved into.

Now, when we go into the specific data that we're receiving, well, each and every column has that

constraint, right?

The constraint that we talked about or the attribute domain?

Well, when we start creating rows, we're actually inserting data into the table at this point.

And another word for Rose that you will hear used interchangeably is couples.

I can hear you saying tuples, what are tuples?

Well, a tuple is nothing more than a single record of data.

That's all it means, so one Topal is one singular row of data tuples are multiple rows of data.

And so what's important to know here is that each and every couple follows the column constraints,

right?

Remember when we had constraints above here, date of birth should only be daytime.

Well, each and every couple has to follow the column constraints, so the ID must always be a number

of first name and last name can only be text.

The sex or gender has to be a singular letter.

Date of birth has to be a date of birth.

That's what's so special about Rose or as we call them, also couples.

Remember when we said multiple columns are called the degree, the collection of columns?

Well, when we talk about all of the tuples or all of the rows, all of the data that is in the table,

we have a special term for that as well.

We call that the cardinality or the collection of rows or tuples.

That's a special term that you may also hear used, although not that often.

But it is the correct terminology.

When talking about multiple rows of data, you talk about the cardinality of the table.

All right.

So now that we've delve deeper into both columns and rows, let's take a broader look at what makes

the relational model so special.