Make the necessary corrections (revisions in given tables as well as addition of new tables) to the script in the file 'PostgreSQL-exe5-Erasmus' so that the following data are recorded in the database:

Data concerning hospitals, as follows

• Hospital code 100 corresponds to the hospital name AGIOS ANDREAS
• Hospital code 101 corresponds to the hospital name CHEST PATIENTS
• Hospital code 102 corresponds to the hospital name EVANGELISMOS
• Hospital code 104 corresponds to the AHEPA hospital name
• Hospital code 105 corresponds to the hospital name UNIVERSITY HOSPITAL OF RIO
• Hospital code 106 corresponds to the hospital name AGLAIA KYRIAKOU
• Hospital code 107 corresponds to the hospital name KARAMANDANEIO
• Hospital code 109 corresponds to the name of the hospital PAPANIKOLAOU

Data relating to patients, as follows

• Patient code 30 corresponds to the last name CHRISTOPOULOS and the first name SPYRIDON
• Patient code 31 corresponds to the last name GOTSOPOULOS and the first name VASILIS
• Patient code 37 corresponds to the last name SAKOPOULOS and the first name EVANGELOS

Data concerning doctors, as follows

• Doctor code 1 corresponds to the last name GEORGOPOULOS and the first name GEORGIOS
• Doctor code 2 corresponds to the last name PAPALOUKOPOULOS and the first name IOANNIS
• Doctor code 12 corresponds to the surname VALSAMIDIS and the name STAVROS

Data concerning examinations, as follows

• Test with code 1000 has description GENERAL BLOOD TESTS
• Examination with code 1001 has description ARTHROSCOPY
• Examination with code 1010 has description BRAINGRAPH

Data concerning diagnoses, as follows

• Diagnosis with code 1000 has description 'CHOLESTEROL-TRIGLYCERIDES'
• Diagnosis with code 1010 has description "NON-SHORT-CIRCUITED NEURONS"

Data concerning specific patient visits, as follows

• A visit with code 301 is made by a patient with code 30 at the hospital with code 100 on a date of your choice
• A visit with code 311 is made by a patient with code 31 at the hospital with code 101 on a date of your choice
• A visit with code 371 is made by a patient with code 37 at the hospital with code 106 on a date of your choice

Data concerning examinations of specific patients, as follows

• During the patient visit with code 301, the examination with code 1000 performed on a date of your choice had a result of 'GOOD')
• During the patient visit with code 311, the test with code 1001 performed on a date of your choice had a result of 'MODERΑΤΕ')

Data concerning specific patient diagnoses, as follows

• During the visit with code 301, there was a patient diagnosis with code 1000 on a date of your choice with the comment 'LIGHT DIET' by the doctor with code 1
• During the visit with code 311, there was a patient diagnosis with code 1001 on a date of your choice with the comment 'NO SALT IN THE FOOD' by the doctor with code 2
• During the visit with code 371, there was a patient diagnosis with code 1010 on a date of your choice with the comment 'Exercise' by the doctor with code 1