For the first version of the store management system, we want to start with the following user stories:
- As a user, I want to add a new product into the system.
- As a user, I want to add a new customer into the system.
- As a user, I want to add a purchase from a customer into the system.
Tasks:
Write two possible use cases for each user story: one is the common case and one is the exception.
2. Design the screens (UI windows and widgets) the system should display in each use case.
Case1
Case2
3. Design the database physically and prepare data for the tables, with at least 5 products, 5 customers, and 10 purchases.
Design see database
Products
ProductID
Int
Name
Text
Price
Real
Quantity
Real
create table Products
(
ProductID int not null
constraint Products_pk
primary key,
Name text,
Price real,
Quantity real
);
Customers
CustomerID
Int
Name
Text
Phone Number
Text
Address
Text
create table Customers
(
CustomerID int not null
constraint Customers_pk
primary key,
Name text,
Phone text,
Address text
);
Purchases
PurchaseID
Int
CustomerID
Text
ProductID
Text
Price
Text
Quantity
Real
Cost
Real
Tax
Real
Total
Real
Date
Text
create table Purchases
(
PurchaseID int not null
constraint Purchase_pk
primary key,
CustomerID int,
ProductID int,
Price real,
Quantity real,
Cost real,
Tax real,
Total real,
Date text
);
4. Implement the use cases.
5. Test the system with each use case.
https://youtu.be/IwTxJ1a_ycw
