Help with DB Design

Databases
1

Hi,
I’m new to the forum, have a basic knowledge of databases, but need some help with the best way to structure a results database for the college I work in.

Up to now our results have been recorded on paper. For our external examiners we have to record the grades twice, on two different types of report. I want to create a database to allow staff to fill in the grades once but with the ability to output both reports.

Report 1 is the Mastersheet. Each student has a “Mastersheet” which contains all of their grades for all assignments in all Classes.

Report 2 is the Class Results sheet, which records the grades of all students within a particular Class.

The database is as follows:
The college has many students.
Each student is enrolled in 16 Classes.
Each Class has many assignments.
Each Assignment has 5 possible results: D, M, P, U and R.

When all of the results have been input I need to be able to output the 2 different types of reports mentioned.

The front-end part of the database is not a problem, but I’m not sure how many tables I need and how to relate them.

Apart from the Class Titles, Assignment Titles and Grades etc., the only other fields I need to include are “Student Name” and “Student ID”. Is it possible to create this without having to make a separate table/database for each student?

Any help would be greatly appreciated.

Thanks, Mick See

2 Likes
2

yes, you can do it with one table for all students

3

You’re already thinking about this in the right way with the exception of the reports. Model the database in a way to store the data and keep the reports in the back of our mind. If the db is modeled in a way which best represents the entities and relationships the reporting aspect will be just a matter of the formulating the right queries.

1 Like
4

Thanks for the replies. I’ll give them a go and let you know how I get on.
Cheers,
MickSee

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.