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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!