## Scientists

id | firstName | lastName | birthDate
--- | --- | --- | ---
1 | John | Smith | 1970-01-01
2 | Jane | Doe | 1980-02-02

## Companies

id | name | location
--- | --- | ---
1 | MedTech Inc. | New York, USA
2 | Health Innovations Ltd. | London, UK

## MedicalDevices

id | deviceName | description | price
--- | --- | --- | ---
1 | Glucose Monitor | Monitors blood glucose levels | 99.99
2 | Heart Rate Sensor | Measures heart rate | 69.99

## DeviceDevelopment

scientistId | companyId | medicalDeviceId | startDate | endDate
--- | --- | --- | --- | ---
(→ Scientists.id) | (→ Companies.id) | (→ MedicalDevices.id) |  |
1 | 1 | 1 | 2021-01-01 | 2021-12-31
2 | 2 | 2 | 2020-01-01 | 2020-12-31

## Patients

patientId | firstName | lastName | dateOfBirth | gender
--- | --- | --- | --- | ---
1 | Michael | Johnson | 1990-01-01 | M
2 | Emily | Williams | 1995-02-02 | F

## Appointments

appointmentId | doctorId | patientId | date
--- | --- | --- | ---
| (→ Doctors.id) | (→ Patients.patientId) |
1 | 1 | 1 | 2022-01-01 10:00:00
2 | 2 | 2 | 2022-02-02 14:00:00

## Doctors

doctorId | firstName | lastName | specialty
--- | --- | --- | ---
1 | Dr. Alice | Brown | Cardiology
2 | Dr. Charles | Green | Neurology