Write a report showing the design principles and basic ideas. List all entities and attributes. State all pros and cons of the E-R diagram. Can you do a query that'll display the result when a patient will undergo surgery with a pacemaker or when the hospital needs new components or a query that will display how the hospital checks their inventory to see if they have enough components and if they don't display how they order from the manufacturer.

Hospital Procedure PURCHASE PK Purchase_ID Product Quantity Total Enacts OPERATION PK Operation ID FK Surgeon_ID Quantity Price PATIENTS PK Patient_ID FK Hospital_ID undergoes HOSPITAL PK Hospital ID Name Address Stays in Phone Uses Maintains INVENTORY PK Product ID FK Manufacturer_ID Purchase Price Purchase_Date Catagory Location HOSPITAL BED PK Hospital Bed ID FK Patient ID EK Operation ID FK Hospital_ID Admission Time MANUFACTURER PK Manufacturer_ID FK Product ID Name Country Phone COMPONENT PK Product_ID System (Y/N) Product Description Price Discount (Y/N) Product Category Has/Addech -Creates- Is Billed 0 Mandatory, And- BILLING PK Billing_ID FK Purchase_ID Patient ACCT Total ACCESSORIES LEADS Lead Voltage_Type Lead_Voltage_Type Accessories Description Accessories_Description PACEMAKER SYSTEM Pacemaker Voltage Type Pacemaker_Voltage_Type Hospital Procedure PURCHASE PK Purchase_ID Product Quantity Total Enacts OPERATION PK Operation ID FK Surgeon_ID Quantity Price PATIENTS PK Patient_ID FK Hospital_ID undergoes HOSPITAL PK Hospital ID Name Address Stays in Phone Uses Maintains INVENTORY PK Product ID FK Manufacturer_ID Purchase Price Purchase_Date Catagory Location HOSPITAL BED PK Hospital Bed ID FK Patient ID EK Operation ID FK Hospital_ID Admission Time MANUFACTURER PK Manufacturer_ID FK Product ID Name Country Phone COMPONENT PK Product_ID System (Y/N) Product Description Price Discount (Y/N) Product Category Has/Addech -Creates- Is Billed 0 Mandatory, And- BILLING PK Billing_ID FK Purchase_ID Patient ACCT Total ACCESSORIES LEADS Lead Voltage_Type Lead_Voltage_Type Accessories Description Accessories_Description PACEMAKER SYSTEM Pacemaker Voltage Type Pacemaker_Voltage_Type