1. A database system is to be designed for a medical diagnostic lab. The following E-R diagram shows this <img src='./qimages/11444-1.jpg'>

A sample is given by only one patient, however, many samples can be given by one patient for different test. Sample type may be assumed to be "blood", "urine" or "tissue". Perform the following tasks for the given E-R diagram: Design and implement normalised relations/tables for the E-R diagram. You should include primary key, validation checks and referential integrity constraints in your implementation. Enter 5-6 sets of meaningful data in every table that you have, created in part Design and implement the following forms/queries/reports for the database system created as above:
Create two forms one for entering patient information and other for entering sample information.

(ii) List the name of all the patients whose telephone number is "2225556785".

(iii) List the Patient-ID, name and test_required for all the patients whose sample_type is "blood".

(iv) Create a datawise reports of samples received. It should include date of test, Sample_ID and test_required fields. List the "Possible diseases" due to which tests are required. The list should not have duplicate values.