Scientists

idfirstNamelastNamebirthDate
1JohnSmith1970-01-01
2JaneDoe1980-02-02

Companies

idnamelocation
1MedTech Inc.New York, USA
2Health Innovations Ltd.London, UK

MedicalDevices

iddeviceNamedescriptionprice
1Glucose MonitorMonitors blood glucose levels99.99
2Heart Rate SensorMeasures heart rate69.99

DeviceDevelopment

scientistIdcompanyIdmedicalDeviceIdstartDateendDate
(→ Scientists.id)(→ Companies.id)(→ MedicalDevices.id)
1112021-01-012021-12-31
2222020-01-012020-12-31

Patients

patientIdfirstNamelastNamedateOfBirthgender
1MichaelJohnson1990-01-01M
2EmilyWilliams1995-02-02F

Appointments

appointmentIddoctorIdpatientIddate
(→ Doctors.id)(→ Patients.patientId)
1112022-01-01 10:00:00
2222022-02-02 14:00:00

Doctors

doctorIdfirstNamelastNamespecialty
1Dr. AliceBrownCardiology
2Dr. CharlesGreenNeurology