I have a homework, where I should create a database for a dental clinic using MySQL Workbench. This database will be used later for a web app for dentists.
Here is a picture of the database design:
Contain login information for dentists (it may be used by multiple dentists online)
The id_logged column is a foreign key of the id of logged in dentists, and it should be in all tables. (To let dentists see only their own patient info and details).
The patient_id column is a foreign key too. And it is taken from patient table and used as foreign key in med_history that represents the general medical information of the patients, patient_info that represents the general information, and the reason of visit and what tasks to do, and in the appointment table.
I have 2 questions:
1- Is there more than that information to add for a dentist database?
2- Is this database correct? Or are there errors?