Part-1: Point of Sale(POS) Inventory Super Shop Management System using ASP.NET MVC
Part-2: Point of Sale(POS) Setup template to your project | Super Shop Management System|ASP.NET MVC
Part-3: Point of Sale(POS) Database & table analysis | Super Shop Management System|ASP.NET MVC
Part-4: Point of Sale(POS) Database Create in SQL Server | Super Shop Management System|ASP.NET MVC
Part-5: Point of Sale(POS) Login using AJAX ASP.NET MVC | JQUERY
Part-6: Point of Sale(POS) Login and Authorization with Session variables in ASP.NET | JQUERY | AJAX
Part-7: Point of Sale(POS) Convert Password to MD5 Hash string in ASP.NET | Encrypt password in ASP.NET MVC C#
Part-8: Point of Sale(POS) Role based authentication and authorization in ASP.NET MVC|Redirect to not found page if not authorized|C#
Part-9: Point of Sale(POS) Create user & Account management UI UX in ASP.NET MVC
Part-10: Point of Sale(POS) User Creation & user registration using ASP.NET MVC | Jquery | Ajax
Part-11: Point of Sale(POS) Get user list using ASP.NET MVC | Jquery | Ajax
Part-12: Point of Sale(POS) Update user using ASP.NET MVC | Jquery | Ajax
Part-13: Inventory and POS Login logout session using ASP.NET | Supershop management system
Part-14: Inventory Category CRUD Create,Retrieve,Update,View | POS Category CRUD using ASP.NET JQuery AJAX
Part-15: Inventory and POS batch tracking and control table create in SQL Server 2012
Part-16: Inventory Product CRUD List | Point of sale Products Crud using asp.net MVC
Part-17: Inventory and POS Batch CRUD using asp.net MVC JQUERY AJAX | CSharp
Part-18: Inventory management and stock control using asp.net mvc | Jquery AngularJs
Part-19: Inventory & POS Stock edit and validation using asp.net AngularJS
POS 20: Inventory & POS AngularJS error fix
POS-21: Inventory & POS Invoice template setup using Bootstrap
POS-22: Invoice Adding input fields & adding rows Dynamically using Javascript | ASP.NET MVC | AngularJs
POS-23: Inventory Onclick get selected data & Calculate line total using Javascript ASP.NET MVC JQUERY
POS-24: Inventory Invoice Configuration and Calculation using JavaScript AngularJS ASP.NET MVC
POS-25: Inventory sale from invoice using ASP.NET MVC | Jquery AngularJS
POS-26: Get data using ASP.NET MVC AngularJS JQUERY
POS-27: Invoice sales page edit using ASP.NET MVC JQUERY AngularJS
POS-28: Invoice vat calculation discount calculation using Javascript ASP.NET MVC | Invoice crud asp.net
POS-29: Invoice calculate subtotal add row remove row using AngularJS ASP.NET MVC
In this tutorial I will create SQL database and also create table from the part three. If you don’t watch part-3 then please see the part-3. In the part three we create excel sheet and also, we write the table name also filed name. now in this part we create database under the database we create table and this table contain the many property. Each property has deferent data type also relation with pk and fk. No given bellow the step how to design the full database.
Step 1:
First open visual studio then creates a database. Then under the database create some table this table contain the many property also the table value has some data type.
Step 2:
When we create the tables then we need relation the database each table which is need the relation field.
|
Product Table |
|
|
Id |
pk |
|
Name |
|
|
CategoryId |
|
|
Status |
|
|
ProductQuantity Table |
|
|
Id |
pk |
|
ProductId |
fk |
|
Quantity |
|
|
Category Table |
|
|
Id |
pk |
|
Name |
|
|
Status |
|
|
Sales Table |
|
|
Id |
pk |
|
OrderNo |
|
|
CustomerName |
|
|
CustomerPhone |
|
|
CustomerAddress |
|
|
OrderDate |
|
|
PaymentMethod |
|
|
TotalAmount |
|
|
SalesDetail Table |
|
|
Id |
pk |
|
SalesId |
|
|
ProductId |
|
|
UnitPrice |
|
|
Quantity |
|
|
LineTotal |
|
|
User Table |
|
|
Id |
pk |
|
User Name |
|
|
Password |
|
|
Role |
|
|
Status |
|
Step 3: Now we can see the database table filed name and also, we can identify which is primary key and which is foreign key.
About Teacher
Comments
