Project #50675 - Relational Database

 

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.



Other Requirements



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. 

Subject Computer
Due By (Pacific Time) 12/10/2014 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy