Scribd
Upload
10 views1 page

Database Report for Shop Transactions

The document outlines a scenario for managing a small shop's database that tracks customers, suppliers, and transactions. It specifies the main tables involved and details the requirements for a report requested by a company manager, which includes transaction details such as date, item name, quantity, total price, and names of the supplier and customer. The report aims to provide a comprehensive overview of each transaction in the database.

Uploaded by

Ayansa Ergiba
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
10 views1 page

Database Report for Shop Transactions

The document outlines a scenario for managing a small shop's database that tracks customers, suppliers, and transactions. It specifies the main tables involved and details the requirements for a report requested by a company manager, which includes transaction details such as date, item name, quantity, total price, and names of the supplier and customer. The report aims to provide a comprehensive overview of each transaction in the database.

Uploaded by

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

Practical Question

Scenario: You are managing a small shop’s database. The database tracks customers, suppliers,
and transactions. The database contains the following main tables:
A. Supplier (SupplierID, SupplierName, Address, Phone)
B. Customer (CustomerID, CustomerName, Phone, Location)
C. Transaction (TransactionID, SupplierID, CustomerID, ItemName, Quantity, UnitPrice,
TransactionDate)

Task: A company manager wants a report that shows each transaction, including:

 Transaction Date
 Item Name
 Quantity
 Total Price (Quantity × UnitPrice)
 Supplier Name
 Customer Name

You might also like