- 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.