Convert the following ER diagram into a relational schema:

SSN SSN Age Specialty Year_of expiration Address Patient HAS Doctor Name Name Date PRESCRIBE Quantity Phone Namenumber Formula Pharmaceutical 1 Drug MADE Trade ame Company SELL Price Supervisor CONTRACT Pharmacy Start date Text Name End date Phone Number Address