Coding Bootcamp Individual Project–PART B Following PART A you need to implement the belowfunctionality : 1.Design the ERD of your system and verify it throughan online tool such as https://sqldbm.com/ (it requires a free account)
2.Identify any other tables you need based on your implementation and construct them
3.Make the schema of a database that can keep data for the main entities of the assignment and name the tables as: Students, Trainers, Assignments, Courses
4.Populate the tables of the database with enough data
5.You need to 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 cours•All the trainers per course •All the assignments per course[2marks]•All the assignments per course per student •A list of students that belong to more than one courses[3marks]6.You also need to produce asmall project that a.makes a connection to the database and executes the above sql queries
b.makes a connection to the database and inserts inputdata from the keyboard to the following tables, i.students ii.trainers iii.assignments iv.courses v.students per course vi.trainers per course vii.assignments per student per course