test paper database

May 1, 2018
3
0
10
hello guys !! i need your help to create a test paper info table:
courseid , test paperid , date of exam , questionid , fullmark, knowledge point. thanks for your help!!
 

USAFRet

Illustrious
Moderator


That's a pretty basic table. Should take you about 3 mins.

What database application are you using?
What have you done that does not work?

We're not going to do your homework for you.
 
May 1, 2018
3
0
10


courseid int(30)
test paperid int(30) primary key
date of exam date
questionid int(30)
full mark ? ( i don't know how to classify this )
knowledge point ? ( i don't know how to classify this also) that's why I ask for help
 

USAFRet

Illustrious
Moderator


In the context of your classwork, we don't know what you want those two datatypes to be either.
Full Mark = numeric(?)
knowledge point = completely unknown.
 
May 1, 2018
3
0
10


thanks a lot