A Dental Clinic requires a computerized system to automize its front office operations
that support the following functionalities:
? Query support
? Report generation
? Easy input facility for new data
? Update necessary details about the latest available facilities, Charges for various
procedures/treatments, details of the timings, Doctors/Dentists, staff etc..
Perform the following tasks:
(i) Draw the ER diagram by identifying the entities, relationships and cardinality by
using any of the drawing tools like smartdraw, dia, visio, conceptdraw etc.. to
manage this Dental Clinic. Follow proper conventions.
(ii) Create suitable database to support/accommodate all the functionalities referred
above. Perform Normalization till required NF and prepare Normalized tables.
(iii) Using MS-Access, design various forms to support the Dental Clinics? front
office operations such as enquiry form, patient-registration, appointment?s
management, to display various facilities available at the clinic, Details of the
Dentists, Charges for various procedures/treatments, Discounts/Offers (if any),
staff details, list of phone numbers, etc..
(iv) Report generation like daily reports of the patients visited for consultation, list of
complaints on equipment (if any), staff attendance, Charges collected on a
particular day etc..