What is the correct way to represent course dates in MySQL?

A

avr19722018-01-30 15:00:54

MySQL

avr1972, 2018-01-30 15:00:54

There is a database of training courses. Each course has an annual syllabus that lists the course dates for the current year (approximately 5 dates). Can you please tell me how to correctly place the dates of the course in the database? Do I need a separate table for the dates of the courses, and if so, what columns should it consist of?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

Lazy @BojackHorseman MySQL, 2018-01-30
@avr1972

strictly formally needed)
surrogate_id, course_id, date