Opensource Student Timetabling database software for school - advice needed

In summary, the conversation is about a person seeking advice on building an open source student timetabling database software for a school. They are familiar with C/C++ programming but not with SQL or databases. They are considering using Linux and the GTK toolkit for the GUI, but are open to learning new tools. They are also looking for alternatives to Microsoft SQL Server, such as MySQL.
  • #1
maverick280857
1,789
4
Opensource Student Timetabling database software for school -- advice needed

Hi,

I intend to build a computer program with a GUI, for a school setup consisting of the following primary features:

1. Student information database (particulars of students, subjects they are registered in, etc)
2. Class information database (list of students in a class; each class may have several sections, e.g. there may be 4 sections of grade 4: A through D)
3. Fee information database (fee structure for each term (like a semester))
4. Report card generation

The program would be open source. I know there are several programs available on the net to do this, but I want to make one instead of using any of those.

Now, the problem is that while I am familiar with C/C++ programming, I don't know much about SQL or databases. Also, since a GUI frontend is necessary, I don't know how I should go about doing this in Linux -- I suppose I have to use gtk or xlib or something similar. I am not familiar with GUI programming in Linux, but I am willing to learn.

Would it be a better idea to make it in Windows instead? I don't want to get into SQL Server (Microsoft) or Access for databases, but I am guessing there are no other alternatives if I intend to use Visual Basic?

I am willing to learn whatever tools are required to work on this problem, but I am not very clear about what I need.

Any suggestions and pointers will be highly appreciated.

Thanks!

(To the Moderator -- Please shift this to the appropriate forum if this isn't the place for it.)
 
Technology news on Phys.org
  • #2


I've done some GUI programming in a Linux environment. I had the choice of using either the GTK+ or Qt toolkits. Eventually I chose GTK because of license it falls under. Not to also mention that I don't like the way QT widgets look. I would not advice you to use Xlib directly. What you should do is use a toolkit (like GTK) to interface with the X server. Also using toolkits will give much better flexibility and ease of programming.

Since you're going open source, you might as well use all open source components and forget the headache of licensing. MySQL over Microsoft SQL Server is a great alternative.
 
  • #3


Thanks ranger, I'll get started with GTK then.
 

1. What is open-source software and why is it beneficial for student timetabling?

Open-source software is a type of computer program that is freely available for anyone to use, modify, and distribute. In the context of student timetabling, open-source software allows schools to access and customize the timetabling database without having to pay for expensive proprietary software. It also encourages collaboration and innovation within the education community.

2. How do I determine which open-source student timetabling database software is best for my school?

There are a few factors to consider when choosing open-source student timetabling software. Firstly, look for a software that is user-friendly and has a clear documentation or user guide. It is also important to consider the features and customization options that the software offers, as well as its compatibility with your school's existing systems. Reading reviews and seeking recommendations from other schools can also be helpful.

3. Can open-source student timetabling software handle complex timetabling needs?

Yes, many open-source student timetabling software have advanced algorithms and features that can handle complex timetabling needs, such as accommodating different class sizes, teacher availability, and subject requirements. However, it is important to thoroughly test the software and consult with the developers to ensure it can meet your school's specific needs.

4. Are there any security concerns with using open-source student timetabling software?

Open-source software is generally considered to be just as secure as proprietary software, if not more so. This is because it is constantly being reviewed and improved by a large community of users and developers. However, as with any software, it is important to regularly update and maintain the security of your open-source student timetabling database to prevent any potential vulnerabilities.

5. Can open-source student timetabling software integrate with other school management systems?

Yes, many open-source student timetabling software have the ability to integrate with other school management systems, such as student information systems and learning management systems. This allows for seamless communication and data sharing between different systems, making the timetabling process more efficient and accurate.

Similar threads

I could really use some help picking my optional module [GameDev]
    • STEM Academic Advising
Replies
2
Views
878
Programs I want to enroll in a beginning programming course
    • STEM Academic Advising
Replies
12
Views
1K
Physics Lost undergrad looking for advice on career path and grad school
    • STEM Career Guidance
Replies
5
Views
856
Admissions Need advice on how realistic my graduate school prospects are
    • STEM Academic Advising
Replies
8
Views
1K
Advice: Doing grad school abroad and getting a masters instead of PhD
    • STEM Academic Advising
Replies
15
Views
2K
Advice for an Undergraduate: What to do after I finish my Physics/Math double-major BS degrees?
    • STEM Academic Advising
Replies
10
Views
1K
Studying Advice for succeeding in graduate school?
    • STEM Academic Advising
Replies
7
Views
858
Courses What upper division undergrad courses for CS?
    • STEM Academic Advising
Replies
5
Views
1K
Admissions Need advice for Low GPA / Good Research / HEPth PhD application
    • STEM Academic Advising
Replies
26
Views
1K
From software development to physics PhD
    • STEM Academic Advising
Replies
2
Views
979

Hot Threads

Recent Insights

Back
Top