Structure Design of this database

 

 

Q: Do I have to design a data structure like this? If not, please give reasonable comments? Thank you.

1.

One topic is:
Courseware, teaching plan, materials, lectures

2.
The displayed data is:

English in the courseware section: the application of English Teaching in Senior One.
English refers to English data.

Mathematics in the courseware section: how to reflect the effectiveness of Mathematics Teaching
Description: Mathematics corresponds to mathematical data.

Language in the courseware column: growth after failure

Note: The Chinese language corresponds to the Chinese data.

How can I design this data structure? Thank you.

3.
My idea is:

Column table: column id column name column title, column content, column Level 1 category, column Level 2 Category, content time

Category Table: Category id, category level 1 Name.
4.

The relationship between the table and the table is:
One-to-one relationship