Based on my ERD given below answere the following question

1. Drop existing tables and sequences first.

2. Create/Alter Statements for ALL Tables and Constraints. Include Primary Key, Foreign keys, and unique keys specified.

3. Create Indexes for Natural, Foreign Keym and Frequently Queried Columns.

4. Two Sequences, ideally for each PK column.

5. Two VIEWS (with good business value).

6. Two Triggers (with good business value).

 

Transcribed Image Text:

PATIENT MRN LNAME F_NAME DOB ADDRESS OCAN HAVE.. CAN HAVE PROVIDER PROV NUM NAME F_NAME DOB SSN CAN PRESCRIBE/CAN_BE_PRECRIBED PICKUP PICKUP NU MAN (FK) MED RX NUIFK REF DATE PICKUP AMT HHH MEDICATION MED RX NU MED_OTY REF AMT PROV_NUM(FK) PICKUP_NU(FK) -CAN HAVE CAN BE ACCESSED/CAN_ACCESS PHARMACIST PHARM D LNAME F NAME DOB ACT UC PATIENT MRN LNAME F_NAME DOB ADDRESS OCAN HAVE.. CAN HAVE PROVIDER PROV NUM NAME F_NAME DOB SSN CAN PRESCRIBE/CAN_BE_PRECRIBED PICKUP PICKUP NU MAN (FK) MED RX NUIFK REF DATE PICKUP AMT HHH MEDICATION MED RX NU MED_OTY REF AMT PROV_NUM(FK) PICKUP_NU(FK) -CAN HAVE CAN BE ACCESSED/CAN_ACCESS PHARMACIST PHARM D LNAME F NAME DOB ACT UC

Answer rating: 100% (QA)

As the question is a multipart database exercise based on an Entity Relationship Diagram ERD Ill provide you with a stepbystep solution for each part Before starting its important to note that the spe... View the full answer