expert with programming applications and making database using SQL commands.

Hints: 1. It is a group assignment. Each group should have up to 3 students. 2. Cheating is not allowed in any circumstances. Any cheating or coping cases will be

considered as plagiarism. 3. Cheating and copied works will be rejected and Zero mark will be given to the student. 4. 10% of student mark will be deducted for any day of late up to 3 days, after that your

work will not be accepted.

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 (assignment 1 / 8%): Define and populate the database with some dummy data using SQL commands.

x You need to submit a print of all SQL commands used and a word file having all the commands.

PHASE 4 (assignment 2 / 12%): 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.

x A soft copy of the application should be submitted plus a print of the implementation code.

PHASE 5 (2 marks bonus): Java application should have the capability to insert more records into the database.