Original subtitles

Open SQL Server, we're using SLQ Server 2012.

But you can also use 2016, 2017, 2019, it will be the same procedure of creating the table.

We will connect to the database, to the server.

Then we open the database, expand the database.

We check for our database name, which is a Point of Sale, that is the database we are creating.

You expand it then.

Right-click on table, new table, add the columns. The first table we're going to create it's the

first button menu.

The first menu.

You know, our menu has three category or three types.

So the first one we going to create it, then the second Category, then the third one. All will have the

relationship.

As we saw in the relationship, the column name will be first button name, data character we will select

variant character.

We give it 50.

Then we make it as a primary key because we will have only one column, we make it as primary key,

we will click on Save.

We add the name of the table, which is first menu button or first button menu.

Refresh the database so that you can see that table created.

Same procedure, right-click

on table, create a new table.

put the column name: second category.

We put the name of the column second button menu, then we give the data type, which is

variant character, we give it as a primary key.

Then we add the second column name, which is the first button.

Again, this name, first button is in the first table and in second table because you'll have a relationship.

Then we save we put the name of the table and then we're done with the second button or the second table.

So from this procedure, you can create all other tables.

It's only right-Click

on the table, you click on new, you add the columns data type, then you save after adding the

name of the table.

Then you can close the table.

That the same procedure for all tables in all other SQL Server 2012, 2014, 2016... it is the

same procedure of creating table right-click

on table, new table, add column...

Then you click on save, remember to add the name of the table.

We are going to create the Third table, which is the third category or the third Category menu item.

We put the first column name as the button menu.

Second column, second button menu.

The third one.

Will it be quantity because it's from this table we will to make orders.

When we are selling things, when we are selling like beverage, selling food.

Then we have to put quantity and unit price.

designation will be the third button menu.

That name will contain the name of the product. Even here we can add barcode column ...

where we going to save the barcode.

Yeah, we can add it also.

So when we done, we click on Save, we add the name of the table, then we can close and refresh the

database to see if the table is created.

We will create a Customer table.

So the customer table will have a customer Identification, customer name, customer surname, address, telephone number,

email.

All of those details will need them for every customer.

So customer ID can be the primary key of that table customer. Wecan get the reference

From our point of sale created already so we can see how many columns it contains, the name of the

columns, we can refer from there. Customer name, customer category,

customer surname, email address, first address, second address and telephone number.

All those columns can add be added to our

Customer table.

This is the end of the creation of talbes, we created for buttons, we created for customer, but you

can create also for supplier, you can create for item size, item category, item name, Store, all of that.

You can create those tables.

I will give you.

the list of almost all the tables we need for this application (this database).

But it will depend on where you are, how you did your information gathering, because it can't be the

same.

It's almost the same, but it can't be the same because it depends where you are.

So it will depend on your information gathering, the information you have about the kind of

point of sale you need to create.

It will depend on all of that.

So thank you so much.

See you for next lecture.