Jeffrey Diaz
2/08/2024
ISM 3212
Professor Dugan
Module 5 Pitt Fitness Critical Thinking Questions
1.
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?
a.
I would not recommend using varying units within the same field (LengthOfTime) as suggested as this is not a good idea. The best option would be
converting all times into minutes without the use of hours and minutes. This will keep things consistent and make any querying much easier as well as optimizing the efficiency in side the database. 2.
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.
a.
Data Analysis – You would need to analyze any existing data in the spreadsheet so
you could identify any key elements that will be used in the database.
