Question
I am looking for help on an MS Access assignment. We have been given an Access example with the following instructions: 1) Alter the course
I am looking for help on an MS Access assignment. We have been given an Access example with the following instructions:
1) Alter the course offerings table to include all necessary fields to create the ability to register students. (Hint, where are all the instructors and rooms?)
2) Add rooms and instructors to the registrations. Make sure Stephen Surles (ID 1) is teaching CIS430
3) Create foreign keys that enforce referential integrity and cascade among all the tables where necessary.
4) Display all the students registered for a section 1(section ID) of the CIS 430 course (course ID). Include in the display the following information for each student: first and last name, major, and matriculation date.
5) Display all the courses being taught by Stephen Surles, instructor (ID 1). Include in the display the course title, building, and number of students enrolled.
6) Display room usage information by the courses being taught in each room in each building.
The Tables from the example are below:
I am not very familiar with Access, so please don't assume a high degree of pre-existing Access or SQL knowledge on my part.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started