For each patient, the database keeps track of a patient ID number, name, address, and phone number. Not all patients will have insurance. For purposes of simplicity, only the primary insurance policy is recorded by the clinic. The patient's policy number is kept, along with an indication of whether the patient is the actual subscriber to the policy or a dependent of the subscriber. For each insurance company, the database keeps a unique ID number, as well as the company's name, the name of a contact person, the contact person's phone number, and the address to which claim forms should be sent.
Patients have appointments with dentists.
For each appointment, the date and time are recorded. For each dentist, a unique ID number, the dentist's name, and the examination room to which he or she is assigned is recorded.