This repository is for the subject, CSIT327 - Information Management 2.
Currently in the works
Store Prices by Steemp
Entities with their assigned columns
Customer : [custID{PK}, custFname, custLName,isMember{Boolean}]
Item : [itemID{PK}, itemName, itemQuantity, itemPrice]
Order : [orderID{PK}, itemID{FK}, custID{FK}, orderQuantity, orderTotalPrice]
Guide (Not Final)
Customer can order many items
If Customer is Member, Customer can have 5% discount on items the customer bought
??