The series of tasks in this exercise is based on the following ER diagram and its associated logical schema.
a. Write appropriate CREATE TABLE statements for the logical schema. Be sure to define all appropriate constraints.
b. Write an ALTER TABLE statement to add to the MEDICATION table the attribute unit cost that represents the per unit cost of the medication. The unit cost of a medication can range from $0.50 to $7.50.
c. Write an ALTER TABLE statement that imposes the business rule that the list price of a medication must be at least 20 percent higher than its unit cost.
d. Write an ALTER TABLE statement to drop the occupation attribute from the PATIENT table?