Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahimam_2004
Starting Member
40 Posts |
 Posted - 2008-02-06 : 13:19:21
|
| Hi,I have information like this: Apllicant information: Firstname, Lastname, Address, Phone, SSN, county, workphone..Each applican can earn 3 certificates:1st Certificate 2nd certificate 3rd certificate Status of certification Status of certification Status of certification Status of dues Status of dues Status of dues Certification# Certification# Certification# Validation date Validation date Validation date Renewal date Renewal date Renewal date Effective date Effective date Effective date Date of cert # changed > means earned the next(second or third certificate). These don’t have this column information These don’t have this column information Some common information for all 3 certificates like NOTE,…Certification information look like this:[url]http://img231.imageshack.us/img231/6056/certrw3.gif[/url]How to organize the above information in SQLServer tables. how to apply the normalization . I can store all the contact information in one table and put the SSN as primary key. How to organize the certificates into tables? I have to made 3 tables for 3 certificates and linked to contact information table.Thanks in advance |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-02-06 : 14:28:19
|
| At the most I would see you using 2 tables ( table1 = Applicant information, table2 = Certification information with fk on table1 pk ). You could get away with using a single table depending on how all your data relates ( based on your application Im assuming there is additional data other than what youre specifically asking about here ) and how you intend your application to work with the data. |
 |
|
|
|
|
|
Organize into tables