SIES COLLEGE OF ARTS, SCIENCE & COMMERCE (AUTONOMOUS)

SION (W), MUMBAI-22

DEPARTMENT OF INFORMATION
TECHNOLOGY SYBSc(IT)

SEMESTER III

INTERNAL PROJECT

For the Subject

DATABASE MANAGEMENT SYSTEM

Title of the Project :

Stationary Shop Management System

Submitted by:

Sr. no. Roll no. Name

1. SIT2425001 Abishek Karan Raja Esakki
2. SIT2425002 Adeli Praful Lingamurthi

3. SIT2425003 Aditya Santosh Sheena

4. SIT2425004 Agarshna Venkat Ramanan Jayarani

5. SIT2425005 Agasur Akash Babu

FOR THE YEAR

2024 – 2025
 Table of Contents

Sr. no Contents Page No.

1 List of Tables with a brief description of their contents 1

2 Tables with column names, datatypes and constraints 3

3 Entity Relationship Diagram 10

4 Business Rules (Statements for the Entity Relationships) 11

5 Tables with valid values 15

I . List of Tables with a brief description of their contents

1. Customers: Represents individuals or organizations who purchase stationery items. Essential

for tracking sales.

2. Products: Items available for sale, such as pens, notebooks, and office supplies. Needed for
inventory management and order fulfillment.

3. Categories: Groups products into classifications like "Pens" or "Notebooks" Helps organize
inventory and simplifies customer navigation.

4. Employees: Staff members who handle operations, sales, and customer service. Important for
managing roles, tracking performance, and payroll.

5. Suppliers: Entities that provide products to the shop. Key for inventory replenishment and
ensuring a steady supply of goods.

6. Inventory: Tracks the quantity and availability of products in stock. Essential for managing
stock levels, avoiding shortages, and ensuring efficient order fulfillment.

7. StockAdjustments: Records of inventory changes due to reasons like damage, discrepancies or

arrival of new stock. Important for maintaining accurate stock levels.

8. Orders: Records of customer purchases. Necessary for processing sales, tracking order history,
and managing transactions.

9. OrderItems: Details individual items within an order. Important for accurate order fulfillment
and inventory deduction.

10. Invoices: Document detailing the amount due for an order. Used for billing customers and
recording sales transactions.

1
11. Payments: Records of financial transactions made by customers. Essential for tracking revenue
and managing cash flow.

12. Returns: Handles the process of customers returning items. Important for managing inventory
adjustments and customer satisfaction.

13. ReturnItems: This entity details each product within a return, including quantity and refund
amount.

14. SupplierOrders: Records of orders placed with suppliers for inventory replenishment. Key for
managing stock levels and supplier interactions.

15. SupplierOrderItems: Details of individual items in a supplier order. Ensures accurate ordering
and inventory updates.

16. SupplierInvoice: Billing document from suppliers for goods provided. Used for financial
records and managing supplier payments.

17. SupplierPayment: Records of payments made to suppliers. Essential for managing expenses
and maintaining good supplier relationships.

2
II. Tables with column names, datatypes and constraints

1. Customers

Field Name Datatype and width Constraint

CustomerID Number (5) Primary Key
FirstName Varchar2 (25) --

LastName Varchar2 (25) --

RegistrationDate Date --

Email Varchar2 (25) --

Phone Number (15) --

2. Products

Field Name Datatype and width Constraint

ProductID Number (5) Primary Key
ProductName Varchar2 (25) --
Description Varchar2 (25) --
Price (Rs.) Number (8) --
Foreign Key (Primary Key –
CategoryID Number (5)
Categories(CategoryID))

SupplierID Number (5) Foreign Key (Primary Key –

Suppliers(SupplierID))

3. Categories

Field Name Datatype and width Constraint

CategoryID Number (5) Primary Key
CategoryName Varchar2 (25) --
Description Varchar2 (50) --

3
4. Employees

Field Name Datatype and width Constraint

EmployeeID Number (5) Primary Key
FirstName Varchar2 (25) --
LastName Varchar2 (25) --
Position Varchar2 (25) --
HireDate Date --
Email Varchar2 (25) --
Phone Number (15) --

5. Suppliers

Field Names Datatype and width Constraint

SupplierID Number (5) Primary Key
SupplierName Varchar2 () --
ContactName Varchar2 (25) --
Email Varchar2 (25) --
Phone Number (15) --
Address Varchar2 (50) --

4
6. Inventory

Field Names Datatype and width Constraint

InventoryID Number (5) Primary Key
Foreign Key (Primary Key –
ProductID Number (5)
Products(ProductID))
Foreign Key (Primary Key –
EmployeeID Number (5)
Employees(EmployeeID))

RecordedDate Date --

Quantity Number (5) --

Location Varchar2 (50) --

7. StockAdjustments

Field Names Datatype and width Constraint

AdjustmentID Number (5) Primary Key
Foreign Key (Primary Key –
ProductID Number (5)
Products(ProductID))
Foreign Key (Primary Key –
EmployeeID Number (5)
Employees(EmployeeID))
AdjustmentDate Date --
Adjustment
Number (5) --
Quantity
Reason Varchar2 (50) --

5
8. Orders

Field Names Datatype and width Constraint

OrderID Number (5) Primary Key
Foreign Key (Primary Key –
CustomerID Number (5)
Customers(CustomerID))
OrderDate Date --
TotalQuantity Number (5) --

EmployeeID Number (5) Foreign Key (Primary Key –

Employees(EmployeeID))
OrderStatus Varchar2 (25) --

9. OrderItems

Field Names Datatype and width Constraint

OrderItemID Number (5) Primary Key
Foreign Key (Primary Key –
OrderID Number (5)
Orders(OrderID))
Foreign Key (Primary Key –
ProductID Number (5)
Products(ProductID))
Quantity Number (5) --
UnitPrice (Rs.) Number (8) --

10. Invoices

Field Names Datatype and width Constraint

InvoiceID Number (5) Primary Key
Foreign Key (Primary Key –
OrderID Number (5)
Orders(OrderID))
InvoiceDate Number (3) --
TotalAmount
Number (8) --
(Rs.)

6
11. Payments

Field Names Datatype and width Constraint

PaymentID Number (6) Primary Key
Foreign Key (Primary Key –
InvoiceID Number (5)
Invoices(InvoiceID))
Foreign Key (Primary Key –
CustomerID Number (5)
Customers(CustomerID))
Foreign Key (Primary Key –
EmployeeID Number (5)
Employees(EmployeeID))
PaymentDate Date --
Amount (Rs.) Number (8) --
PaymentMethod Varchar2 (25) --

12. Returns

Field Names Datatype and width Constraint

ReturnID Number (6) Primary Key
Foreign Key (Primary Key –
CustomerID Number (5)
Customers(CustomerID))
Foreign Key (Primary Key –
OrderID Number (5)
Orders(OrderID))
Foreign Key (Primary Key –
EmployeeID Number (5)
Employees(EmployeeID))
ReturnDate Date --
TotalRefund
Number (8) --
(Rs.)

7
13. ReturnItems

Field Names Datatype and width Constraint

ReturnItemID Number (6) Primary Key
Foreign Key (Primary Key –
ReturnID Number (6)
Returns(ReturnID)
Foreign Key (Primary Key –
ProductID Number (5)
Products(ProductID))
Quantity Number (5) --
RefundAmount
Number (8) --
(Rs.)

14. SupplierOrders

Field Names Datatype and width Constraint

SupplierOrderID Number (6) Primary Key
Foreign Key (Primary Key –
SupplierID Number (5)
Suppliers(SupplierID))
OrderDate Date --
Foreign Key (Primary Key –
EmployeeID Number (5)
Employees(EmployeeID))
TotalAmount
Number (8) --
(Rs.)

15. SupplierOrderItems

Field Names Datatype and width Constraint

SupplierOrderItemID Number (6) Primary Key

Foreign Key (Primary Key –
SupplierOrderID Number (6)
Suppliers(SupplierOrderID))
Foreign Key (Primary Key –
ProductID Number (5)
Products(ProductID))
Quantity Number (5) --

UnitPrice (Rs.) Number (8) --

8
16. SupplierInvoices

Datatype and
Field Names Constraint
width
SupplierInvoiceID Number (6) Primary Key
Foreign Key (Primary Key –
SupplierOrderID Number (6)
Suppliers(SupplierOrderID))
Foreign Key (Primary Key –
SupplierID Number (5)
Suppliers(SupplierID))
InvoiceDate Date --

TotalAmount (Rs.) Number (8) --

17. SupplierPayments

Field Names Datatype and width Constraint

SupplierPaymentID Number (6) Primary Key
Foreign Key (Primary Key –
SupplierInvoiceID Number (6)
Suppliers(SupplierInvoiceID))
Foreign Key (Primary Key –
EmployeeID Number (5)
Employees(EmployeeID))
Foreign Key (Primary Key –
SupplierID Number (5)
Suppliers(SupplierID))
PaymentDate Date --

Amount (Rs.) Number (8) --

PaymentMethod Varchar2 (25) --

9
III. Entity Relationship Diagram

10
IV. Business Rules (Statements for the Entity Relationships)

1. Customers → Payments
i. (L-R), (1-M) – A customer can make multiple payments over time for various purchases.
ii. (R-L), (1:1) – Each payment is associated with a specific customer.

2. Customers → Orders
i. (L-R), (1:M) – A customer can place multiple orders over time.
ii. (R-L), (1:1) – Each order is placed by a specific customer.

3. Customers → Returns
i. (L-R), (1:M) – A customer can initiate multiple returns over time for various products or
orders.
ii. (R-L), (1:1) – Each return is initiated by a specific customer.

4. Orders → OrderItems
i. (L-R), (1:M) – An order can contain multiple order items.
ii. (R-L), (1:1) – Each order item is associated with a specific order.

5. Orders → Invoices
i. (L-R), (1:1) – An order generates exactly one invoice.
ii. (R-L), (1:1) – Each invoice is associated with a specific order.

6. Orders → Returns
i. (L-R), (1:M) – An order can lead to multiple returns.
ii. (R-L), (1:1) – Each return is linked to a specific order from which the returned items
originated.

7. Orders → Employees
i. (L-R), (1:1) – An order can be processed or fulfilled by one employee.
ii. (R-L), (1:M) – An employee can be responsible for processing or fulfilling multiple
orders over time.

8. Invoices → Payments
i. (L-R), (1:1) – An invoice can be settled by one payment.
ii. (R-L), (1:1) – A payment can be applied to one invoice.

11
9. Payments → Employees
i. (L-R), (1:1) – One payment is processed by one employee.
ii. (R-L), (1:M) – An employee can process multiple payments.

10. Returns → ReturnItems

i. (L-R), (1:M) – A return can include multiple return items.
ii. (R-L), (1:1) – Each return item is associated with a specific return request.

11. Returns → Employees

i. (L-R), (1:1) – A return is processed by one employee.
ii. (R-L),(1:M) – An employee can handle multiple returns requests.

12. OrderItems → Products

i. (L-R), (1:1) – Each order item corresponds to a specific product that is included in the
order.
ii. (R-L), (1:M) – A product can appear in multiple order items across different orders.

13. ReturnItems → Products

i. (L-R), (M:1)– Each return item is associated with a specific product that is being
returned.
ii. (R-L), (1:M) – A product can be represented in multiple return items across different
returns

14. Employees → Supplier Orders

i. (L-R), (1:M) – An employee can manage or handle multiple supplier orders.
ii. (R-L), (1:1) – A supplier order is placed by one employee.

15. Employees → Supplier Payments

i. (L-R), (1:M)– An employee can process or oversee multiple supplier payments.
ii. (R-L), (1:M)– A supplier payment can be managed or processed by one or multiple
employees.

16. Employees → Inventory

i. (L-R), (1:M) – An employee can insert multiple inventory records.
ii. (R-L), (1:1) – An inventory record is inserted by one employee at a time.

12
17. Employees → StockAdjustments
i. (L-R), (1:M) – An employee can insert multiple stock adjustment records.
ii. (R-L), (1:1) – One stock adjustment record can be inserted by one employee at a time.

18. SupplierOrderItems → SupplierOrders

i. (L-R), (1:1) – Each supplier order item is included in a specific supplier order.
ii. (R-L), (1:M) – A supplier order can include multiple supplier order items.

19. SupplierOrderItems → Products

i. (L-R), (1:1) – Each supplier order item corresponds to a specific product that is being
ordered from the supplier.
ii. (R-L), (1:M) – A product can be represented in multiple supplier order items across
different orders.

20. SupplierOrders → SupplierInvoices

i. (L-R), (1:1) – A supplier order can result in one invoice being issued.
ii. (R-L), (1:1) – Each supplier invoice is associated with a specific supplier order.

21. SupplierOrders → Suppliers

i. (L-R), (1:1) – A supplier order is associated with a specific supplier from whom products
or materials are being requested.
ii. (R-L), (1:M) – A supplier can receive multiple supplier orders from different companies
or from the same company over time.

22. SupplierPayments → SupplierInvoices

i. (L-R), (M:1) – Multiple supplier payments can be applied to a single supplier invoice,
particularly if the invoice is paid in installments.
ii. (R-L), (1:M) – Each supplier invoice can be settled by one or more supplier payments,
depending on the payment terms and amounts.

23. SupplierPayments → Suppliers

i. (L-R), (M:1) – Multiple supplier payments can be made to a single supplier for various
invoices or transactions.
ii. (R-L), (1:M) – A supplier can receive multiple payments from a company over time,
corresponding to different invoices or financial transactions.

13
24. SupplierInvoices → Suppliers
i. (L-R), (1:1) – Each supplier invoice is issued by a specific supplier and details the
products or services provided by that supplier
ii. (R-L),(1:M) – A supplier can issue multiple invoices to a company, representing
different transactions or orders.

25. Inventory → Products

i. (L-R), (1:1) – Each inventory record corresponds to a specific product, detailing the
quantity and location of the stock for that product.
ii. (R-L), (1:M)– A product can have multiple inventory records, representing different
quantities or locations where the product is stocked

26. StockAdjustments → Products

i. (L-R), (1:1) – Each stock adjustment is related to a specific product, detailing changes
made to the inventory levels for that product.
ii. (R-L), (1:M) – A product can be involved in multiple stock adjustments, reflecting
various changes to its inventory levels.

27. Products → Categories

i. (L-R), (1:1) – Each product is associated with a specific category.
ii. (R-L), (1:M) – A category can contain multiple products, grouping together items with
similar characteristics or types.

28. Suppliers → Products

i. (L-R), (1:M) – One supplier can supply multiple products.
ii. (R-L), (M:1) – One product can be supplied by multiple suppliers

14
V. Tables with valid values

1. Customers
CustomerID FirstName LastName RegistrationDate Email Phone
+123-345-
10001 Avanti Rai 10-01-2023 averai98@gmail.com
6423
+234-264-
10002 Prince Johnson 15-02-2021 princejohn@yahoo.com
4500
+345-783-
10003 Melissa Johnson 20-03-2024 melljoh@outlook.com
0231
+456-748-
10004 Ahmed Sayyed 05-04-2024 kgdavid5@live.com
1119

 CustomerID (PK): Unique identifier for each customer.

 FirstName: Customer's first name.
 LastName: Customer's last name.
 Email: Customer's email address.
 Phone: Customer's phone number.
 RegistrationDate: Date the customer joined.

2. Products

Price
ProductID ProductName Description CategoryID SupplierID
(Rs.)
20001 Kuru Toga M5-450T 0.5mm Black Lead 149 30001 50001
20002 Kokuyo Campus Semi B5 Dotted 7mm 377.50 30002 50002
20003 Kangaro Mini-10 Mini Metal Stapler 113.99 30003 50003
20004 Copic Markers 12pc Skintone Set 4299.89 30004 50004

 ProductID (PK): Unique identifier for each product.

 ProductName: Name of the product.
 CategoryID (FK): Links to the Categories table, indicating the category of the product.
 SupplierID (FK): Links to the Suppliers table, indicating who supplies the product.
 Price: Selling price of the product.
 Description: Description of the product.

15
 3. Categories

CategoryID CategoryName Description

30001 Mechanical Pencil Writing instruments
30002 Notebook Notebooks, paper
30003 Stapler General office items
30004 Marker Miscellaneous items

 CategoryID (PK): Unique identifier for each category.

 CategoryName: Name of the category.
 Description: Description of the category.

4. Employees

EmployeeID FirstName LastName Position HireDate Email Phone

+56789-
40001 Shruti Patil Manager 15-01-2020 patil67@company.com
34235
+67890-
40002 Kenneth Sebastian Sales Associate 20-02-2021 kenny@company.com
33532
+78901-
40003 Amani Ghassan Inventory Clerk 25-03-2022 amanigh@company.com
54983
+89012-
40004 Emily Vergara Cashier 30-04-2023 emily@company.com
56879

 EmployeeID (PK): Unique identifier for each employee.

 FirstName: Employee’s first name.
 LastName: Employee’s last name.
 Email: Employee's email address.
 Phone: Employee's phone number.
 Position: Job title of the employee.
 HireDate: Date the employee was hired.

16
 5. Suppliers

SupplierID SupplierName ContactName Email Phone Address

+988- 142,
Office Supplies
50001 Karen Jillens karen@officesupplies.com 4857- Eastwood
Co.
124 St., DA
+384- 983,
Paper Goods
50002 Yamini Pande yamini@papergoods.com 3847- Flanders
Ltd.
390 St., CN
+283- 98,
Writing Tools
50003 Jeremy Blue jeremy@writingtools.com 3480- Harvey
Inc.
169 St., OH
+239- 65, Stiple
50004 Stationery Hub Dayshah Ira dayshah@stationeryhub.com 8479- St., WY
984

 SupplierID (PK): Unique identifier for each supplier.

 SupplierName: Name of the supplier company.
 ContactName: Contact person at the supplier company.
 Phone: Supplier’s phone number.
 Email: Supplier’s email address.
 Address: Supplier’s address.

6. Inventory

InventoryID ProductID EmployeeID RecordedDate Quantity Location

60001 20011 40003 10-01-2024 269 Aisle 9
60002 20086 40045 15-02-2024 150 Aisle 3
60003 20043 40100 20-03-2024 88 Aisle 3
60004 20003 40056 05-04-2024 307 Aisle 4

 InventoryID (PK): Unique identifier for each inventory record.

 ProductID (FK): Links to the Products table, indicating the product in inventory.
 RecordedByEmployeeID (FK): Employee who inserted the inventory record.
 RecordDate: Date when inventory record was inserted
 Quantity: Quantity of the product in stock.
 Location: Location in the store where the product is kept.

17
 7. StockAdjustments

Adjustment
AdjustmentID ProductID EmployeeID AdjustmentDate Reason
Quantity
70001 20075 40001 20-02-2024 -10 Damaged product
70002 20005 40044 15-03-2024 50 New shipment
70003 20006 40253 10-04-2024 -6 Customer return
70004 20033 40044 05-05-2024 12 Restocked item

 AdjustmentID (PK): Unique identifier for each stock adjustment record.

 ProductID (FK): Links to the Products table, indicating the product being adjusted.
 EmployeeID (FK): Employee who inserted the stock adjustment record.
 AdjustmentDate: Date when the adjustment was made.
 AdjustmentQuantity: Amount by which the stock is adjusted (positive or negative).
 Reason: Reason for the stock adjustment (e.g., damaged goods, restocking).

8. Orders

OrderID CustomerID OrderDate TotalQuantity EmployeeID OrderStatus

80001 10056 15-02-2024 3 40087 Completed
80002 10073 20-03-2024 1 40064 Pending
80003 10088 25-04-2024 4 40045 Shipped
80004 10100 10-05-2024 3 40077 Delivered

 OrderID (PK): Unique identifier for each order.

 CustomerID (FK): Links to the Customers table, indicating who placed the order.
 OrderDate: Date when the order was placed.
 TotalAmount: Total amount for the order.
 EmployeeID (FK): Employee who processed the order.
 OrderStatus: Status of the order (e.g., pending, shipped, completed).

18
 9. OrderItems

OrderItemID OrderID ProductID Quantity UnitPrice (Rs.)

90001 80001 20001 3 149
90002 80002 20001 1 149
90003 80003 20003 2 113.99
90004 80004 20004 1 4299.89

 OrderItemID (PK): Unique identifier for each order item.

 OrderID (FK): Links to the Orders table, indicating the order this item belongs to.
 ProductID (FK): Links to the Products table, indicating the product ordered.
 Quantity: Quantity of the product ordered.
 UnitPrice: Price of a single unit of the product at the time of the order.

10. Invoices

InvoiceID OrderID InvoiceDate TotalAmount (Rs.)

100001 80099 16-02-2024 447
100002 80096 21-03-2024 149
100003 80057 26-04-2024 896.73
100004 80024 11-05-2024 4412.88

 InvoiceID (PK): Unique identifier for each invoice.

 OrderID (FK): Links to the Orders table, indicating the order associated with the invoice.
 InvoiceDate: Date when the invoice was issued.
 TotalAmount: Total amount of the invoice.

11. Payments

Employee Amount
PaymentID InvoiceID CustomerID PaymentDate PaymentMethod
ID (Rs.)
110001 100034 10089 4008 17-02-2024 447 Credit Card
110002 100007 10472 40094 22-03-2024 149 Cash
110003 104572 10064 40024 27-04-2024 897 Debit Card
110004 100753 10066 40009 12-05-2024 4413 PayPal

 PaymentID (PK): Unique identifier for each payment.

 InvoiceID (FK): Links to the Invoices table, indicating the invoice being paid.
 CustomerID (FK): Identifies the customer who made the payment.
 EmployeeID (FK): Employee who processed the payment.
 PaymentDate: Date when the payment was made.
 Amount: Amount of the payment.
 PaymentMethod: Method of payment (e.g., cash, credit card).

19
12. Returns

ReturnID CustomerID OrderID EmployeeID ReturnDate TotalRefund (Rs.)

120001 10023 80075 40001 01-03-2024 30
120002 10045 80057 40084 22-03-2024 242.50
120003 10067 80264 40008 29-04-2024 988
120004 10009 80078 40002 20-05-2024 4413

 ReturnID (PK): Unique identifier for each return.

 CustomerID (FK): Customer who wants to return the product.
 OrderID (FK): Links to the Orders table, indicating the order from which the return originated.
 EmployeeID (FK): Employee who processed the return.
 ReturnDate: Date when the return was processed.
 TotalRefund: Total amount refunded for the return.

13. ReturnItems

ReturnItemID ReturnID ProductID Quantity RefundAmount (Rs.)

130001 120005 20090 1 25
130002 120012 20002 1 15.50
130003 120053 20045 1 30.75
130004 120074 20004 5 50

 ReturnItemID (PK): Unique identifier for each return item.

 ReturnID (FK): Links to the Returns table, indicating the return to which this item belongs.
 ProductID (FK): Links to the Products table, indicating the product being returned.
 Quantity: Quantity of the product being returned.
 RefundAmount: Amount refunded for the returned product.

14. SupplierOrders

SupplierOrderID SupplierID OrderDate EmployeeID TotalAmount (Rs.)

140001 50001 01-02-2024 40075 10000
140002 50002 01-03-2024 40092 3000
140003 50003 01-04-2024 40045 450
140004 50004 01-05-2024 40034 2800

 SupplierOrderID (PK): Unique identifier for each supplier order.

 SupplierID (FK): Links to the Suppliers table, indicating the supplier for this order.
 OrderDate: Date when the order was placed with the supplier.
 EmployeeID (FK): Employee who placed the order with the supplier.
 TotalAmount: Total amount of the supplier order.

20
15. SupplierOrderItems

SupplierOrderItemID SupplierOrderID ProductID Quantity UnitPrice (Rs.)

150001 140094 20001 100 149
150002 140033 20033 50 60
150003 140054 20086 75 170
150004 140006 20098 150 900

 SupplierOrderItemID (PK): Unique identifier for each supplier order item.

 SupplierOrderID (FK): Links to the SupplierOrders table, indicating the order to which this item
belongs.
 ProductID (FK): Links to the Products table, indicating the product ordered from the supplier.
 Quantity: Quantity of the product ordered from the supplier.
 UnitPrice: Price per unit of the product from the supplier.

16. SupplierInvoices

SupplierInvoiceID SupplierOrderID SupplierID InvoiceDate TotalAmount (Rs.)

160001 140028 50001 05-02-2024 500
160002 140045 50002 05-03-2024 12000
160003 140003 50003 05-04-2024 4500
160004 140099 50004 05-05-2024 6080

 SupplierInvoiceID (PK): Unique identifier for each supplier invoice.

 SupplierOrderID (FK): Links to the SupplierOrders table, indicating the supplier order associated
with the invoice.
 SupplierID (FK): Supplier with whom the order was placed and invoice was issued.
 InvoiceDate: Date when the supplier invoice was issued.
 TotalAmount: Total amount of the supplier invoice.
 Description: This entity represents invoices from suppliers for the products ordered.

21
 17. SupplierPayments

Supplier
SupplierInvoice Amount
Payment EmployeeID SupplierID PaymentDate PaymentMethod
ID (Rs.)
ID
170001 160001 40001 50001 07-02-2024 500 Bank Transfer
170002 160002 40002 50002 07-03-2024 300 Credit Card
170003 160003 40003 50003 07-04-2024 450 Cash
170004 160004 40004 50004 07-05-2024 600 Bank Transfer

 SupplierPaymentID (PK): Unique identifier for each payment made to supplier.

 SupplierInvoiceID (FK): Links to the SupplierInvoices table, indicating the invoice being paid.
 EmployeeID (FK): Employee who supervised the payment.
 SupplierID (FK): Supplier to whom the payment was made.
 PaymentDate: Date when the payment was made to the supplier.
 Amount: Amount paid to the supplier.
 PaymentMethod: Method of payment (e.g., bank transfer, check).

End of Document

22