****SQL DATABASE IN ACCESS**** Pitt Fitness database tables: 1. Classes (ClassID, ClassName, Room, Location, LengthofTime, MaxSize, TypeofClass, Day, Time, Description) 2. ClassInstructors (ClassID, InstructorID) 3. Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate) 4. Instructors (InstructorID, InstructorLastName, InstructorFirstName, InstructorStreetAddress, InstructorCity, InstructorState, InstructorZipCode, InstructorEmailAddress, InstructorPhoneNumber) 5. Reservations (ReservationID, ClassID, ClassDate, ClassPrice, OtherFees, CustomerID) Assume that the Pitt Fitness accountant has met with the owner to discuss how to handle payments and balances. They both decide to add fields to the Customers table to record any payments arriving and the subsequent balance. Add the appropriate fields to the Customers table and set up a Before data macro to check the payment and balance.
****SQL
Pitt Fitness database tables:
1. Classes (ClassID, ClassName, Room, Location, LengthofTime, MaxSize, TypeofClass, Day, Time, Description)
2. ClassInstructors (ClassID, InstructorID)
3. Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate)
4. Instructors (InstructorID, InstructorLastName, InstructorFirstName, InstructorStreetAddress, InstructorCity, InstructorState, InstructorZipCode, InstructorEmailAddress, InstructorPhoneNumber)
5. Reservations (ReservationID, ClassID, ClassDate, ClassPrice, OtherFees, CustomerID)
Assume that the Pitt Fitness accountant has met with the owner to discuss how to handle payments and balances. They both decide to add fields to the Customers table to record any payments arriving and the subsequent balance. Add the appropriate fields to the Customers table and set up a Before data macro to check the payment and balance.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
