G
Guest
I am messing around with a training database but I want specific help with
setting up the training feedback so I won't show all the tables. The way I
have it set up at the moment is
tble_employee
EmployeeID (PK)
Employee
tble_attend
EmployeeID (FK)
BookingID (FK)
Attendance (checkbox)
tble_booking
BookingID (PK: autonumber)
RoomID (FK)
CourseID (FK)
Duration
TrainingDate (FK)
TrainingTime
SupervisorID (FK)
tble_survey
BookingID (FK)
SurveyID (PK: autonumber)
tble_feedback
SurveyID (FK)
QID (FK)
ResponseID (PK: autonumber)
tble_question
QID (PK)
Question
I have been a bit intimidated about setting a database for survey entry. I
have had a go before so I vaguely know what is going on but I am not sure
whether the above is correct.
Cheers
setting up the training feedback so I won't show all the tables. The way I
have it set up at the moment is
tble_employee
EmployeeID (PK)
Employee
tble_attend
EmployeeID (FK)
BookingID (FK)
Attendance (checkbox)
tble_booking
BookingID (PK: autonumber)
RoomID (FK)
CourseID (FK)
Duration
TrainingDate (FK)
TrainingTime
SupervisorID (FK)
tble_survey
BookingID (FK)
SurveyID (PK: autonumber)
tble_feedback
SurveyID (FK)
QID (FK)
ResponseID (PK: autonumber)
tble_question
QID (PK)
Question
I have been a bit intimidated about setting a database for survey entry. I
have had a go before so I vaguely know what is going on but I am not sure
whether the above is correct.
Cheers