Part B of the application can keep data for the main entities of the assignment and name the tables as: Students, Trainers, Assignments, Courses. The SQL script can produce sql queries that output the following:

• A list of all the students
• A list of all the trainers
• A list of all the assignments
• A list of all the courses
• All the students per course
• All the trainers per course
• All the assignments per course
• All the assignments per course per student
• A list of students that belong to more than one courses

The application makes a connection to the database and executes the above sql queries and makes a connection to the database and inserts input data from the keyboard to the following tables,

• students
• trainers
• assignments
• courses
• students per course
• trainers per course
• assignments per student per course