COSC 471/571 WINTER 2019 hw0110 Design and implement simple database in Base Distributed: 10 January 2019 Due: 17 January 2019 A snake oil salesman, Mr Hooch, decides he wants a database to keep track of his inventory of nostrums. Mr Hooch mixes up each nostrum himself. For each elixer he wants to know: name of elixer amount in inventory For each ingredient, he wants to know: name of ingredient date acquired from vendor amount in inventory For each vendor, he wants to know: name address (location) Each elixer is made out of one or more ingredients. Each ingredient can be used to create one or more nostrums. Each ingredient is supplied by exactly one vendor. Each vendor can supply many ingredients. (1) Design a database of four or five tables. (2) Populate the database with this current information: - Earl in Kentucky supplies 80 proof ethyl alcohol - Francoise in New Orleans supplies 60 proof brandy - Karl in Milwaukee supplies beer - Dr Bronner in Southern California supplies: codeine morphine lavender oil eucalyptus oil - Dr Aesclepius in Carson City supplies camphor Mr Hooch's recipes are: (1) To invigorate the nerves (Nerve Repair) 5 mg codeine 100 ml ethyl alcohol 2 ml eucalyptus oil (2) cough remedy (No Cough): 5 mg codeine 100 ml ethyl alcohol 2 ml camphor (3) female troubles (Troubles-Be-Gone): 5 mg codeine 100 ml ethyl alcohol 2 ml lavender oil (4) male troubles (Buck-up Buddy): 5 mg codeine 100 ml ethyl alcohol 2 ml eucalyptus oil 2 ml camphor (5) pet troubles (Good Poochy): 5 mg codeine 100 ml ethyl alcohol Mr Hooch's current inventory is: 1000 ml ethyl alcohol 1/1/1936 1000 ml brandy 1/2/1936 5000 ml beer 1/3/1936 100 ml codeine 1/4/1936 100 ml morphine 1/5/1936 50 ml lavender oil 1/6/1936 50 ml eucalyptus oil 1/7/1936 50 ml camphor 1/8/1936 500 ml (1) Nerve Repair 500 ml (2) No Cough 500 ml (3) Troubles-Be-Gone 500 ml (4) Buck-up Buddy 500 ml (5) Good Poochy (3) Write queries: a. What ingredients go into Good Poochy? b. What is the current inventory for the ingredients in Good Poochy? c. Who supplies ingredients for Good Poochy? d. Where are the suppliers for beer located? e. Where are the suppliers for ingredients in Troubles-Be-Gone located? f. What ingredients are in both Buck-up Buddy and No Cough? g. What is the oldest ingredient in his inventory and what is that date? (4) Turn in: Hard copy of tables and contents (screen shots are fine) Hard copy of queries and the results of the queries (again, screen shots are ok). _