Convert the EERD into a database in MS SQL Server. prepare a New database in the name
Question:
Convert the EERD into a database in MS SQL Server.
- prepare a New database in the name (Childcare Hospital_group6)
- Do tables and add attributes according to your EERD
- Ensure your tables are normalized
- Identify right data types for each attribute
- Identify and add SQL Server constraints where necessary (NOT NULL, NULL, Primary Key, Foreign Key, UNIQUE, CHECK, Default, IDENTITY/Auto increment)
- Insert at least 3 data values in each table
- Execute and Save the SQL Scripts.
- Sreenshot your Database diagram and attach it along with the scripts.
Additional Notes
Client and provider:
The client and provider are made up of several entities, including a doctor, the hospital management department, a pharmacy, insurance, and so on.
Healthcare organization is one, which serves treatments, and the client is the patient who gets the health organization's treatment services.
Health Profile/Condition:
When a patient arrives at the hospital, doctor review their medical history. The importance of acquiring a patient's medical history cannot be overstated when making a provisional diagnosis; based on this information, they can suggest diagnostic testing for the patient. In order to make an accurate diagnosis, it is crucial to do physical examinations, biological examinations, radiographic examinations, and pathological examinations.
Today, every hospital offers a range of insurance plans and collaborates with a range of insurance companies. Every hospital has OPD and IPD departments, and doctor guidance types of services including Outreach services and supplemental services are offered according on patient conditions. The hospital will provide medical care to the patient in accordance with the insurance plan. Laser therapy and internet consulting are currently causing individuals to worry.
Health Care Plan is something which rely on patient's health condition. Each person's method to treating the illness is unique. If the patient's health improves, the same course of treatment can be continued; if not, healthcare professionals will look into other options. Wellness centres are playing a bigger role in encouraging patients to stick with their treatment plans.
Insurance provider/policy:
Government and private insurers have created measurement programmes with the goal of assessing and enhancing hospital quality. Examples include quality ratings that aid patients and insurance plans in choosing which hospitals to use as well as the exclusion of specific hospitals from offering treatments depending on quality. Over the past ten years, health insurers have experimented with benefit structures that promote healthy behaviour.
Health Services including Billing details:
Interaction between a patient and a healthcare provider is necessary for the delivery of healthcare services or the assessment of a patient's health status. As a result, the patient can ask any questions, and the provider can respond with clear answers and detailed explanations of better care and financial matters. Long-term patient health monitoring is its primary objective.
It has outcomes, observations, and follow-up care. When the course of treatment is finished, the patient can schedule her or his first follow-up session. The patient will be given instructions regarding the intervals at which the patient will need to be seen.