Building software to manage a bank of multiple choice questions for university admissions - 16


5

DoKho

R

>= 0 and <= 1

Difficulty

test

sentence

measurement


6

DoPhanCach

R

>= -1 and <= 1

Resolution

multiple choice

way

sentence


7

MaGBS

N

>0, is a foreign key

to TAC_GIA table

Author code

multiple choice


8

MaMH

N

>0, participates in foreign key to table NOI_DUNG_MON

_HOC and table

CONTENT

Subject code


9

MaNDMH

N

>0, participates in foreign key to table NOI_DUNG_MON

_HOC and table

CONTENT

Course content code


10

MaNDC

N

>0, participate in foreign key to table

CONTENT

Child content code


11

MaMTMH

N

>0, participates in foreign key to table MUC_TIEU_MON

_HOC and table

Sub-Items

Course objective code


12

MaMTC

N

>0, join in

Child target code


Maybe you are interested!

Building software to manage a bank of multiple choice questions for university admissions - 16





foreign key to table

Sub-Items



13

SoLanXuatHien

N

>0

Number of multiple choice questions

The test has appeared in the exam papers.



B.1.10 SELECTION_LIST table


STT

Column name

Type

Binding

Meaning

Note

1

MaCH

S(17)

Join primary key, join foreign key to table CAU_HOI_DA_LUA_

CHOOSE

Question code


2

MaLuaChoon

N

>0, join the course

main

Option code


3

XML Content

S


Content selection by style

XML


4

ContentText

S


Question content by type

document




B.1.11 TOLERANCE QUESTIONS Table


STT

Column name

Type

Binding

Meaning

Take note

uncle

1

MaCH

S(17)

Is the primary key

Question code


2

XML Content

S


Question content







in XML style


3

ContentText

S


Question content

by text


4

DapAn

N

>0

The answer to the multiple choice question is the code.

select


5

DoKho

R

>= 0 and <= 1

Multiple choice difficulty

test


6

DoPhanCach

R

>= -1 and <= 1

Sentence Separation

multiple choice


7

MaGBS

N

>0, is a foreign key

to TAC_GIA table

Author code

multiple choice


8

MaMH

N

>0, participates in foreign key to table NOI_DUNG_MON

_HOC and table

CONTENT

Subject code


9

MaNDMH

N

>0, participates in foreign key to table NOI_DUNG_MON

_HOC and table

CONTENT

Course content code


10

MaNDC

N

>0, participate in foreign key to table

CONTENT

Child content code


11

MaMTMH

N

>0, join in

Course objective code






foreign key to table MUC_TIEU_MON

_HOC and table

Sub-Items



12

MaMTC

N

>0, participate in foreign key to table

Sub-Items

Child target code


13

SoLanXuatHien

N

>0

Number of times the quiz has appeared

in the exam



B.2 Detailed design of object classes

B.2.1 Design of user interface object class

B.2.1.1 MH_Chinh Class

Figure 37. Main screen


MH_Chinh

Feature Category: OutlookBar

MH_Chinh_Load

Function Category_Click



List of objects shown:


STT

Name

Type/Model

Meaning

Note


1


Function List


OutlookBar

List of functions

of software

Position (0,0),

Located on the left side of the screen


B.2.1.2 MH_Author Class

Figure 38. Author management screen

List of events:


STT

Show

Event type

Handle

Note

1

MH_Chinh

Load

Read information about the database

whether



2


Function List


Click

Turn on the screens corresponding to the function that the user

content request




MH_Author


lblScreen_Title: Label gridAuthor: Grid

btnThem: Button btnXoa: Button btnHuyBo: Button btnLuu: Button btnDongY: Button btnBoQua: Button xlTacGia: XL_TacGia flagDeleted: Boolean

flagChanged: Boolean

MH_TacGia_Load MH_TacGia_Closing gridTacGia_InitNewRow gridTacGia_CellValueChanged btnThem_Click

btnXoa_Click btnHuyBo_Click btnLuu_Click btnDongY_Click btnBoQua_Click

DeleteRelatedQuestions()


List of objects shown:


STT

Name

Type/Model

Meaning

Note

1

lblImageTitle

Label

Screen Title


2

gridAuthor

Grid

Author list grid


3

btnThem

Button

Add author button


4

btnXoa

Button

Delete author button



5

btnHuyBo

Button

Cancel button


6

btnSave

Button

Save button


7

btnDongY

Button

Agree button


8

btnBoQua

Button

Skip button



List of member variables:


STT

Name

Type/Model

Meaning

Note

1

flagChanged

Boolean

True: there is a change on the grid

False: no change on the grid


2

flagDeleted

Boolean

True: delete on grid

False: no deletion on grid



List of processed objects:


STT

Name

Class

Meaning

Note

1

xlTacGia

XL_Author

Handle operations related to objects

author's statue



List of events:


STT

Show

Event type

Handle

Note

1

MH_Author

Load

Read the author list from the base

data



2


MH_Author


Closing

Handles saving changes of

user before closing the screen


3

gridAuthor

InitNewRow

Assign author code to column number

self on grid


4

gridAuthor

CellValueChanged

Enable flagChanged


5

btnThem

Click

Focus on the new row above


Comment


Agree Privacy Policy *