Am doing campus management system..in that for attendance module,for a student per month one column should be used..for the next month next entry has to be made in next row ..and so on...so that the number of entryies will be minimised & it will be easy to retrieve...can any one help me ut from here for this querry please...
Thanks in advance......
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35241
7
posted
0
That's a complete problem description (albeit lacking many details). Which part of this task are you having problems with? What do you have so far? If you haven't started, what ideas have you had?
You could use text column with 31 positions. One position per day.
Put in a '1' if the student attended, put in a '0' if the student was absent, on the position that matches the day.
If the student attended 1 to 3 september, and was absent on the 4th, you would get:
(disclaimer: I am not really a fan of composed columns, it's not quite as per the data normalization rules).
OCUP UML fundamental
ITIL foundation
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
