Creating an ERD for a school

• akhlaq.itexpert

  Valued Member

  Points: 73

  More actions

  November 15, 2008 at 2:59 am

  #96725

  All the schools we see around us operate on in the same way with a few differences. What i am trying to develop is an application that can fulfill most of their requirements.

  The problem that i am facing is that i have the following tables

  Exam(ID,ClassID,StudentID,MarksSheetID)

  MarksShett(ExamID,CourceID,ObtainedMarks)

  Class(ID,Name)

  Promotion(Chassid,StudentID)

  As the student gives exam he is promoted to the next grade(i.e)The promotion table is upgraded.eg(stdid=10,classid=5 becomes stdid=10,classid=6)

  Now the problem arises when the student is promoted in the last standard and there are no more standards......

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  November 15, 2008 at 8:43 am

  #898982

  Akhlaq.

  It would assist us in assisting you if you can:

  1. Post your current code that promotes the student, that is increments the classid value.

  2. Describe what you want to be done, that is:

  a. Indicate student has graduated and preserve all that students records.

  b. Remove from the DB all entries for that student

  c. Some other action

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]