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.

1.2. This question contains a brief UoD that provides contextual information regarding a system ororganisation. 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 maynote assumptions on your ER diagram. However, please beware that your assumptions must not conflictwith or violate any aspects of the UoD.In a busy medical facility, individuals are treated and identified by a unique code, and their names andhome addresses are kept on record. There are two types of individuals, one who stays in the facility andis assigned a room number (Inpatient), and the other who visits the facility and is given a date for theirnext 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 uniqueidentifiers and specialty fields. These professionals are involved in the administration of varioustreatments, each of which is given a unique code, a name, and a detailed description. A treatment canbe administered by a health professional to an individual at a given date and time.

Assuming Mr. Moi only wants a database system that would keep records of medicine{names ofmedicine, amount in grams in stock}, purchase{medicine bought, amount in grams bought, whoattended to customer, when it was sold, contact and name of customer that bought the medicine}a. Draw a normalized ER diagram with only the most important data from question 1 bearing in _mind the information that Mr. Moi wants.

Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted.

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. On a large online retail platform, different users can log in using their unique identifiers and shop for various items. Each of these items comes with a unique identification code, name, price, and detailed description. Users, apart from their unique identifiers, also provide their name, email, and shipping address. These users can make multiple purchases on different dates, with each transaction assigned an identification code unique to the user, along with recording the date of the transaction and the total cost. Each transaction can consist of one or more items, and the same item could be part of various transactions made by the same or different users.

Thank you for your interest in our job opening. As a next step, we are expecting you to complete a short assignment. Kindly find the assignment details [PLEASE SUBMIT THE GITHUB REPOSITORY LINK , There should be proper readme to setup and run the software] Requirements : • Creation of an application to manage patients in a hospital • The hospital administrator has to add, remove, update and list the patients in the hospital . For example if a patient is admitted , the details need to be added. • If the patient’s status to covid negative status to be updated • If a patient is discharged ,the patient needs to be deleted . • If the administrator wants to see the status of patients s/he should be able to see the same . Expectation • Working application . • Web interface to input data • Data should be stored in database • Well documented code with readme • Github link of the working application . • The repo should have proper readme so that we can execute the same. • We expect the application to RESTFUL and implement CRUD operations. • You can choose Java/GOLANG for backend and javascript for front end.