How to Design proper tables . I know how to design tables but which is need for the perfect table?
for ex:My question is for a table need Primary key, foreign key further which option need for the table
I am asking normally for a table we set primary key and foreign key which those things
additional need for table because in future my data may be large amount so i need fetch data quickly so i need proper design tables so any one guide me
how to create proper tables with constraints,indexing etc give sample for this