[go: up one dir, main page]
Scribd
Upload
59 views9 pages

VBA SQL Case Study

The document discusses using technology in a garments shop business. It outlines the entity relationship diagram and tables for customers, products, sales employees, and managers. It also provides examples of SQL queries, a stored procedure, and graphs that could be used to analyze data and operations in the garments shop business.

Uploaded by

Aditya Bhatt
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
59 views9 pages

VBA SQL Case Study

The document discusses using technology in a garments shop business. It outlines the entity relationship diagram and tables for customers, products, sales employees, and managers. It also provides examples of SQL queries, a stored procedure, and graphs that could be used to analyze data and operations in the garments shop business.

Uploaded by

Aditya Bhatt
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

Technology in Business

Case Study
Garments Shop

NAME ADITYA BHATT 

PRN 19030141004

Due September 26, 2020


Business Name: Garments Shop
Introduction: The business is a regular garments shops ranging from
inner wear to formals, it contains product for both men and women,
the products are also categorised based on age (kids, Teenagers,
Adults). with the sales employee and manager managing the working
and inventory of the store.
E-R Diagram:
Entity List:
Customer
Product
Sales_Employee
Manager

Sql Tables:
1. Customer Table:
Sql command:

Sql Output:
2. Product Table:
Sql command:

Sql Output:

3. Product Table:
Sql command:

Sql Output:
4. Product Table:
Sql command:

Sql Output:
VBA User Forms:
Registration Form
Enquiry Form
SQL Queries:
1) COUNT() , GROUP BY
SELECT COUNT(product_id), Company_name
FROM product
GROUP BY Company_name;
2) SUM()
SELECT SUM(product_quantity)
FROM product;
Stored Procedure:
CREATE PROCEDURE Select_all_Products @Company_name nvarchar(30)
AS
SELECT * FROM product WHERE Company_name = @Company_name
GO;
Graph:
Bar Graph,
Line Chart
Pie Chart

You might also like