test paper database

May 1, 2018
3
0
10
0
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
0


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
0


thanks a lot
 
Thread starter Similar threads Forum Replies Date
A Apps General Discussion 1
D Apps General Discussion 3
L Apps General Discussion 1
tarmiricmi Apps General Discussion 5
R Apps General Discussion 3
S Apps General Discussion 1
H Apps General Discussion 1
A Apps General Discussion 1
V Apps General Discussion 4
S Apps General Discussion 3
I Apps General Discussion 1
D Apps General Discussion 3
R Apps General Discussion 2
C Apps General Discussion 1
stevenvw Apps General Discussion 1
D Apps General Discussion 2
K Apps General Discussion 3
A Apps General Discussion 1
edward78 Apps General Discussion 1
B Apps General Discussion 4

ASK THE COMMUNITY