Assignment: HEALTH CARE DATABASE
Database specification:
The database will be like a repository of illnesses, symptoms, checkup results, physician opinions, given medicines, treatment plans, x-rays requested, and any other necessary information that may help researchers, physicians, pharmacists, health care developers, or anyone who is interested.
For each illness case, the database should contain information related to the hospital accepted the case, physicians treated the case and how it was treated, the result of the treatment and how long it took. The database should keep a record for each patient medical information and contacting address and numbers if needed.
PHASE 1:
Read the given database specification and draw up an ER diagram. You can make any necessary assumptions.
PHASE 2:
Map the ER diagram into relational database schema.
PHASE 3
Define and populate the database with some dummy data using SQL commands.
- You need to submit a print of all SQL commands used and a word file having all the commands.
PHASE 4
Create a small java application with a friendly user interface. Connect the application with your created database. The application supposed to be used to retrieve and display data from the database.
- A soft copy of the application should be submitted plus a print of the implementation code.
PHASE 5
Java application should have the capability to insert more records into the database.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- ERDiagram.rar