Coding Bootcamp - Assignment 2 Brief
Following Assignment 1 you need to implement the following functionality:
- Make a draft design of a database that can keep data for the main entities of the assignment and name the tables as: Students, Trainers, Assignments, Courses [15 marks]
- Identify any other tables you need based on your implementation and construct them [15 marks]
- Design the ERD of your system and verify it through an online tool such as https://sqldbm.com/ (it requires a free account) [15 marks]
- Populate the tables of the database with enough data [10 marks]
- You need to produce sql queries that output the following [45 marks in total]:
• A list of all the students [5 marks] • A list of all the trainers [5 marks] • A list of all the assignments [5 marks] • A list of all the courses [5 marks] • All the students per course [5 marks] • All the trainers per course [5 marks] • All the assignments per course [5 marks] • All the assignments per course per student [5 marks] • A list of students that belong to more than one courses [5 marks]