December 2017
Beginner to intermediate
470 pages
12h 29m
English
Let's start from the most simple scenario we can imagine and try to find any potential problems we may encounter. For each sale, we would like to have the following variables, the sales DATE, the COST for producing that type of food, the QUANTITY bought, the PRICE for the type food, whether or not we applied a DISCOUNT, the macronutrient percentages for CARBS (carbohydrates), PROTEIN, and FAT, the PROTEIN_SOURCE of the food (either FISH, CHICKEN, BEEF, or VEGETARIAN, if the person does not eat meat), the STORE where it was sold, the DELIVERY method (either send TO LOCATION or deliver IN STORE), the STATUS of the sale, which can be PENDING, DELIVERED, RETURNED, or CANCELLED (a sale can't have two statuses at the same time), ...