Please enable JavaScript.
Coggle requires JavaScript to display documents.
database design - Coggle Diagram
database design
student
full name
id
cpr
nationality
college
major
minor
private email
uob email
credits passed
gpa
phone number
personal picture
status
course code
cv
recommendation letter
coordinator (FK)
pdf
date
transcript
username
password
fields of experience
dapartment
training application
message
course code
student training (FK)
student (FK)
acceptance letter
date
supervisor (FK)
pdf
student training
status
last update date
company (FK)
start date
finish date
report
submission date
evaluation
q1
q2
q3
student training (FK)
supervisor (FK)
student (FK)
coordinator (FK)
student evaluation
date
evaluation
interview (T/F)
site/online visit
supervisor training
approval
supervisor (FK)
student training (FK)
supervisor evaluation
date
evaluation
q1
q2
q3
student training (FK)
trainee evaluation
date
evaluation
q1
q2
q3
student training (FK)
coordinator training
approval
student training (FK)
coordinator (FK)
coordinator evaluation
date
evaluation
q1
q2
q3
student training (FK)
training evaluation
company
name
field
email
description
requirements
no. of required trainee
trainee fields
address(street1,stree2,city)
course start date
course end date
supervisor (FK)
agreement (T/F)
profile picture
supervisor
name
email
contact no.
company (FK)
username
password
notifications
student/ user (FK)
title
time
message
instructor
name
college
email
job
coordinator
username
password
name
email