Question: 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
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?
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?
Step by Step Solution
★★★★★
3.45 Rating (152 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Drop table patient cascade constraints Drop table medication cascade constraints Drop table prescrip... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Document Format (1 attachment)
887-CS-DB (2223).docx
120 KBs Word File