Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,680 --> 00:00:04,340
What is a table and what is a table in the relational model?
2
00:00:05,120 --> 00:00:11,150
Well, we've looked at multiple, multiple examples of how to break down data.
3
00:00:11,450 --> 00:00:18,290
And each and every time we've broken down data, we've broken them down into these entities or objects
4
00:00:18,320 --> 00:00:26,420
or concepts, whatever you want to call them, be it a user, a student, a teacher, and a table is
5
00:00:26,420 --> 00:00:29,090
a representation of that object.
6
00:00:29,750 --> 00:00:34,310
So here we have the object user and we have a table.
7
00:00:35,030 --> 00:00:37,880
And when we create a table, we give it a name.
8
00:00:38,060 --> 00:00:40,010
That name is of that object.
9
00:00:40,100 --> 00:00:41,690
So we're going to call it user.
10
00:00:42,630 --> 00:00:47,070
So a table has a name that's the first and foremost important thing we need to know.
11
00:00:47,160 --> 00:00:52,190
Each table has a name and that name relates to the concept of the data we're going to store.
12
00:00:52,440 --> 00:00:55,740
Think of an Excel sheet and giving the Excel sheet a name.
13
00:00:56,430 --> 00:01:01,710
And then when we look at a table, we can see that we have these things at the top called columns.
14
00:01:02,190 --> 00:01:05,210
And each column represents a specific type of data.
15
00:01:05,970 --> 00:01:09,890
We have ID here, which is an incrementing number.
16
00:01:09,930 --> 00:01:12,530
It goes up one, two, three, four or five.
17
00:01:12,810 --> 00:01:17,280
Then we have first name that contains the name of the user, the first name and last name.
18
00:01:17,430 --> 00:01:23,910
And then we have their gender, male, female and so forth, and then we have their date of birth.
19
00:01:25,000 --> 00:01:33,490
Which follows a specific year, month, day, so what we can see here is that a table has a name and
20
00:01:33,490 --> 00:01:38,880
a table has columns that store specific types of data, kind of like an Excel sheet, but an Excel sheet.
21
00:01:38,890 --> 00:01:40,420
The names of the columns are already named.
22
00:01:40,600 --> 00:01:45,990
If you've seen Excel, you can see A, B, C, D here we get to choose the names.
23
00:01:46,150 --> 00:01:50,460
So that's very important because we're specifying what type of data we want to store in each column.
24
00:01:51,070 --> 00:01:58,360
And then here next to the columns, we have these rows also like an Excel sheet, these rows of data
25
00:01:58,690 --> 00:02:02,110
and each and every row is a singular piece of data.
26
00:02:02,350 --> 00:02:07,060
It represents one single piece of data for that table.
27
00:02:07,720 --> 00:02:14,350
So here you can see McGeeney, me, the instructor, and you can see my date of birth, my sex and my
28
00:02:14,350 --> 00:02:15,340
ID as a user.
29
00:02:16,360 --> 00:02:22,150
That is one piece of data and that data is split up into columns that represent each and every piece.
30
00:02:23,100 --> 00:02:24,390
Very, very important.
31
00:02:25,320 --> 00:02:30,390
So here we can see the relationship between what a table is and what an Excel sheet is, like I said,
32
00:02:31,080 --> 00:02:36,900
you can see over here every sheet has a name, kind of like a table, has a name, and every sheet has
33
00:02:36,900 --> 00:02:39,390
columns, A, B, C, D, E, F.
34
00:02:39,720 --> 00:02:44,910
Kind of like our table has columns, but our columns are more specific.
35
00:02:44,910 --> 00:02:52,020
We are actually saying what we want to store in each and every column where in Excel the columns are
36
00:02:52,020 --> 00:02:58,260
generic, they're pre named, so to speak, so that it doesn't matter what data you put in here, it's
37
00:02:58,260 --> 00:02:59,610
going to accept any type of data.
38
00:02:59,760 --> 00:03:02,700
You just know that your column name is A, B or C.
39
00:03:03,710 --> 00:03:09,410
You can go a bit farther and excel and give specific columns at row one, you could put first name here,
40
00:03:09,410 --> 00:03:13,580
last name here, date of birth here, just so you know what's going to be in these columns.
41
00:03:13,580 --> 00:03:15,340
But you you would lose a row.
42
00:03:16,340 --> 00:03:24,050
But that being said, the relationship between the two is very close, except in the relational model,
43
00:03:24,530 --> 00:03:28,480
a table has much more nuance.
44
00:03:28,520 --> 00:03:29,900
What do I mean by nuance?
45
00:03:30,230 --> 00:03:32,160
There's a lot more details here.
46
00:03:32,360 --> 00:03:37,200
We're very, very, very specific in what we want to store and how we want to store it.
47
00:03:37,940 --> 00:03:44,390
So now that we know that, let's take a closer look at what a column is and how that gets defined.
5161
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.