|
Program form
program code,Duration in duration maximum intake.
Course form-courseid,course title,course information,course duration startdate,datecourse,fees,training time,training training location,sponsor
Training Registration form-Trainerid,firstname,middlename(optional),lastname category of trainer,location of trainer
Trainee information form-trainingid,firstname,middlename,emailid,gender, educational level,certificate date,date of birth, funding type,nationality emergency,contact number,mailingaddress
Sponsor information form-sponsorsid,sponsors name,totalcost of sponsorship,contact number,mailing address,sponsorship information
Transaction /Activities-program planning form,program id,program name,duration in and out startdate,courses available
Program courses planning form-programid,courseid,status
Assigned courses to training form-program trainees courses to assign,selected courses
Assin Trainer course form-courses to assign, selected courses
Question:Write a program with the information above using the forms to design a database for the school management
|