1
00:00:00,300 --> 00:00:00,720
All right.

2
00:00:00,720 --> 00:00:04,140
So it's your turn to put some of this into practice with a single exercise.

3
00:00:04,140 --> 00:00:05,450
It should be pretty quick.

4
00:00:05,520 --> 00:00:08,280
All you need to do is define a single table.

5
00:00:08,550 --> 00:00:09,870
So here are the demands.

6
00:00:10,170 --> 00:00:11,640
Well, the man sounds a little strong.

7
00:00:11,670 --> 00:00:12,930
Here are the requirements.

8
00:00:13,560 --> 00:00:15,450
Define an employee's table.

9
00:00:15,510 --> 00:00:18,240
So let's say we're a company trying to manage some employees.

10
00:00:18,240 --> 00:00:21,330
We'll definitely need more data than this to actually make it operational.

11
00:00:21,330 --> 00:00:22,920
But for now, this is all we need.

12
00:00:22,920 --> 00:00:24,420
Seven different fields.

13
00:00:24,420 --> 00:00:25,440
Seven columns.

14
00:00:25,470 --> 00:00:28,860
ID last name, first name and middle name.

15
00:00:28,860 --> 00:00:31,510
And then age and current status.

16
00:00:31,530 --> 00:00:33,180
And actually, I can't count.

17
00:00:33,180 --> 00:00:34,200
This is six.

18
00:00:34,530 --> 00:00:38,040
So ID is relatively self-explanatory.

19
00:00:38,160 --> 00:00:39,180
It should be a number.

20
00:00:39,210 --> 00:00:42,490
I'm not telling you the data types, but you should know at this point what they are.

21
00:00:42,510 --> 00:00:45,780
So a number that automatically increments it's mandatory.

22
00:00:45,780 --> 00:00:47,040
So it can't be left off.

23
00:00:47,040 --> 00:00:48,480
And it's a primary key.

24
00:00:49,400 --> 00:00:53,550
Last name and first name are both text, which is in the data type.

25
00:00:53,560 --> 00:00:58,260
Again, you need to use the actual term and then neither of them can be left blank either.

26
00:00:58,280 --> 00:01:00,560
They're mandatory, but middle name.

27
00:01:00,560 --> 00:01:05,990
While it's also text, it isn't mandatory because not everyone has a middle name so we can leave that

28
00:01:05,990 --> 00:01:06,500
blank.

29
00:01:06,680 --> 00:01:10,760
Then we've got age which is numeric and it is mandatory, can be blank.

30
00:01:10,790 --> 00:01:16,130
And finally, current status, which is essentially like their employment status, if they're employed

31
00:01:16,130 --> 00:01:18,230
or if they're fired and it should be mandatory.

32
00:01:18,230 --> 00:01:19,310
So it can't be null.

33
00:01:19,430 --> 00:01:26,000
But if no status is provided, when something is inserted, it should default to employed.

34
00:01:26,540 --> 00:01:32,180
So we'll have to statuses employed and terminated or fired or something, I guess terminated.

35
00:01:32,180 --> 00:01:38,660
It's more professional and so it should just default to current status is employed if nothing is provided

36
00:01:38,660 --> 00:01:39,640
when it's inserted.

37
00:01:40,010 --> 00:01:41,910
So go ahead and define this table.

38
00:01:41,930 --> 00:01:42,980
Type it out.

39
00:01:43,100 --> 00:01:47,930
Try running it to make sure it works and then try inserting some data as well to make sure that it works.

40
00:01:48,980 --> 00:01:51,050
If you want a solution, have it in the next video.