这是我的导师分段形式:I-V级学费VI-VIII级学费IX-X级学费XI-XII级学费大学水平工程科目
根据我的导师选择的部分,我展示了不同的形式。假设用户选择了不同的课程,比如1-5级6-8级8-10级和工程。如何制作我的表格列请参阅示例
1.Tutor selected class I-V And class VI-VIII
2.Tutor selected class I-V And class VI-VII AND Engineering
Here is my Db structure:
my column contains
tutorid class1-5 class6-8 class 8-10 class10-12 collegelevel Engineering
my question are:
1.user selected class1-5 and class6-8
INSERT INTO Tablename('class1-5,class6-8,class8-10,class10-12',collegelevel,engineering) values('class1-5','class6-8','remining column I don't have value');
2.user selected engineering
INSERT INTO Tablename('class1-5,class6-8,class8-10,class10-12',collegelevel,engineering) values('it has only engineering values' remaining column is null);
3.How to make the table for this. Here I have to keep my table column like this only.
否。规范化数据库。
你的导师表:
tutor_id
tutor_username
tutor_password <-- encrypt this
...
您的课程表:
class_id
class_name
您的用户表:
user_id
user_username
user_password <--encrypt this
...
你的"去上课"(gtc)表:
gtc_id
gtc_user_id
gtc_class_id
因此,当您的用户选择一个类时,它将在going to classes
表中创建一个新记录,因此它可能看起来像这样:
| gtc_id | gtc_user_id | gtc_class_id |
| 0 | 16 | 1 |
| 1 | 16 | 2 |
| 2 | 17 | 1 |
在你的课程表中:
| class_id | class_name
| 0 | English
| 1 | Maths
| 2 | Engineering
因此,用户16将转到类别English
和Engineering
,而用户17仅转到类别English