Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
WEBVTT
00:00.210 --> 00:03.040
Open SQL Server, we're using SLQ Server 2012.
00:03.060 --> 00:08.810
But you can also use 2016, 2017, 2019, it will be the same procedure of creating the table.
00:09.180 --> 00:12.950
We will connect to the database, to the server.
00:13.290 --> 00:16.380
Then we open the database, expand the database.
00:16.740 --> 00:22.890
We check for our database name, which is a Point of Sale, that is the database we are creating.
00:23.340 --> 00:25.320
You expand it then.
00:25.320 --> 00:32.580
Right-click on table, new table, add the columns. The first table we're going to create it's the
00:32.880 --> 00:34.470
first button menu.
00:34.680 --> 00:35.820
The first menu.
00:36.150 --> 00:39.830
You know, our menu has three category or three types.
00:40.200 --> 00:45.210
So the first one we going to create it, then the second Category, then the third one. All will have the
00:45.210 --> 00:45.960
relationship.
00:45.960 --> 00:54.360
As we saw in the relationship, the column name will be first button name, data character we will select
00:55.140 --> 00:56.430
variant character.
00:58.350 --> 00:59.580
We give it 50.
01:02.940 --> 01:09.830
Then we make it as a primary key because we will have only one column, we make it as primary key,
01:10.260 --> 01:11.670
we will click on Save.
01:11.970 --> 01:17.670
We add the name of the table, which is first menu button or first button menu.
01:17.670 --> 01:21.800
Refresh the database so that you can see that table created.
01:22.230 --> 01:23.700
Same procedure, right-click
01:23.700 --> 01:26.310
on table, create a new table.
01:27.030 --> 01:29.970
put the column name: second category.
01:32.160 --> 01:39.720
We put the name of the column second button menu, then we give the data type, which is
01:39.720 --> 01:44.660
variant character, we give it as a primary key.
01:45.020 --> 01:48.900
Then we add the second column name, which is the first button.
01:48.900 --> 01:57.090
Again, this name, first button is in the first table and in second table because you'll have a relationship.
01:57.600 --> 02:06.790
Then we save we put the name of the table and then we're done with the second button or the second table.
02:08.190 --> 02:12.390
So from this procedure, you can create all other tables.
02:12.630 --> 02:13.770
It's only right-Click
02:13.770 --> 02:23.790
on the table, you click on new, you add the columns data type, then you save after adding the
02:23.790 --> 02:25.230
name of the table.
02:25.920 --> 02:27.570
Then you can close the table.
02:28.440 --> 02:38.250
That the same procedure for all tables in all other SQL Server 2012, 2014, 2016... it is the
02:38.250 --> 02:40.620
same procedure of creating table right-click
02:40.620 --> 02:43.880
on table, new table, add column...
02:43.890 --> 02:46.860
Then you click on save, remember to add the name of the table.
02:47.550 --> 02:54.930
We are going to create the Third table, which is the third category or the third Category menu item.
02:55.950 --> 03:00.420
We put the first column name as the button menu.
03:01.230 --> 03:03.960
Second column, second button menu.
03:05.400 --> 03:06.390
The third one.
03:07.680 --> 03:11.880
Will it be quantity because it's from this table we will to make orders.
03:11.880 --> 03:16.680
When we are selling things, when we are selling like beverage, selling food.
03:17.250 --> 03:20.550
Then we have to put quantity and unit price.
03:22.390 --> 03:25.520
designation will be the third button menu.
03:25.570 --> 03:33.710
That name will contain the name of the product. Even here we can add barcode column ...
03:33.730 --> 03:35.930
where we going to save the barcode.
03:35.950 --> 03:37.680
Yeah, we can add it also.
03:37.690 --> 03:46.870
So when we done, we click on Save, we add the name of the table, then we can close and refresh the
03:46.870 --> 03:49.670
database to see if the table is created.
03:51.250 --> 03:52.930
We will create a Customer table.
03:52.940 --> 04:01.750
So the customer table will have a customer Identification, customer name, customer surname, address, telephone number,
04:01.750 --> 04:02.840
email.
04:03.310 --> 04:06.420
All of those details will need them for every customer.
04:07.000 --> 04:16.630
So customer ID can be the primary key of that table customer. Wecan get the reference
04:16.660 --> 04:25.900
From our point of sale created already so we can see how many columns it contains, the name of the
04:25.900 --> 04:33.400
columns, we can refer from there. Customer name, customer category,
04:33.850 --> 04:38.740
customer surname, email address, first address, second address and telephone number.
04:39.160 --> 04:43.810
All those columns can add be added to our
04:44.350 --> 04:45.430
Customer table.
04:48.000 --> 04:54.360
This is the end of the creation of talbes, we created for buttons, we created for customer, but you
04:54.360 --> 05:03.990
can create also for supplier, you can create for item size, item category, item name, Store, all of that.
05:03.990 --> 05:05.670
You can create those tables.
05:05.680 --> 05:06.480
I will give you.
05:06.930 --> 05:13.650
the list of almost all the tables we need for this application (this database).
05:13.920 --> 05:22.080
But it will depend on where you are, how you did your information gathering, because it can't be the
05:22.080 --> 05:22.410
same.
05:22.410 --> 05:26.240
It's almost the same, but it can't be the same because it depends where you are.
05:26.760 --> 05:33.210
So it will depend on your information gathering, the information you have about the kind of
05:33.210 --> 05:35.670
point of sale you need to create.
05:36.360 --> 05:38.150
It will depend on all of that.
05:38.520 --> 05:39.860
So thank you so much.
05:39.870 --> 05:41.820
See you for next lecture.6112
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.