Draw the er diagram by identifying the entities

Reference no: EM13338944

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..

Reference no: EM13338944

Questions Cloud

What is the angular velocity of the rotating tires : A truck with 0.420 m radius tires travels at 34 m/s. What is the angular velocity of the rotating tires in radians per second

Mips assembly program : MIPS Assembly Program: Help writing this function

Compute the impulse imparted to the hammer : When a hammer strikes a nail, it is compressed along its length. What is the impulse imparted to the hammer

Create the logic for a program that accepts input values : Create the logic for a program that accepts input values for the projected cost of a vacation and the number of month until vacation. Pass both values to a method that displays the amount you must save per month to achieve your goal.

Draw the er diagram by identifying the entities : Draw the ER diagram by identifying the entities, relationships and cardinality by using any of the drawing tools like smartdraw, dia, visio, conceptdraw

The average degree for vertices distributed uniformly : Given the number of vertices n and the target expectation d of the average degree for vertices distributed uniformly on the surface of the unit radius sphere, determine a formula for the threshold r such that a random geometric graph on a spher..

How far should you go to reach the treasure in paces : You might think that it is never a good approximation to ignore air resistance. However, often it is. How far should you go to reach the treasure in paces

Estimate the acceleration of the blocks : A block of mass m1 = 21.5kg and a block of mass m2 = 5.50kg are connected by a massless string over a pulley in the shape of a solid disk having radius R = .250m, Determine the acceleration of the blocks

What is the linear data structure : what is the linear data structure ? Give example .Describe how an array is represented.

User Account

All Pages