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

Popular posts from this blog

java - How to specify maven bin in eclipse maven plugin? -

Error while updating a record in APEX screen -

c++ - In an add-in in Excel, written in C(++), how does one get the name of the function which called into the addin? -