Currently i doing dental appointment website for my lessons, and i having problem in database design. The major of the database is for appointment booking and view information.
Admin doing the registration for patient, admin, dentist.
Patient login > view dentist > view appointment > make appointment or view treatment comment
Dentist login > insert patient treatment comment / view appointment
Admin > view appointment > Delete appointment and others stuff like report
While creating the dental user table, should i include the dentist into dental user table?Should i create 1 more table for registration ?
I having problem in linking all the table ..Kindly if you could help me in giving suggestion / ideas. Thank you.
Dentist ID (Primary Key)
Dentist Contact Number
Dentist Job Description
Appointment ID (Primary Key)
Dentist ID (Foregin Key)
Dental User Table
Identification Card Numner
View Complete Post