Compilation of rating lists

Question

You must create a database of admissions. In the future, on the basis of rating lists, it will be necessary to compile lists for enrollment.

What is the best way to submit rating lists to the database? For each line of study create a separate table with the necessary information (information about the applicant, points on subjects, etc.) ?!

Then, according to these ranking lists, the search algorithm will be held applicants.

The draft database tables are as follows:

Imgur

Nicolas Chabanovsky ♦ 38.2k 54 220 437 · Answer 1 · 2014-07-13T18:38:12

Direction table

id | title | дополнительные колонки (описание и т.п.)

Item table

 id | title | дополнительные колонки (описание и т.п.)

The table of relations of objects to directions - will provide a connection many-to-many between directions and objects. To find all the items in directions, simply select SELECT * FROM relations WHERE specialization_id = ID направления (plus join).

 specialization_id | discipline_id

Applicants table

 id | last_name | first_name | middle_name | birthdate | ...

And finally, a table of applicants points

 enrollee_id | discipline_id | mark

Connection again many-to-many

And if you form a table with rating lists like this: choose from the table the information of an applicant for people with the necessary specialty code and form a list.
This will create the necessary lists based on a selection of information from common tables.

Compilation of rating lists

1 answer 1

More articles: