SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Member
    Join Date
    May 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help Me In My Graduate Project [Course Registertion - Student TimeTable ] Please

    Hello Guys
    I Must Submit my graduate project in 10 days and i only done 10% of it

    it will be for student to - >
    - Edit Student Profile
    - Register Course
    - Student TimeTable For Course Registred

    I Found A Very Nice Database With ER For Old Project That Have Allllll I Need [Just Need PHP Coding :O]



    • Each student has a unique student ID and a profile. The profile includes first/last names,
    gender, date of birth, local address, department, enrolled year, username, login password,
    and may have a picture. You can also add other necessary information.
    • Each instructor has a unique faculty ID and a profile. The profile must indicate the
    instructor’s department(s). An instructor may work at more than one department. • A department has a unique department ID, a name, and a list of faculties.
    • Each course has a course number, an instructor, given department, term, credits, classroom,
    periods, prerequisite courses, textbooks, and other information you think is necessary.
    • A classroom has a unique ID and a unique location. Classrooms can hold more than one
    course each term, but these courses cannot conflict in time. Classrooms have capacities.
    Registered students’ number cannot exceed the classroom capacity.
    • Must maintain all the courses a student has already taken/registered. This is used to check
    course prerequisites when registration.
    • Students may login (with username and password) to the system to register courses or
    retrieve all the courses they have already taken/registered.
    • Instructors may login (with username and password) to the system to add courses or
    retrieve all the courses they have already given/added.
    • A student cannot register a course if: 1) he/she doesn’t meet the prerequisites, 2) the
    students registered in the course exceed the capacity of the classroom, 3) the course has a
    time conflict with other courses in the same term.
    • An instructor cannot add a course if: 1) the classroom has already occupied by another
    course in the same period, 2) he/she has another course in the same period, 3) he/she is
    not affiliated to the department of this course.
    • A day has 12 periods and a week has 5 days. Instructor provides periods when adding
    courses to the system.
    • Students may retrieve all the courses given by a department, an instructor, or held in a
    specific period.
    • There can be an arbitrary number of students/instructors/departments/classrooms/courses

    Code:
    Create table Student ( 
     studentId int Primary Key , 
     firstName varchar(30) not null, 
     lastName varchar(30) not null, 
    profilepic blob, 
     gender varchar(1), 
     dob date, 
     address varchar(200), 
     deptId int, 
     homepage varchar(70) default null, 
     yearEnrolled varchar(15) not null, 
     overallGPA float (3,2), 
    foreign key (deptId) references Department(dept_id) ); 
    Create table Login ( 
     username varchar(20) not null UNIQUE, 
     password varchar(20) not null, 
    type varchar(1) not null, 
     studInstId int not null AUTO_INCREMENT Primary Key 
    ); 
    Create table Instructor( 
    instId int Primary Key , 
    firstName varchar(30) not null, 
    lastName varchar(30) not null, 
    profilepic blob, 
    gender varchar(1) not null, 
    dob date not null, 
    address varchar(200) not null, 
    homepage varchar(70) default null, 
    yearEnrolled varchar(15) not null 
    ) 
    Create table Department ( 
     deptId int primary key, 
     deptName varchar(50) not null 
    ) 
    Create table Course ( 
     courseId int, 
          courseName varchar(50), 
     term varchar(15) ,  
     deptId int, 
     credits int not null, 
     textbook varchar(50) default null, 
     refTextbook varchar(50) default null, 
    courselink varchar(50) default null, 
    primary key (courseId, term), 
    foreign key (deptId) references Department(dept_id), 
    ); 
    Create table Prerequisites ( 
     courseId varchar(15), 
     prereqId varchar(15), 
    foreign key (courseId) references Course(courseId), 
    foreign key (prereqId) references Course(courseId) 
    ); 
    Create able Coursestaken ( 
     studentId int, 
     courseId varchar(10), 
     term varchar(15), 
     grade varchar(1) default null , 
    foreign key (studentId) references Student, 
    foreign key (courseId) references Course, 
    foreign key (term) references Course(term) ); 
    Create table InstructorDept ( 
     instId int, 
     deptId int,  
    foreign key (instId) references Instructor, 
    foreign key (deptId) references Department 
    ); 
    Create table InstructorCourses ( 
     instId int, 
     courseId varchar(15), 
     term varchar(15), 
    foreign key (instId) references Instructor, 
    foreign key (courseId) references Courses, 
    foreign key (term) references Course(term) 
    ); 
    Create table Classroom ( 
     classId varchar(10) primary key, 
     location varchar(30) not null, 
     maxCapacity int not null, 
     seatsLeft int not null 
    ); 
    Create table ClassCourse ( 
     classId int not null, 
     courseId varchar(15) not null, 
     period int not null, 
    day varchar(1) not null, 
     term varchar(15) not null, 
    foreign key (classId) references Classroom(classId), 
    foreign key (courseId) references Course(courseId), 
    foreign key (term) references Course(term) 
    );

    2hgqr5y.jpg


    Functionalities a student can perform in the system:

    - Can edit his profile data i.e. address/homepage/email id information and update.
    - Register a course
    - Constraints checked here include
    MAX courses registered this semester, in our system its 3,
    Course previously not registered,
    Seats lefts in the course,
    Prerequisite course registered and
    Conflicts in timing with other currently registered courses.
    - View his schedule
    - Can view class schedule in a tabular format (similar to ISIS)
    - Drop course option is provided on this page
    - Can view additional information about the courses he has taken.
    - Can view textbook information of the courses department wise.
    - Can view courses with prerequisite information
    - Can view the list of courses using the department and instructor parameters.
    - Can view the list of courses using the day and period parameters.
    - Can view courses previously taken along with grades information
    - Can also request for graduation, we have enforced a minimum of 10 courses for a student
    to graduate, If this request is not met the graduation request is denied else it if forwarded
    to the graduate advisor.


    Functionalities an Instructor can implement in the system: - Can view / edit profile information and also update.

    - Can view current schedule in a tabular format (Similar to ISIS)
    - Can edit Course details - Details such as Seats left - to increase or decrease the capacity
    of the course (seats cannot be more than class capacity)
    - Can add a new course to the database under his profile and department.
    - The input parameters in the form are checked for valid input data before updating the
    database.
    - Conflicts with the instructor's schedule as well as conflicts in timing with other courses in
    the same classroom are checked.
    - Can view classroom availability as well as maximum capacity of classroom when course
    information is updated or new classroom is added
    - Instructor can view info of all the students registered in the courses he/she is handling.

    As You Can See There Is Many Reletions in database And I really Confused Especially In Registerion Course Page when im trying to code it
    Can You Pleassssssssseeeee Help Me At Least To Finish Course Registertion Page With TimeTable ???

  2. #2
    It's all Geek to me silver trophybronze trophy
    ralph.m's Avatar
    Join Date
    Mar 2009
    Location
    Melbourne, AU
    Posts
    24,114
    Mentioned
    448 Post(s)
    Tagged
    8 Thread(s)
    I Must Submit my graduate project in 10 days and i only done 10% of it
    I don't want to be mean, but jeesh, the idea of a school project is that you are meant to do it. If it's over your head, you really should let the teacher know. Getting others to do it for you is not appropriate. People like to help here, but not do your work for you.
    Facebook | Google+ | Twitter | Web Design Tips | Free Contact Form

    Forum Usage: Tips on posting code samples, images and more

    Forrest Gump: "IE is like a box of chocolates: you never know what you're gonna get."

  3. #3
    SitePoint Member
    Join Date
    May 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi ralph.m
    You Right But I Dont Want Someone to do it for me i just want the php query code to link with tables because iam not good in link php with sql realtions and i really dont have time to try and find out error in relations because i hava another things im doing now like backend & Profiles

    --
    Notice : In Egypt Colleges There Is No Problem To Get Some Help From SomeOne And Put His Name Or Email On Graduate Book

  4. #4
    It's all Geek to me silver trophybronze trophy
    ralph.m's Avatar
    Join Date
    Mar 2009
    Location
    Melbourne, AU
    Posts
    24,114
    Mentioned
    448 Post(s)
    Tagged
    8 Thread(s)
    OK, well the key is to ask clear questions in sequence. What's a specific problem you are having, with which bit of code? Maybe break it down into bits. It helps people to help you if you get right to the issue you are having, rather than just presenting the whole project. I hope you'll get some good help, but this is not my area.
    Facebook | Google+ | Twitter | Web Design Tips | Free Contact Form

    Forum Usage: Tips on posting code samples, images and more

    Forrest Gump: "IE is like a box of chocolates: you never know what you're gonna get."

  5. #5
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,254
    Mentioned
    113 Post(s)
    Tagged
    1 Thread(s)
    As Ralph said, we're not going to do your homework for you. You need to show you're making an honest effort, so if you show what you've done so far (and no, the flowchart/UML doesn't count), then people will be glad to help you out. But no one is going to do your work for you.....
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style

  6. #6
    SitePoint Member
    Join Date
    May 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thx ralph.m

    My Problem Now In Course Register Page .. It Have Relations With All Other Table And I Dont Know From Where I Strat & What Fields Will Put In Page

  7. #7
    SitePoint Member
    Join Date
    May 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I Really Dont Want SomeOne To Do It For Me As I Said Before You Know WHY ? Because Every CoDE i will explain it to my instructor so i must write it myself & understand it

    Im Now In Back End Doing Add Course/Student/Instructor And Will Upload Code Tonight


Bookmarks

Posting Permissions

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