DATABASEENCAPSULATION.pptVIP

DATABASE ENCAPSULATION By: Devon Wright Sin-Min Lee Spring 2009 LAJENDA TECHNOLGIES Dental Practice Management IT work for dental practices Open Source Software: Open Dental C# Jordan Sparks was tired of paying $20,000 a year to use other software Topic: How to encapsulate classes around a database PATIENT TABLE Important Attributes: PatNum – Patient Number Lname – varchar Fname – varchar PatStatus - Inactive-0, patient-1, deceased-2, archieved-3, nonpatient-4 Birthdate - date Address – varchar Guarantor – PatNum who is responsible for account BalTotal – balance of account SQLyog Community