sxi12345
01-31-2008, 03:27 PM
Hi
Please could someone help me with my database tables. I have to create a database for course management for students. I have enclosed the scenario and my tables that I have created.
Background
The numbers of students in further and higher education has increased rapidly in recent years and it was decided that there is a need for a database to cope with all the record keeping required.
There are usually in excess of 100 students on each level of study. Each student takes 4 modules per year, 30 credits per module. Each module has a main tutor and may have assistant tutors. The year manager is responsible for providing class lists and other information to the main module tutor. Students choose modules from a set list. Modules have marks in the range 0 to 100. A pass is 40 or more.
Required Functionality
1.Record module choice details. All students must have exactly 120 credits per level. Report on any students still short of that number.
2.Students may wish to change their module choices, so record these changes.
3. Display class lists for each module tutor.
4. Add personal details of students at the start of the academic year. Record all marks at the end of the year. Provide an analysis of grades by module.
5.For various reasons a student may leave during the year. Extend the system to record that the student has left and record the reasons why. Do not delete the student details (they will need to be analyzed later but not as part of this application)
To view the Tables follow the link :
http://s127.photobucket.com/albums/p129/sxi1234/?action=view¤t=Untitled.jpg
Please could someone help me with my database tables. I have to create a database for course management for students. I have enclosed the scenario and my tables that I have created.
Background
The numbers of students in further and higher education has increased rapidly in recent years and it was decided that there is a need for a database to cope with all the record keeping required.
There are usually in excess of 100 students on each level of study. Each student takes 4 modules per year, 30 credits per module. Each module has a main tutor and may have assistant tutors. The year manager is responsible for providing class lists and other information to the main module tutor. Students choose modules from a set list. Modules have marks in the range 0 to 100. A pass is 40 or more.
Required Functionality
1.Record module choice details. All students must have exactly 120 credits per level. Report on any students still short of that number.
2.Students may wish to change their module choices, so record these changes.
3. Display class lists for each module tutor.
4. Add personal details of students at the start of the academic year. Record all marks at the end of the year. Provide an analysis of grades by module.
5.For various reasons a student may leave during the year. Extend the system to record that the student has left and record the reasons why. Do not delete the student details (they will need to be analyzed later but not as part of this application)
To view the Tables follow the link :
http://s127.photobucket.com/albums/p129/sxi1234/?action=view¤t=Untitled.jpg