WEBVTT 00:00.330 --> 00:00.740 All right. 00:00.750 --> 00:04.150 So it's your turn to put some of this into practice with a single exercise. 00:04.170 --> 00:05.660 It should be pretty quick. 00:05.670 --> 00:08.700 All you need to do is define a single table. 00:08.700 --> 00:10.140 So here are the demands. 00:10.230 --> 00:15.440 Well the man sounds a little strong here the requirements define an Employees table. 00:15.510 --> 00:17.380 So let's say we're a company trying to manage them. 00:17.380 --> 00:21.420 Employees will definitely need more data than this to actually make it operational. 00:21.420 --> 00:22.980 But for now this is all we need. 00:22.980 --> 00:30.480 Seven different fields seven columns ID last name first name and middle name and then age and current 00:30.570 --> 00:31.450 status. 00:31.740 --> 00:33.160 And actually I can't count. 00:33.210 --> 00:34.400 This is six. 00:34.710 --> 00:37.960 So Id it's relatively self-explanatory. 00:38.160 --> 00:39.230 It should be a number. 00:39.240 --> 00:42.520 I'm not telling you the data types but you should know at this point what they are. 00:42.600 --> 00:48.000 So a number that automatically increments it's mandatory so it can't be left off and it's a primary 00:48.000 --> 00:48.430 key. 00:49.460 --> 00:53.490 Last name and first name are both text which is in that data. 00:53.540 --> 00:58.280 Again you need to use the actual term and then neither of them can be left blank either. 00:58.280 --> 01:00.490 They're mandatory but middle name. 01:00.710 --> 01:06.540 Well it's also text it isn't mandatory because not everyone has a middleman so we can leave that blank. 01:06.860 --> 01:10.740 Then we've got age which is numeric and it is mandatory can be playing. 01:10.970 --> 01:16.220 And finally current status which is essentially like their employment status if they're employed or 01:16.220 --> 01:17.080 if they're fired. 01:17.210 --> 01:19.440 And it should be mandatory so it can't be null. 01:19.640 --> 01:26.240 But if no status is provided when something is inserted it should default to employed. 01:26.690 --> 01:31.100 So we'll have two statuses employed and terminated or fired or something. 01:31.490 --> 01:33.110 I guess turbinate is more professional. 01:33.140 --> 01:39.560 And so it should just default to current status is employed if nothing is provided to insert. 01:39.670 --> 01:40.030 OK. 01:40.040 --> 01:43.100 So go ahead and define this table type it out. 01:43.110 --> 01:47.690 Try running it to make sure it works and then try inserting some data as well to make sure that it works 01:48.120 --> 01:48.850 ok. 01:49.040 --> 01:50.920 If you want a solution have it in the next video.