By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,508 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,508 IT Pros & Developers. It's quick & easy.

Creating Database Tables in SQL Server, And I am developing School management System(

P: 1
I am New in Creating Database Tables in SQL Server, And I am developing School management System(Web based)and I design Attendance table Like




1.Frist class Attendance Table
2.Secound class Attendance Table
3.third class Attendance Table
4.fourth class Attendance Table
5.class Attendance Table
6.class Attendance Table
7.class Attendance Table
8.class Attendance Table
9.class Attendance Table
10.class Attendance Table

and also with Two Section(Section A, And section B),so total I have 20 Tables for Students Attends, so..i would like know this is correct way to design Database Tables for School management System (or)we can decrees tables. And also I created 20 tables for Marks entry and Fee Management

thanks for your time...let me know...

thanks for your supporting ...
Feb 3 '14 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,365
You only need one attendance table. It just needs fields to store the number of the class and the section.
Feb 3 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.