normalization - how to normalize my database -
i have table , don't know how normalize.
1st table name, address, landline no., mobile no., e-mail ad, amount, , registration number https://docs.google.com/file/d/0b99tebyt30n2ddvlvhv4du1yrfe/edit
and in second table monthly pledges. https://docs.google.com/file/d/0b99tebyt30n2tvh4c1dmltfyows/edit
looks ok me.
if first table user , second pledge, looks have one-to-many relationship between user , pledge. both tables should have primary key. pledge table have foreign key user table, foreign key column reference user primary key.
Comments
Post a Comment