Create tables based on the below given relational model.
Define your own data type to the attributes and apply your own constraints to the attributes
Identify the primary, foreign keys apply it to the attributes.
Populate the data in all the tables using SQL commands/queries.
- Hospital tables:
patients (patient-id, name, insurance, date-admitted, date-checked-out)
doctors (doctor-id, name, specialization)
test (testid, testname, date, time, result)
doctor-patient (patient-id, doctor-id)
test-log (testid, patient-id) performed-by (testid, doctor-id)