Question: Task 1 You have to create an Entity Relationship Diagram for a Healthcare Organisation. You can create the submission document using any tool that you

Task 1 You have to create an Entity Relationship Diagram for a Healthcare Organisation. You can create the submission document using any tool that you like (Visio, Excel sheet, Word Document etc.); you don't have to create the actual tables in the database for this assignment. A. Create 4 tables to store information about i. Patients Visits to the Hospital iii. Tests ordered for each patient iv. Test results for each patient ii. B. Create appropriate columns for each table. You can create as many columns as you want in each table to store the information. C. Create the necessary Primary Keys and Foreign Key Relationships in the ERD. The use of other constraints is optional
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
