decreasing number of records.. is it important?

[Osaka]

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.

[Steven Wilmot]

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.