This appears to be a detailed set of requirements for designing a database for Newark Medical Associates (MMA). The requirements cover various aspects including Clinic personnel, surgeries, patients, medications, illnesses, and more. To summarize and outline the major points:

System Requirements Summary:

• Clinic Person: Different roles including physicians, surgeons, nurses, and support staff.
  • Capture information about clinic employees, including physicians, surgeons, and nurses.
  • Include details such as name, gender, address, telephone number, position, salary (for non-surgeons), specialty (for physicians), contract type and length (for surgeons), grade, and years of experience (for nurses).
  • Maintain a unique employment number for each employee.
  • Nurses should have a grade and years of experience.

• Surgeries and Schedules: Surgeons, surgery types, operation theatre details, nurse assignments based on surgery types and skills.
  • Record information about different surgery types performed at the clinic.
  • Store surgery codes, names, categories (hospitalization or outpatient), anatomical locations, and special needs.
  • Maintain a list of surgery skills required for each surgery type.
  • Surgeons have specific surgery skills, and their skills should be mapped to surgery types.
  • Keep track of surgery schedules, including the surgeon, patient, operation theatre, and surgery date.
  • Assign nurses to specific surgery types, ensuring that at least two nurses are available for each surgery type.
  • Manage the association of nurses with surgery types based on their skills.
  • Surgery Categories:
    • Categorize surgeries as either requiring hospitalization (category H) or as outpatient procedures (category O).

• Patients: Personal and medical data, illnesses, allergies, medications, admission information, and monitoring parameters like cholesterol levels and categorize heart disease risk.
  • Record information about patients, including personal data (name, gender, date of birth, address, telephone) and medical data (blood type, cholesterol levels, blood sugar, allergies).
  • Each patient must have at least one illness.
  • Maintain a unique patient number (identifier).
  • Illnesses and Medications:
    • Track various illnesses and medications.
    • Store codes and descriptions for illnesses.
    • Manage medications, including name, quantity, unit cost, and interactions with other medications.
  • Prescription: Track medications, prescriptions by physicians to patients, and medication interactions.

• Capture information about medications prescribed to patients by physicians.
• Include details like dosage, frequency, and prescription date.
• Ensure that no two physicians prescribe the same medication to the same patient.

• In-patient:
• Manage admission date, nursing units, rooms, and beds for in-patients.

• Ownership and Corporate Information: Medical corporations with ownership interest, their headquarters, and percentage ownership in the clinic.

give me power point presentation

*Introduction

*Objectives

*Concepts & Fundamentals