The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 364 Weeks Ago, 2 Days Ago |
| Questions Answered: | 1850 |
| Tutorials Posted: | 1850 |
Graduate in Biology and Nutrition, MBA Finance
Florida State University
Aug-2000 - Jul-2007
Ass. Relationship Manager
Penn-Florida
Mar-2009 - Feb-2016
Hello, you have helped me in the past, but having trouble resolving the issues below, I can't seem to get the queries to show what they need to show, and our book is no help in the matter. Attached is the access file. Any help will greatly appreciated thanks.
The queries that are associating a student ID with a classroom, instructor, ID etc. needs help, it only shows one student id. -The schedule query
The course query shows 1 student per class. There should be more registered for the classes. The student id column is not needed
The student query only shows 5 courses when there should be 8
The schedule query shows only 5 courses ids and 5 students, 1 per course. There are 8 courses and many students
The instructor schedule query shows 2 columns of classrooms and assume the instructors only teaches in the same classroom
There are only 5 students.enrolled. What happened to the other 35?
The explanation of queries is missing
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I