Which database for school MIS?

Discussion in 'Mac Apps and Mac App Store' started by jacg, Mar 28, 2008.

  1. jacg macrumors 6502a

    jacg

    Joined:
    Jan 16, 2003
    Location:
    UK
    #1
    I wonder if anyone can advise me on databases? I'd like to create a data management information system for a small school, mainly for the collation and printing of grades and academic reports. I'd like it to have a browser-based front end so it can be used by Windows users and Mac users with no installed database software.

    What tools do I need? I've used Filemaker before (but I'd need to upgrade from my current v7 I think). Or would MySQL be a possibility? Can I use the school network server (Windows server2003) or would I need a separate box (Win/Linux/Mac?).

    If it sounds like I am out of my depth, please bear with me. Any advice, info or links would be greatly appreciated.
     
  2. Koreos macrumors member

    Joined:
    Mar 4, 2008
    #2
    IMO simplest would be MySQL, maybe you could just create a php website, that way it would be accessed by macs and windows without any compatibility problems. I've set up MySQL servers on my own computer before so I guess you could use your school's server.
     
  3. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #3
    You are out of your depth. School management systems are not starter projects. Apple used to sell one, which it subsequently sold to Pearson IIRC. The data are only part of the concerns of a database developer. Even more important are quality control and security. There are probably legal standards governing the type of system you want. In this case, your only legal options may be commercial packages. Your first step should be to contact several of your peer institutions to see what they are using. Your school will have invest some of its resources into a license that fits its needs.
     
  4. live4ever macrumors 6502a

    Joined:
    Aug 13, 2003
    Location:
    Thunder Bay, ON

Share This Page