Create the schema for the Health Center ER diagram.

Use the following types and sizes for attributes:

a. DoctorID: char

4 b. DoctorName: varchar 40

c. Specialization: varchar 20

d. DateVisited: date

e. PatientID: char 4

f. PatientName: varchar 40

g. InsuranceCo: varchar 40

3) Create SQL code for the Health Center Schema.

4) Create a database called hw. In this hw database, run the SQL code generated in Question2, to create Doctor, Visiting and Patient tables using DBeaver.

5) Enter imaginary three doctors, four patients and six visits in your tables. Make sure one doctor name is your name.