Part 2: In this assignment, your task is to model a snack distributer database. The database contains information about a number of different snack types: Skittles, Animal crackers and Trail mix. All snacks must have a unique identifier (Universal Product Code or UPC), a name and a number of calories in a package - these attributes are non-optional and must be specified for every snack in the database. The particular snacks also have some additional information that only applies to them. Skittles information always includes a flavor name, and a value entry for each color that may appear in the package. Animal cracker listing has to include an expiration (ie, "best-before") date. Trail mix description has to include the estimated average packaged volume and a listing of (possibly several) allergy codes that may be applicable. Note that we also allow selling snacks that do not currently belong to any category (temporarily, until they are assigned their own category). All snacks are sold to us by different distributors. There are no exclusive contracts of any sort - any distributer can provide any number of snacks and vice-versa. Each snack distributer has a unique id that can be used to look them up. Moreover, the distributers provide a 1-800 number for all customer service issues. In some cases, snack distributers do not offer retail services - in that case they bulk-sell only to other distributers rather than directly to us in that case we do not know which snacks are being sold, just which distributers deal exclusively with other distributers). We keep track of this information so that we can escalate any health alerts to the original distributer(s). Part 2: In this assignment, your task is to model a snack distributer database. The database contains information about a number of different snack types: Skittles, Animal crackers and Trail mix. All snacks must have a unique identifier (Universal Product Code or UPC), a name and a number of calories in a package - these attributes are non-optional and must be specified for every snack in the database. The particular snacks also have some additional information that only applies to them. Skittles information always includes a flavor name, and a value entry for each color that may appear in the package. Animal cracker listing has to include an expiration (ie, "best-before") date. Trail mix description has to include the estimated average packaged volume and a listing of (possibly several) allergy codes that may be applicable. Note that we also allow selling snacks that do not currently belong to any category (temporarily, until they are assigned their own category). All snacks are sold to us by different distributors. There are no exclusive contracts of any sort - any distributer can provide any number of snacks and vice-versa. Each snack distributer has a unique id that can be used to look them up. Moreover, the distributers provide a 1-800 number for all customer service issues. In some cases, snack distributers do not offer retail services - in that case they bulk-sell only to other distributers rather than directly to us in that case we do not know which snacks are being sold, just which distributers deal exclusively with other distributers). We keep track of this information so that we can escalate any health alerts to the original distributer(s)