I am going to build a student management system application .In that i have to add batch,personal details,qualification,academic detail .Under these four option comes another 15 fields.How i can add and update these tables and how many tables i have to create?Itz really overwhelming . can someone give me an idea?
For the number of tables you need to create, you need to consider what will be in those tables, and how they relate to each other. Have a read up on “Database normalisation” which I believe is the term for this. Exactly how they should be arranged depends on the relationships, so it’s impossible to give a definitive answer without more information.
For example, and I am no expert on this, your “qualification” column sounds as if it is something that should have a table all of its own, and against each student you simply store the unique-id of each qualification - do not store the name of the qualification in each student record.
1 Like
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.