Gift Shop Project Documentation

Software Development: Graded Unit 2
Gift shop Project Documentation

John Carlo Obaob

Initial Investigation
Project Brief
The project will be about a Gift Shop database system. Because transaction records on papers can be lost or tampered, a simple yet effective and functional shop database system can be of use. This can also reduce the overall cost for managing the records that is paper based. This type of database system can be more secured and easy to manage.
Because paper based database have limited physical storage space and the records can be very messy. Manually searching throughout the records can take time so is sorting every record. It is also difficult to make a backup of every record page, another copy also means extra
Add item category
d. Add item date
2. Add customer
a. Add customer’s first name
b. Add customer’s last name
c. Add customer’s login name
d. Add customer’s login password
e. Add customer’s number
f. Add customer’s email
g. Add customer’s address
i. Add address’s building number ii. Add address’s building name iii. Add address’s street iv. Add address’s town
v. Add address’s post code
3. Add payment details
a. Add payment method type
b. Add payment status
4. Add Order details
a. Add order id
b. Add order date
c. Add order price
d. Add order quantity
b. Processes
1. Search items
a. Search item by name
b. Search item by price
c. Search item by category
d. Search item by date added
2. Update item
a. Update item’s name
b. Update item’s price
c. Update item’s category
d. Update item’s added date
3. Update customer’s details
a. Update customer’s name
b. Update customer’s orders
c. Update customer’s building number
d. Update customer’s building name
e. Update customer’s street
f. Update customer’s town
g. Update customer’s post code
h. Update customer’s payment method
4. Update Order details
a. Update order id
b. Update order date
c. Update order price
d. Update order quantity
5. Remove Order record
6. Remove item record
7. Remove customer