Each student will create a basic Class Registration database application using Microsoft Access. The relational database application will demonstrate the ability of an access program to capture, store, and report on student-course registration data (transactional information) simulating schools administrative operations. A report of the activities (transactions) will be created to simulate how management will utilize the data/information for decision making.

Database Tables & Attributes (Fields) Required:

You are to create the below entities and attributes in Access, and establish the necessary relationships in the database.

TeacherTable Database table capturing and storing courses offered

o TeacherID Primary Key (Number) o TeacherFirstName - (Required Field - Text) o TeacherLastName - (Required Field - Text)

o TeacherAddress (Required Field - Text) o TeacherZipCode (Required Field Text with input mask) o TeacherEmailAdd - (Required Field Text) o TeacherPhoneNo - (Required Field Text with input mask)

CourseTable Database table capturing and storing courses offered o CourseNumber Primary Key (Number) o CourseTitle Course Title (Required Field - Text) o CourseDescription Course Description (Required Field - Text) o CourseStartDate Date/Time (Required Field with Date Picker) o CourseEndDate Date/Time (Required Field with Date Picker) o CourseMeetingTime Meeting Date and Time (Required Field Text, example TTh 8-10pm) o CourseMaxCapacity (Required Field Number)

o CoursePrice Fee for the course (Required Field Decimal Number with formatting, example xx.xx) o TeacherID Foreign Key (Combo Box - Displaying TeacherID, TEacherFirstName, TeacherLastName)

StudentsTable Database table capturing and storing students information o StudentID Primary Key (Number) o StudentFirstName - (Required Field - Text) o StudentLastName - (Required Field - Text)

o StudentAddress (Required Field - Text) o StudentZipCode (Required Field Text with input mask) o StudentEmailAdd - (Required Field Text) o StudentPhoneNo - (Required Field Text with input mask)

RegistrationTable Database table capturing and storing Students and Courses schedule details o RegistrationID Primary Key Number) o StudentID Foreign Key (Combo Box - Displaying StudentID, StudentFirstName, StudentLastName) o CourseNumber Foreign Key (Sub Form Displaying CourseNumber, CourseTitle)

Application User Interface Forms and Feature Requirement:

EnrollmentForm User interface form to assign registered Students in the database to Courses (Each student can enroll to multiple Courses and each Course can allow multiple students to register)

o Hint: The EnrollmentForm is based on Courses meaning the form shows a specific Course, then allow users of the form to select students to add them (many) to each Course

o Hint: A subform will need to be created titled ScheduleSubForm to resolve the many-to-many relationship in the schedule form design

o Note: The ScheduleSubForm on the EnrollmentForm needs to allow users to pick Students from a drop down list of registered students in the database within the EnrollmentForm

• CourseForm User interface form to add and update course offerings and information to the database

• StudentsForm User interface form to add and update Students information to the database

• TeacherForm User interface form to add and update Teacher information to the database

  Report Required:

Course Roster Report Report that itemizes (grouped) by Course and shows all the students enrolled in the courses. The report needs to show CourseNumber and CourseTitle, as well as all the registered StudentID, StudentFirstName and StudentLastName of those that are enrolled to each Course.