1. (10 points) Following is a text description of a relation:

PRESCRIPTION (PrescriptionID, Date, Drug, Dosage, CustomerID, CustomerName, CustomerPhone, CustomerEmail)

Assumption:

1. • A customer can have many prescriptions. A prescription belongs to only one customer.
1. list all functional dependencies

2. Describe the new table structure in the format of:

TABLE(PrimaryKey, ForeignKey (FK), Column, Column, ).