Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

closed as not constructive by Jack Douglas Apr 7 '13 at 16:05

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

I'm closing this for the same reason it was closed on SO—it isn't a good fit for this Q&A format. I suggest you read up on the subject and come back with particular specific answerable questions. – Jack Douglas Apr 7 '13 at 16:05

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.

share|improve this answer
@nikhil This question has also several good links: Needing A Database Design Book Since you may already have some database theory book, I suggest the SQL-Antipatterns for some serious analysis of what not to do in a design (and also because the author works with MySQL mainly). – ypercubeᵀᴹ Apr 6 '13 at 8:38

Not the answer you're looking for? Browse other questions tagged or ask your own question.