good practices of creating tables in mysql Hi I was thinking of developing an web apllication using php and mysql.
Application will give a professor the required data about the student.

i want to design application considering Engineering college.

So professor can view topper in perticular branch,overall topper in college,search student by roll no,display the list of students i roll no order or on the basis of percentage

Overalll data will consist of

Student name,roll no,year,percentage,department name,marks in each subject,subject name,branch

So please guide me to create table for the same in mysql..

thanks in anticipation
I once asked for answers to a problem very similar to yours, and even though I think back on how frustrated I was after a Software Architect did it to me, now, as a much wiser developer, I give the same answer to you. 


  Database Design for Mere Mortals: 2nd Edition
  (2003) by  Michael J. Hernandez. There is also a  Database Design for Mere
  Mortals: 3rd Edition
  (2013) by the same author.



 -- Come back in a couple years as a database engineer, then give someone else the same answer.