Rough File

DATABASE PROJECT

Phase – 1

Group name: “Neophytes”

Group members:

1. Sidhant Kumar K13-2099

2. Chandras K13-2075

3. Deepak Raj K13-2147

Domain:

We are intended to design a database for a finding a doctor where users can find doctor by searching with their name or by specialty.

There will be two users for this application one will doctor and a patient/other.

1. Doctor: Doctor will register him/herself with following information.

* Each Doctor has a unique ID, name, gender, age, email, qualification (multivalued e.g. MBBS, FCPS, etc.), specialty (single valued), picture (optional), contact number.

* More than one doctor can relate to a single specialty.

* Doctor can also edit his/her information like timing.

Hospital: Hospital has following information.

* Hospital has a name, hospital number (for uniqueness), address (near, area, city), and phone number.

* Doctor-hospital

* A Doctor can work at more than one hospital.

* A Doctor has different timing of working days in each hospital.

* And also fees structure will be defined. (doctor may have different fees in different hospital

2. Patient/other: He/she can search the doctor by doctor's name or Specialty.

* When the customer will choose to search by doctor's name he/she will be shown all the doctors names and when he/she will select one particular doctor all the information about that doctor will be shown.

* And when the customer will choose to search by specialty, the list of specialties will be opened and which particular specialty he/she will select, all the doctors related to that specialty will be shown.