decreasing number of records.. is it important?

hi,

If we consider the following scenerio:
a school with 500 students.
On average student takes [x] courses per year, and [y] tests per course.

table of grades:
+----+----+---+---+
| student_id | course_id | term_id | grade |
+----+----+---+---+
| | | | |
+----+----+---+---+
| | | | |
+----+----+---+---+

as average, x = 20, y =6 then
number of records = 500 * 20 * 6 = 120,000 record per year.

is this design correct considering number of records generated per year?
Is it important to reduce the "number of records" or no?

thank you.> as average, x = 20, y =6 then
> number of records = 500 * 20 * 6 = 120,000 record per year.
> is this design correct considering number of records generated per year?
> Is it important to reduce the "number of records" or no?
> thank you.

500 * 20 * 6 = 60 thousand, not 120 thousand.

This is what a database is for - storing information.

If that is the information you want to store, then that is what you should
use.

Many databases will hold many billions of rows.

--

Consider an analagy -
This dictionary has too many words - should I remove some ?

S.