FYP Final Report v1.0.0 
 
Copyright and All Rights Reserved To: Pee-Lo Team @2003/04 
 
38
 
 
 
 
 
 
 
 
 
 
 
Table 5: Data Dictionary for tblHealthRecord Table 
 
 
 
 
 
 
 
 
 
 
 
Table 6: Data Dictionary for tblHealthCare Table 
 
Figure 10 on the following page is a snapshot of the ER Diagram of our database.  The ER 
Diagram is created by SQL Server. 
 
In Appendix C, we will show you how to attach/detach a database in SQL Server.  This is very 
important to us since it enables us to localize the database onto a local workstation and gives us 
the flexibility to work at different time and place.  LIM, Cheng Yong had compiled the whole 
attach/detach procedure in Appendix C as reference to curious readers.