MySQL Forums
Forum List  »  Newbie

Medical Database HELP!
Posted by: Damir Colo
Date: January 18, 2016 05:00PM

hello all, if there is anyone that could help me with this i would be really thankful

Task:
You need to create a medical records database containing following information:
• Patient data (First name, Last name, Date of birth, Complete Address)
• Assigned doctor data (First name, Last name, Specialization field)
• Specific medication treatment recevied by the patient from the assigned doctor
Reports to generate
• Number of specific medications given to all patients grouped by medication.
• All patients located in the same city with assigned doctor (First name, Last name from both doctors and the patients)

Limitations: Doctor can have no more than 5 patients, Patients can have only one doctor assigned, and no more then 10 medications can be prescribed to the patient.

Options: ReplyQuote


Subject
Written By
Posted
Medical Database HELP!
January 18, 2016 05:00PM
January 18, 2016 05:34PM
January 18, 2016 05:41PM
January 22, 2016 06:41PM
January 19, 2016 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.