Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

need a help ,any one make it soon

 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai friends...

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......
 
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Bartender
Posts: 2658
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic