Description
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