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).

 

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