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 OPERATION PURCHASE PK Purchase ID Product Quantity Total Enacts: PATIENTS PK Patient ID FK Hospital_ID PK Operation_ID FK Surgeon_ID Quantity Price Undergoes HOSPITAL PK Hospital_ID Name Address Phone Stays in Uses Maintains INVENTORY PK Product_ID FK Manufacturer_ID Purchase_Price Purchase_Date Calagory Location HOSPITAL BED PK Hospital Bed ID FK Patient_ID FK 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 -HasAdded Creates Is Bild 0 Mandatory, And BILLING PK Billing_ID FK Purchase_ID Patient_ACCT Total LEADS Lead_Voltage_Type Lead Voltage Type ACCESSORIES Accessories_Description Accessories Description PACEMAKER SYSTEM Pacemaker_Voltage_Type Pacemaker Voltage Type