Guidelines for vour answer a Indicate the primary key and the foreign key(s) of each relation clearly in your answer b. Non-indication or incorrect indication of PKs and FKs will result in a loss of 1 point for each PK and each FK in c. each table d. Do NOT make up any fields of your own to suit your answer Question 1. Assume that you are involved in a database design project for a pharmacy. Your client has identified the following attributes of PRESCRIPTION that need to be stored in the database. Group those attributes into a relational database structure making sure that each relation in the database is in 3NF PRESCRIPTION (CUST#, CUST-NAME, CUST-PHONE, DRUG-NAME, DRUG- MANUFACTURER, DRUG-UNITS- PURCHASED, DRUG-COST-PER-UNIT, PURCHASE DATE, INSURANCE-NAME, INSURANCE-ADDRESS) Semantics: I. Customer numbers (CUST#) are unique, ie., no two customers can have the same customer number. ach customer has onl y one phone number on record 3. Drug names are unique, i.e., no two drugs can have the same name 4. A given drug manufacturer can manufacture many different drugs but a given drug with a specific name can be made by only one manufacturer A given customer can purchase more than one drug. The same drug can be purchased by more than one customer A customer can purchase the same drug on different dates, but not the same drug more than once on the same day DRUG-UNIT-PURCHASED refers to the quantity of a particular drug purchased by a customer NSURANCE-NAME refers to the customer's insurance company, and a given CUST# can be associated with only one insurance company 5. 6. 7. 8. 9