A small dentist practice requires a database system to manage patient records,

appointments, and treatments. The main objective is to store data efficiently while

maintaining data integrity and avoiding redundancy. The system must keep track of

patients, dentists, appointments, and treatment details.

Business Rules:

$1.$ Patient Information:

o Each patient must have a unique Patient ID$.$

o Each patient record includes the patient's name, address, phone

number, and date of birth.

o A patient can have multiple appointments, but each appointment is

associated with one patient.

$2.$ Dentist Information:

o Each dentist must have a unique Dentist ID$.$

o Each dentist record includes the dentist's name, specialty, and phone

number.

o A dentist can perform multiple treatments, and a treatment can be

performed by only one dentist.

$3.$ Appointment Information:

o Each appointment must have a unique Appointment ID$.$

o Each appointment is scheduled for one patient and one dentist.

o An appointment includes date, time, and duration.

$4.$ Treatment Information:

o Each treatment must have a unique Treatment ID$.$

o Each treatment record includes the treatment type, cost, and

description.

o A patient may receive multiple treatments during a visit, and a

treatment can be administered to multiple patients.

$5.$ Relationships:

o A patient can have many appointments, but an appointment is

associated with only one patient.

o A dentist can have many appointments, but an appointment is A small dentist practice requires a database system to manage patient records,

appointments, and treatments. The main objective is to store data efficiently while

maintaining data integrity and avoiding redundancy. The system must keep track of

patients, dentists, appointments, and treatment details.

Business Rules:

$1.$ Patient Information:

o Each patient must have a unique Patient ID$.$

o Each patient record includes the patient's name, address, phone

number, and date of birth.

o A patient can have multiple appointments, but each appointment is

associated with one patient.

$2.$ Dentist Information:

o Each dentist must have a unique Dentist ID$.$

o Each dentist record includes the dentist's name, specialty, and phone

number.

o A dentist can perform multiple treatments, and a treatment can be

performed by only one dentist.

$3.$ Appointment Information:

o Each appointment must have a unique Appointment ID$.$

o Each appointment is scheduled for one patient and one dentist.

o An appointment includes date, time, and duration.

$4.$ Treatment Information:

o Each treatment must have a unique Treatment ID$.$

o Each treatment record includes the treatment type, cost, and

description.

o A patient may receive multiple treatments during a visit, and a

treatment can be administered to multiple patients.

$5.$ Relationships:

o A patient can have many appointments, but an appointment is

associated with only one patient.

o A dentist can have many appointments, but an appointment is

associated with only one dentist.

o A treatment can be associated with many patients, and a patient can

receive many treatments.

associated with only one dentist.

o A treatment can be associated with many patients, and a patient can

receive many treatments.