Shop Management

Technologies:

In this project we have developed two Web applications:

• User Interface
• Administrator Interface

User Side

We have developed a user interface for the shop. The user will need first to access the website, all the products will be displayed in categories, then he will add to cart all the products that he wants to buy, he can remove from cart also. When the user wants to complete the purchase, he will check out, all the calculations are made including if there is a discount or not, then the total amount is displayed on the screen, if the user wants to continue he will need to insert all his billing details, then place the order. The order and costumer details will be updated into the database and the administrator system.

Admin Side

We have developed a Shop Management System. The basic concept to develop this system was to manage shop products, orders, sales and manage all the functionalities related to the shop… The admin first will need to login then he will be able to:

• Manage products sales
• Manage products stocks
• Manage products categories
• Manage depots
• Manage products discounts
• Manage suppliers and their supplies
• View all orders information
• View customers

All those changes will be updated directly into the database.

Application Architecture:

Database Modeling :

For our project we used power Designer to design the ER and physical diagram that helped us with the creation of database and the generation of the tables and indexes.

ER Diagram(ERD)

Physical-Data-Model(PDM)

Create DDL script:

• Create Tables
• Create Indexes
• Create Views
• Create Procedures
• Create Triggers
• Create Functions
• Create Logins with User and Priviligies

Batch File

set LOC=C:\Users\hp\Desktop\Project\DataBase
set SERV=-S HP-PC\SQLEXPRESS -U sa -P RanaJaafar

echo Beginning...

osql %SERV% -i%LOC%\sql\Shop-CreateDB.sql -o%LOC%\log\DB.log
echo Database created...

osql %SERV% -i%LOC%\sql\Shop-CreateTables.sql -o%LOC%\log\Tables.log
echo Tables created...

osql %SERV% -i%LOC%\sql\Shop-CreateIndexes.sql -o%LOC%\log\Indexes.log
echo Indexes created...

osql %SERV% -i%LOC%\sql\Shop-CreateViews.sql -o%LOC%\log\Views.log
echo Views created...

osql %SERV% -i%LOC%\sql\Shop-CreateProcedures.sql -o%LOC%\log\Procedures.log
echo Procedures created...

osql %SERV% -i%LOC%\sql\Shop-CreateTriggers.sql -o%LOC%\log\Triggers.log
echo Triggers created...

osql %SERV% -i%LOC%\sql\Shop-CreateFunctions.sql -o%LOC%\log\Functions.log
echo Functions created...

osql %SERV% -i%LOC%\sql\Shop-InsertData.sql -o%LOC%\log\Data.log
echo Data inserted...

osql %SERV% -i%LOC%\sql\Shop-CreateLogins.sql -o%LOC%\log\Logins.log
echo Logins created...

echo End of batch file...

for execute all the sql Script you have set LOC by the path of folder DataBase in your machine,and set SERV by Login and Password of MS SQL