Haji Karim Baksh
-
Upload
habib-ullah-shah -
Category
Documents
-
view
231 -
download
0
Transcript of Haji Karim Baksh
-
7/30/2019 Haji Karim Baksh
1/22
More than just shopping
1
-
7/30/2019 Haji Karim Baksh
2/22
More than just shopping
PRESENTED BY:
MADIHA MASOOD 083143IMRAN KHALID 083137FAWAD HASSAN 083155
PRESENTED TO:
SIR ABDUL GAFFAR
Institute of Management
Sciences Lahore
2
-
7/30/2019 Haji Karim Baksh
3/22
More than just shopping
TABLE OF CONTENTInstitute of Management Sciences Lahore .....................................................................2
TABLE OF CONTENT .................................................................................................3
Acknowledgement ..........................................................................................................4
Mission Statement ..........................................................................................................5
Introduction ....................................................................................................................6
Authorization ..............................................................................................................6
We have prepared this report as per the instructions of our dear Sir Abdul Gaffar.
Thanks to him for giving us an opportunity for preparing this report. ..........................6
Outline ........................................................................................................................6
Department .................................................................................................................6
The warehouse issues a Purchase Order to the suppliers and purchases are made. The
branch then issues a requisition to the ware house and obtains the required products.
These are displayed and the customers can now buy the products................................6
Haji Karim Baksh ...........................................................................................................7
Profile ...........................................................................................................................7
Corporate Office .............................................................................................................7
Branches .........................................................................................................................7
Features .......................................................................................................................... 8
Entities ............................................................................................................................8
Tables .............................................................................................................................9Employees ..................................................................................................................9
Customer .................................................................................................................... 9
Branches .....................................................................................................................9
Departments ..............................................................................................................10
Products .................................................................................................................... 10
Warehouse ................................................................................................................ 10
Requisition ............................................................................................................... 10
SalesInvoice ..............................................................................................................11
Dep-Branch .............................................................................................................. 11
RELATIONAL SCHEMA ........................................................................................... 14
Forms, Queries and Reports ......................................................................................... 15Forms ............................................................................................................................16
Products .................................................................................................................... 16
Department ............................................................................................................... 17
Branch ...................................................................................................................... 17
Employees ................................................................................................................ 18
Customer .................................................................................................................. 18
Products .................................................................................................................... 19
Invoice ...................................................................................................................... 19
Queries ..........................................................................................................................20
Invoice Deatil ........................................................................................................... 20
Branch with Department .......................................................................................... 20Report ........................................................................................................................... 21
3
-
7/30/2019 Haji Karim Baksh
4/22
More than just shopping
Acknowledgement
We would like to express our gratitude to those
people who personally help us through out in
studying.
4
-
7/30/2019 Haji Karim Baksh
5/22
More than just shopping
Mission Statement
We at HKB believe that bestquality products at competitiveprice should be made available to
our customers. We want to make
their shopping experience at
HKB memorable by providingbest services by the most
dedicated and efficient peoplein town. Therefore at HKB it
is
Not just shopping
We wish to scale new heights and achieve
laurels for our traditional business. We believein offering best value for money and excellencein customer services.
5
-
7/30/2019 Haji Karim Baksh
6/22
More than just shopping
Introduction
Authorization
We have prepared this report as per the instructions of our dear SirAbdul Gaffar. Thanks to him for giving us an opportunity for
preparing this report.
OutlineIn this report, first of all, we have given the profile and history ofHKB and its future endeavors. Secondly we discussed thedepartments at HKB. Finally we have described the processes andthe tables, quires, forms, reports and macros we have used in ourdatabase system.
Department
The departments in HKB include:
Grocery
Fabrics
Garments
Crockery
Traveling Goods
Gifts
The warehouse issues a Purchase Order to the suppliers and purchasesare made. The branch then issues a requisition to the ware house and
obtains the required products. These are displayed and the customerscan now buy the products.
Each branch has a manager for each department and an assistant salesmanager. There are many employees at each department.
6
-
7/30/2019 Haji Karim Baksh
7/22
More than just shopping
Haji KarimBaksh
ProfileHaji Karim Baksh (HKB) Pvt. Ltd. is situated in the historical and thecultural capital of Pakistan, Lahore. At present it employs over 400dedicated team members and enjoys the trust and confidence of over 7million customers annually.
HKB is having an air-conditioned selling space of over 70,000 square feet.Its stores are located in the citys premier shopping areas, in terms ofinfrastructure, access, and affluent shopping traffic.
HKB is one of the leading Departmental stores operating in Lahore. It falls
among the top 5 Departmental Stores of Lahore according to sales
revenue. It is the first self-service supermarket of Lahore.
Corporate Office
206-S Quaid-e-Azam Industrial Estate
Kot Lakhpat Lahore 54770UAN: +92 111-452-452
Branches
Liberty Market, LahorePh: +92-42-5755678-80
Y-Block, DefencePh: +92-42-5732701-3
The Mall, Lahore
Ph: +92-42-7352066
Moon Market, LahorePh: +92-42-7467766
7
-
7/30/2019 Haji Karim Baksh
8/22
More than just shopping
Cavalry Grounds, Lahore
Ph: +92-42-6672663
Features
Best quality products
Extraordinary services
Reasonable price
More variety
Houses 100,000 items with 800 suppliers
EntitiesThe entities which were chosen are:
Departments
Customer
Employees
Sales Invoice
Products
Ware house
Branch
Dept-Branch
Requisition
8
-
7/30/2019 Haji Karim Baksh
9/22
More than just shopping
Tables
Employees
Field name Data type Description
Employee_id Text Primary key
Name Text
Address Memo
Title Text
Branch_id Text Foreign key
manager_id Text Foreign key
Customer
Field name Data type Description
Customer_Id Auto number Primary keyCustomer_Name Text
Phone_No Text
Branches
Field name Data type Description
Branch_id Text Primary keyBranch_Address Memo
9
-
7/30/2019 Haji Karim Baksh
10/22
More than just shopping
Departments
Field name Data type Description
Department_id Text Primary key
Name Text
Products
Field name Data type Description
Product_id Number Primary key
Product_name Text
Unit_price currency
Warehouse
Field name Data type Description
Warehouse_id Text Primary key
location Memo
Requisition
Field name Data type Description
Product_Id number Primary key
Warehouse_Id Number Primary key
Qty number
10
-
7/30/2019 Haji Karim Baksh
11/22
More than just shopping
SalesInvoice
Dep-Branch
Field name Data type Description
Department_id Text Primary key
Lbranch_Id Text
11
Field name Data type Description
Invoice_Id AutoNumber Primary key
Product_Id Number Foreign key
Employee_Id Number Foreign key
Customer_Id Number Foreign key
Unit Number Foreign key
-
7/30/2019 Haji Karim Baksh
12/22
More than just shopping
ERD MODAL
12
-
7/30/2019 Haji Karim Baksh
13/22
More than just shopping
Entity Relationship Diagram
ERD in MS Access
13
-
7/30/2019 Haji Karim Baksh
14/22
More than just shopping
RELATIONAL SCHEMA
14
-
7/30/2019 Haji Karim Baksh
15/22
More than just shopping
Forms, Queriesand Reports
15
-
7/30/2019 Haji Karim Baksh
16/22
More than just shopping
FormsForms are generally made in order to enter data forthe user point of view. So forms interact directlywith users in order to enter data according to theneeds of user which he wants to be seen.
Products
16
-
7/30/2019 Haji Karim Baksh
17/22
More than just shopping
Department
Branch
17
-
7/30/2019 Haji Karim Baksh
18/22
More than just shopping
Employees
Customer
18
-
7/30/2019 Haji Karim Baksh
19/22
More than just shopping
Products
Invoice
19
-
7/30/2019 Haji Karim Baksh
20/22
More than just shopping
Queries
Invoice Deatil
Branch with Department
20
-
7/30/2019 Haji Karim Baksh
21/22
More than just shopping
Report
21
-
7/30/2019 Haji Karim Baksh
22/22
More than just shopping