database on student information management system

Question

database on student information management system

hlsc1983

SSCommitted

Points: 1971
More actions
October 20, 2015 at 6:22 am

#305782

hi, I have come so far. Now i need to know something. In the Subjects table , I have columns for four types of marks(THPA, THET, PRPA, PRET) for each subject. However there are some subjects for which we dont have all four types of marks. In other words for some subjects, the students are given only two or three types of marks, say THPA ,THET and PRPA . Whereas some other subjects students are alloted only two types, say THET and PRET. How can i account for this in the database table? or I have to take care of this in my front end in VB.net?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Probably best if you keep this within the same thread, that way people can see everything that's already been discussed.

http://www.sqlservercentral.com/Forums/Topic1523529-391-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

hlsc1983 SSCommitted Points: 1971 More actions · Answer 2

GilaMonster (10/20/2015)
Probably best if you keep this within the same thread, that way people can see everything that's already been discussed.
http://www.sqlservercentral.com/Forums/Topic1523529-391-1.aspx

hi, i did but i am not getting any response there. I thought that thread was dead.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

hlsc1983 (10/20/2015)
GilaMonster (10/20/2015)
Probably best if you keep this within the same thread, that way people can see everything that's already been discussed.
http://www.sqlservercentral.com/Forums/Topic1523529-391-1.aspx
hi, i did but i am not getting any response there. I thought that thread was dead.

This forum is manned by volunteers. We offer our assistance on our free time which means you could have to wait a while for a response, or maybe not. Unless an admin locks a thread, you can continue to post to it. That's why old threads some times become active after years of inactivity.