Question: I need help with my Microsoft Acces Database project. Please give me step by step instructions on how to do this. Here are the instructions
5:24 PM famu.blackboard.com * 30%L-O-+ '11 Verizon Assignment Summary: This assignment requires you to construct a series of SOL queries in Microsoft Access to extract the relevant information from the ISMU database available at Your first task is to download the ISMU Microsoft Access database file and rename it according to the assignment specifications for your group. This database already contains the table structures and data needed to satisfy the queries Create and save the SQL queries in the existing database to satisfy the questions listed below. Your submission should include the original table structures in addition to the queries for each question. Your queries should be named query_cquestion numbern (example: query 1 for question 1) for each respective question . .Submit the names of all group members who participated in the assignment. This should be included in the submission area for the assignment. Project Questions Toble constraints: studentnumber in ENROLLMENT must exist in SID in STUDENT class name in ENROLLMENT must exist in name in CLASS 1. Use a subquery to display the name, grade level and age of the oldest students (20 pts.) 2. Provide the SQL to display each room and the total number of students who have classes in that room. The resulting column displaying the number of students should be named TotalStudents". You should use only the JOIN .ON.. . syntax to write this query. (20 pts.) 3. Use a subquery to display the class schedule (class name, time, and room) of history graduate student 'baker Note: graduate students are denoted by the grade level 'GR. (20 pts. 4. Create an SQL statement to display the average age for each grode_ level. A grade_level should be included in the result set only if the oldest student in that grade level is Hint: You do not need to use a subquery but you may need to use a GROUP BY statement. (40 pts.) 5:24 PM famu.blackboard.com * 30%L-O-+ '11 Verizon Assignment Summary: This assignment requires you to construct a series of SOL queries in Microsoft Access to extract the relevant information from the ISMU database available at Your first task is to download the ISMU Microsoft Access database file and rename it according to the assignment specifications for your group. This database already contains the table structures and data needed to satisfy the queries Create and save the SQL queries in the existing database to satisfy the questions listed below. Your submission should include the original table structures in addition to the queries for each question. Your queries should be named query_cquestion numbern (example: query 1 for question 1) for each respective question . .Submit the names of all group members who participated in the assignment. This should be included in the submission area for the assignment. Project Questions Toble constraints: studentnumber in ENROLLMENT must exist in SID in STUDENT class name in ENROLLMENT must exist in name in CLASS 1. Use a subquery to display the name, grade level and age of the oldest students (20 pts.) 2. Provide the SQL to display each room and the total number of students who have classes in that room. The resulting column displaying the number of students should be named TotalStudents". You should use only the JOIN .ON.. . syntax to write this query. (20 pts.) 3. Use a subquery to display the class schedule (class name, time, and room) of history graduate student 'baker Note: graduate students are denoted by the grade level 'GR. (20 pts. 4. Create an SQL statement to display the average age for each grode_ level. A grade_level should be included in the result set only if the oldest student in that grade level is Hint: You do not need to use a subquery but you may need to use a GROUP BY statement. (40 pts.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
