some one has asked to help him in building a small database for patients in a small rural health center.
sample we start building patients information in first table like DOB name phone number etc.
any help will be great guys.
Novice
Windows XP 
Access 2007
some one has asked to help him in building a small database for patients in a small rural health center.
sample we start building patients information in first table like DOB name phone number etc.
any help will be great guys.
Last edited by paradox_nz; 04-26-2009 at 09:15 PM.
Administrator
Windows 10 Access 2013 32bit
Here's some links for your BookMarks in no particular order:
Fundamentals of Relational Database Design -- r937.com
http://www.accessmvp.com/strive4peac...Chapter_03.pdf
3 Normal Forms Database Tutorial
Description of the database normalization basics
Normalization
Novice
Windows XP Access 2007
thanks alot man very good stuff. however is that an answer to the question. thanks again
Last edited by paradox_nz; 04-26-2009 at 09:15 PM.
Administrator
Windows 10 Access 2013 32bit
That sounds more like a homework or test question and I do not do either.
Novice
Windows XP Access 2007
that ok man i understand. but i am sorry to bother you again i have this answer to the question can just tell if i am at the right track.
Last edited by paradox_nz; 04-26-2009 at 09:17 PM.
Administrator
Windows 10 Access 2013 32bit
You *never* want to duplicate data in a RDBMS if possible. Foreign keys yes, but *never* the data. It is rarely necessary to create two tables that have a 1:1 relationship. Generally you just put the fields all in the same table. There is a limit to how many fields are allowed in a record (255 I think for Access).
Posting Permissions
Reply With Quote