Which are entities of a patient data base in a doctor's office which has one doctor?*1 pointpatient, doctorpatient, visitdoctor, sicknesspatient, office

Considering the tables of the Hospital database given below, identify candidate keys, primarykeys, and foreign keys. Also, give an example of derived attributes for patient and doctor.patients (patient-id, name, Date of Birth, insurance, date-admitted, date-checked-out)doctors (doctor-id, NIC, name, date of birth, specialization)test (testid, test_name, date, time, result)doctor-patient (patient-id, doctor-id)test-log (testid, patient-id)performed-by (testid, doctor-id)

Based on the business rules provided, there are six relationships in the database: 1. Doctor to Patient: A doctor can have multiple patients. This is a one-to-many relationship. 2. Doctor to Appointment: A doctor can have multiple appointments. This is a one-to-many relationship. 3. Patient to Appointment: A patient can make multiple appointments. This is a one-to-many relationship. 4. Appointment to Invoice: Each appointment has one invoice. This is a one-to-one relationship. 5. Invoice to Payment: Each invoice has one payment. This is a one-to-one relationship. 6. Surgeon to Surgery Note: Each surgery done by a surgeon has a surgery note. This is a one-to-one relationship. what title can i give to each relation

This question contains a brief UoD that provides contextual information regarding a system or organisation. You will need to create an Entity Relational (ER) diagram, or Extended Entity Relational (EER) diagram based on the UoD. If the UoD is unclear regarding specific aspects of the brief you may note assumptions on your ER diagram. However, please beware that your assumptions must not conflict with or violate any aspects of the UoD. In a busy medical facility, individuals are treated and identified by a unique code, and their names and home addresses are kept on record. There are two types of individuals, one who stays in the facility and is assigned a room number (Inpatient), and the other who visits the facility and is given a date for their next appointment (Outpatient). Additionally, the medical facility keeps medical records for all patients. Each record is associated with a unique number, the date it was created, and a diagnosis. The medical facility also maintains a detailed catalog of health professionals, each with their unique identifiers and specialty fields. These professionals are involved in the administration of various treatments, each of which is given a unique code, a name, and a detailed description. A treatment can be administered by a health professional to an individual at a given date and time.

Details such as a unique ID, name, and address need to be stored for every doctor. There are two types of doctors: GPs and Surgeons. For a GP, the Years of Experience are recorded while the area of expertise is stored for the surgeon. • For every patient, the details such as a unique patient ID, name, and address are recorded. • A patient can make multiple appointments. For every appointment, a unique appointment ID, time, and reason is recorded. There are two types of appointments: Consultation and Surgery. Duration is stored for consultation while type is stored for surgery. • Surgery appointments are done by Surgeons while Consultation appointments are done by GPs. When a surgeon does the surgery appointment, a surgery note is recorded. • An invoice is created for every appointment. Details such as a unique invoice number, date, and amount are recorded for every invoice. • A single payment is made for every invoice. Split payments are not allowed. For every payment, a unique payment code, amount paid, and date of payment are stored in the databases.

A type of healthcare professional who can deliver health services, but who works under the supervision of primary care physicians, is a(n) _____