Problem
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.
Discuss security issues with the Pitt Fitness database. Who should have access to the database? Can any employee change the data? What are problems with that task?
Assume that you designed the field LengthOfTime in the Classes table in the Pitt Fitness database. The LengthOfTime field has data such as 60 minutes, 30 minutes, 1 hour, and 15 minutes. Is this the correct way to record this data? If not, what would be a better method?
Originally, Pitt Fitness had all their data in one large Excel spreadsheet. Suppose you were hired to help Pitt Fitness create a database to replace the spreadsheet. Outline the major steps you would perform to create a normalized database from the data in the spreadsheet.
Write the Pitt Fitness database in DBDL notation.
What prevents a user from entering a reservation for a customer who has not yet been registered in the Customers table?
Pitt Fitness would like to analyze their options for an in-house database versus a cloud database-as-a-service. What are the benefits to moving their database to the cloud?
Create a data integrity constraint for the Pitt Fitness database that only allows a user to enter one of the three fitness locations into the Classes table.
The database administrator at Pitt Fitness wants to develop and test new applications. What is the safest way to do this, considering the company has customers reserving classes frequently?
Considering that Pitt Fitness is a small company, what type of backup site would be appropriate for their smaller budget?
Pitt Fitness would like to enhance their web presence and enable the exchange of data on the web. What type of markup language should they use and why?
Describe some of the big data that Pitt Fitness might collect and find useful.