943,673 Members | Top Members by Rank

Ad:
You are currently viewing page 1 of this multi-page discussion thread
Sep 23rd, 2009
0

The student record system

Expand Post »
I have a problem with creating this database.
I want to create the student record system. I have a table containing Individual information and using of ID as primary key.
For registering grades I use another table for grades. But here is the problem. Here we have 6 or more class with different courses.
Firstly, I should to permit the user for adding more classes and then more courses to these basic assumptions. (But how the user can add another table that the relationship between new table and the Ind information table makes sense).
How can I save the grades in table?
It is better to use different table for different class with using different courses as filed in this table.

Or add all the courses in my filed and for each ID I just fill out the course for that class.

Or something else I don't know?

Another problem is when some person has grades with lower than 15, I have to add another grades for this person. This person failed then must have another grade for taking effect in GPA.

Please help me to find the way through these problems.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
Afi83 is offline Offline
35 posts
since Apr 2008
Sep 23rd, 2009
0

Re: The student record system

Below is the database structure I would start with:

Student: ID, Last Name, First Name, etc
Course: ID, Course Name
Section: ID, Course ID, Section Name
Enrollment: ID, Section ID, Student ID
Assignment: ID, Section ID, Assignment Name
Grades: ID, Student ID, Assignment ID, Grade
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Sep 23rd, 2009
0

Re: The student record system

I can't understand how can i relate different course subject to each grades relate to that subject.
Please say some more guidelines.
Also what about the failed grades and where to save other grades related to this subject and using that for accounting GPA.
Reputation Points: 10
Solved Threads: 0
Light Poster
Afi83 is offline Offline
35 posts
since Apr 2008
Sep 23rd, 2009
0

Re: The student record system

You can join the grade table to the section table and then join that to the course table. If you need to track a subject, you can add a subject table and have a foreign key in the course table to record which subject it is for.

To find out GPA, you simply take the grades in the grade table join to the student table and the section table and perform the necessary calculations. The method of how you calculate GPA will dictate the actual query design you use.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Sep 23rd, 2009
0

Re: The student record system

Excuse me
But if you can send a access file containing the relationship because i can't understand the true relationship in this case.

Also please explain about the failed grades of each student and keep track of them.
Reputation Points: 10
Solved Threads: 0
Light Poster
Afi83 is offline Offline
35 posts
since Apr 2008
Sep 23rd, 2009
0

Re: The student record system

I gave you the tables I would use for this database above. As far as the relationships:

course-section: one-to-many
section-enrollment: one-to-many
section-assignment: one-to-many
grades-assignment: many-to-one
grades-students: many-student

After reviewing the design, I found that you can use enrollment ID in the grades table instead of student ID; using the enrollment ID would probably be best.
You should be able to create your own database in access from there.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Sep 23rd, 2009
0

Re: The student record system

This is for school work isn't it?
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006
Sep 23rd, 2009
0

Re: The student record system

No not at all, This is not for school. Really I am graduated. I have M.sc degree in Genetics. But because i did not do any database design I get into trouble for doing this. This is program for my military service I want to use some privilege by doing this.

If someOne can guide me please help.
Thanks in advance for all of responses to this thread
Reputation Points: 10
Solved Threads: 0
Light Poster
Afi83 is offline Offline
35 posts
since Apr 2008
Sep 24th, 2009
0

The student record system ERD

Dear Friends

The attachment is my effort for creating the ERD for the question.
Please check it for correctness or wrongness.

Thanks in advance
Attached Files
File Type: doc StudentERD.doc (44.0 KB, 204 views)
Reputation Points: 10
Solved Threads: 0
Light Poster
Afi83 is offline Offline
35 posts
since Apr 2008
Sep 24th, 2009
0

Re: The student record system

How does your design track which classes the grades are for? How does your design track each assignment? Is each major a part of a field? What do the penalty and class tables track? How does your table track which class the faculty are teaching?

I would suggest you start with the suggestions I made in this thread, create the ER diagram and go from there.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: filter and auto update fields in Access form
Next Thread in MS Access and FileMaker Pro Forum Timeline: Obtaining top 10 performers by category





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC