This is the 3rd part of a 3 phase project. Phase 1 and 2 are already completed. The only thing you'd be adding is the below portion. I can include the full requirements of this project as an attachment as well as the already completed portions of the assignment.
Data Manipulation: (35 points)
Implement the queries, form(s), and report.
Complete Project Due date: Dec 10th
This is the last phase of the project, which you will submit the complete database. You will work in teams, that I have listed in session 14 and submit one entry for both students.
If you are using MySQL workbench with either Access GUI or Mforms, then you will need to submit multiple files to provide the complete database.
Be sure to check the “Other Requirements” section of the project (added below) to make sure that you have done all of them.
1. Make sure you use at least 20 students from at least three different schools when you populate your tables.
2. Provide at least the following queries:
o Provide a list that shows how many students attending from each school and by city.
o Provide a list of the administrators and teachers per school.
o Provide a list of all students and their workshop choices. Order it by school and student name.
o List which is the most popular workshop? The least?
o Provide a list of students for a specific school based on user’s input. (Query with parameter).
3. Provide form(s) that takes student’s information plus the workshop choices for the student
4. Provide a report that shows all students with their 2 selected workshops, all in a row.
|Due By (Pacific Time)
||12/10/2014 12:00 am