Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8
  1. #1
    Regular Coder
    Join Date
    Dec 2005
    Posts
    217
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question about school management system ??

    Hello gr8 PHP coders over there...............
    I am building a school management system...which includes the following.....
    >student profile
    >teachers profile
    >progess report(mark sheets)
    >classes
    >subjects
    Can anybody give me a clear idea about school management system..so that mistakes are known in advance by helping me in the database design.....em would be very greatful if anybody would give the related database design.....
    Anyways thanks all of u for reading my post.....

  • #2
    Regular Coder
    Join Date
    Dec 2004
    Location
    Manchester, UK
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

  • #3
    Senior Coder chump2877's Avatar
    Join Date
    Dec 2004
    Location
    the U.S. of freakin' A.
    Posts
    2,746
    Thanks
    18
    Thanked 155 Times in 146 Posts
    what kind of database are you using...MySQL?

    and what do you want us to tell you? Why don;t you check out some online tutorials on creating content management systems, and on database design...

    PHP CMS tutorial: http://www.php-mysql-tutorial.com/cms-php-mysql.php

    I just Googled for that, there are plenty more if you search for something like "PHP CMS tutorial"
    Regards, R.J.

    ---------------------------------------------------------

    Help spread the word! Like my YouTube-to-Mp3 Conversion Script on Facebook !! :)
    [Related videos and tutorials are also available at my YouTube channel and on Dailymotion]
    Get free updates about new software version releases, features, and bug fixes!

  • #4
    Regular Coder
    Join Date
    Dec 2004
    Location
    Manchester, UK
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts
    A scool MIS is quite different to a CMS. There are LOTS of standards in place that you should be aware of. Whoever gave you the project should know these so do some research around them using schoolforge and looking at existing systems.

    FYI: I develop IRIS http://www.iris.ac/

  • #5
    Senior Coder chump2877's Avatar
    Join Date
    Dec 2004
    Location
    the U.S. of freakin' A.
    Posts
    2,746
    Thanks
    18
    Thanked 155 Times in 146 Posts
    Quote Originally Posted by d11wtq
    A scool MIS is quite different to a CMS. There are LOTS of standards in place that you should be aware of. Whoever gave you the project should know these so do some research around them using schoolforge and looking at existing systems.

    FYI: I develop IRIS http://www.iris.ac/

    I'm curious what kinds of standards are there? do you have a link? I'd like to check them out...
    Regards, R.J.

    ---------------------------------------------------------

    Help spread the word! Like my YouTube-to-Mp3 Conversion Script on Facebook !! :)
    [Related videos and tutorials are also available at my YouTube channel and on Dailymotion]
    Get free updates about new software version releases, features, and bug fixes!

  • #6
    New to the CF scene
    Join Date
    Jun 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    http://www.opensourcecms.com look under e-Learning

  • #7
    New to the CF scene
    Join Date
    Dec 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Why reinvent wheel. Take a look at moodle.org it is a great e-learning system and is used to run the whole of the OU in the UK

  • #8
    Regular Coder
    Join Date
    Dec 2005
    Posts
    217
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question is this database perfect or not ??..please help/guide me

    Hello frens over there N senior sirs....
    I had designed a database which i had shown below.....
    I dont know is that perfect or not .....Please help/guide me to make the database perfect so that i could start coding.....
    Here goes the database
    PHP Code:
    CREATE TABLE `tb_academic_year` (
      `
    ay_idint(255NOT NULL auto_increment,
      `
    academic_yrvarchar(255NOT NULL default '',
      
    PRIMARY KEY  (`ay_id`)
    );

    INSERT INTO `tb_academic_yearVALUES (1'2061');
    INSERT INTO `tb_academic_yearVALUES (2'2062');

    CREATE TABLE `tb_class` (
      `
    class_idint(255NOT NULL auto_increment,
      `
    class_levelvarchar(255NOT NULL default '',
      `
    sectionenum('A','B','C','D'NOT NULL default 'A',
      `
    class_room_novarchar(255NOT NULL default '',
      `
    tr_idint(255NOT NULL default '0',
      `
    ay_idint(255NOT NULL default '0',
      `
    tot_studentsint(255NOT NULL default '0',
      
    PRIMARY KEY  (`class_id`)
    );

    CREATE TABLE `tb_exam_type` (
      `
    et_idint(255NOT NULL auto_increment,
      `
    et_rankenum('1','2','3'NOT NULL default '1',
      `
    et_namevarchar(255NOT NULL default '',
      
    PRIMARY KEY  (`et_id`)
    );


    INSERT INTO `tb_exam_typeVALUES (1'1''FirstTerm');
    INSERT INTO `tb_exam_typeVALUES (2'2''SecondTerm');
    INSERT INTO `tb_exam_typeVALUES (3'3''FinalExam');


    CREATE TABLE `tb_routine` (
      `
    rt_idint(255NOT NULL auto_increment,
      `
    class_idint(255NOT NULL default '0',
      `
    rt_dayenum('SUN','MON','TUE','WED','THU','FRI'NOT NULL default 'SUN',
      `
    rt_period_rankenum('1','2','3','4','5','6','7','8'NOT NULL default '1',
      `
    sub_idint(255NOT NULL default '0',
      `
    rt_timevarchar(255NOT NULL default '',
      `
    tr_idint(255NOT NULL default '0',
      
    PRIMARY KEY  (`rt_id`)
    );

    CREATE TABLE `tb_score` (
      `
    score_idint(255NOT NULL auto_increment,
      `
    st_idint(255NOT NULL default '0',
      `
    exam_typeint(255NOT NULL default '0',
      `
    sub_idint(255NOT NULL default '0',
      `
    scoreint(255NOT NULL default '0',
      `
    remarksvarchar(50NOT NULL default '',
      
    PRIMARY KEY  (`score_id`)
    );


    CREATE TABLE `tb_score_alternative` (
      `
    socre_idint(255NOT NULL auto_increment,
      `
    st_idint(255NOT NULL default '0',
      `
    exam_typeint(255NOT NULL default '0',
      `
    sub_id_setvarchar(255NOT NULL default '',
      `
    mo_setvarchar(255NOT NULL default '',
      `
    remarks_setvarchar(255NOT NULL default '',
      `
    percentageint(255NOT NULL default '0',
      `
    resultenum('P','F'NOT NULL default 'P',
      
    PRIMARY KEY  (`socre_id`)
    );


    INSERT INTO `tb_score_alternativeVALUES (161'1,2,3,4,5,6''70,70,70,70,70,70''Good,Good,Good,Good,Good,Good'70'P');


    CREATE TABLE `tb_student` (
      `
    st_idint(255NOT NULL auto_increment,
      `
    class_idint(255NOT NULL default '0',
      `
    com_idint(255NOT NULL default '0',
      `
    st_rollint(255NOT NULL default '0',
      
    PRIMARY KEY  (`st_id`)
    );


    CREATE TABLE `tb_student_details` (
      `
    com_idint(11NOT NULL auto_increment,
      `
    st_fnamevarchar(100NOT NULL default '',
      `
    st_mnamevarchar(100NOT NULL default '',
      `
    st_lnamevarchar(100NOT NULL default '',
      `
    genderenum('M','F'NOT NULL default 'M',
      `
    st_emailvarchar(200NOT NULL default '',
      `
    dobvarchar(255NOT NULL default '',
      `
    st_fathervarchar(255NOT NULL default '',
      `
    st_mothervarchar(255NOT NULL default '',
      `
    st_perm_addresstext NOT NULL,
      `
    st_temp_addresstext NOT NULL,
      `
    st_contact_novarchar(255NOT NULL default '',
      `
    joined_datedatetime NOT NULL default '0000-00-00 00:00:00',
      `
    left_datedatetime NOT NULL default '0000-00-00 00:00:00',
      
    PRIMARY KEY  (`com_id`)
    );

    CREATE TABLE `tb_subject` (
      `
    sub_idint(255NOT NULL auto_increment,
      `
    class_levelint(255NOT NULL default '0',
      `
    sub_namevarchar(255NOT NULL default '',
      `
    sub_fmint(255NOT NULL default '0',
      `
    sub_pmint(255NOT NULL default '0',
      
    PRIMARY KEY  (`sub_id`)
    );


    CREATE TABLE `tb_teacher` (
      `
    tr_idint(255NOT NULL auto_increment,
      `
    tr_fullnamevarchar(255NOT NULL default '',
      `
    tr_emailvarchar(255NOT NULL default '',
      `
    tr_genderenum('M','F'NOT NULL default 'M',
      `
    tr_qualificationvarchar(255NOT NULL default '',
      `
    tr_jobtypevarchar(255NOT NULL default '',
      `
    tr_perm_addresstext NOT NULL,
      `
    tr_temp_addresstext NOT NULL,
      `
    tr_contact_novarchar(255NOT NULL default '',
      `
    tr_joined_datedatetime NOT NULL default '0000-00-00 00:00:00',
      `
    tr_left_datedatetime NOT NULL default '0000-00-00 00:00:00',
      
    PRIMARY KEY  (`tr_id`)
    );


    CREATE TABLE `tb_user` (
      `
    user_idint(255NOT NULL auto_increment,
      `
    link_idint(255NOT NULL default '0',
      `
    usernamevarchar(100NOT NULL default '',
      `
    passwordvarchar(255NOT NULL default '',
      `
    ur_idint(10NOT NULL default '0',
      `
    is_activeenum('1','0'NOT NULL default '1',
      
    PRIMARY KEY  (`user_id`)
    );


    CREATE TABLE `tb_user_rank` (
      `
    ur_idint(255NOT NULL auto_increment,
      `
    user_rankenum('1','2','3','4','5'NOT NULL default '1',
      `
    user_positionvarchar(255NOT NULL default '',
      
    PRIMARY KEY  (`ur_id`)
    );


    INSERT INTO `tb_user_rankVALUES (1'1''SuperAdmin');
    INSERT INTO `tb_user_rankVALUES (2'2''Admin');
    INSERT INTO `tb_user_rankVALUES (3'3''ClassTeacher');
    INSERT INTO `tb_user_rankVALUES (4'4''Student');
    INSERT INTO `tb_user_rankVALUES (5'5''Others');


    CREATE TABLE `tb_user_statistics` (
      `
    user_idint(255NOT NULL default '0',
      `
    sesssion_idvarchar(255NOT NULL default '',
      `
    cookie_idvarchar(255NOT NULL default '',
      `
    ipvarchar(255NOT NULL default '',
      `
    browservarchar(255NOT NULL default '',
      `
    timeint(11NOT NULL default '0',
      `
    is_loginenum('0','1'NOT NULL default '0',
      `
    last_logindatetime NOT NULL default '0000-00-00 00:00:00',
      `
    login_timesint(255NOT NULL default '0'
    ); 
    Concept of this site:
    There is superadmin who manages the admin and class teachers

    what a admin can do?
    He can add, edit, delete student/teacher profiles, class, subject, routine , assign student n teachers password etc..

    what student can do?
    He can login with the password and view his details and mark sheet of the academic he passed...

    what a teacher can do?
    He can login with the password and view his details and his routine

    what a class teacher can do?
    He can edit their students' different terminal scores/marks etc.,

    Problems i am facing ?
    >How to generalize the routine , is that routine perfect or else should be modified
    >How to generalize the score table so that it would be easy for retrieving n updating...i had made to score table namely tb_score and tb_score_alternative ...i dont think both are ok..help me to make a good score table..
    >what happens when student goes from class 1 to class 2.....his st_id is made new but com_id remains the same ....is there any alternative solution for this
    >How should the class teacher manages his students score .....
    ............
    Please help me on the above topics...Anyway thnks for showing the patience while reading this...Thanks in Advance
    Last edited by PHPycho; 06-12-2006 at 01:59 PM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •