Question: Please open and review the spreadsheet table linked below, which is a fictitious example of a ( bad ) scheduling system for tracking instructors and
Please open and review the spreadsheet table linked below, which is a fictitious example of a bad scheduling system for tracking instructors and their classes. You can open it with Excel or Google Sheetsyou're just going to look at it
BLDCODE ROOMNUM INSTRLAST INSTRFIRST INSTINI TIME
FSB PALMISANO JAY J TTh ::
FSB CAMET SOPHIE L MWF ::
HAL SAMUELS MARK G TR ::
FSB LINK JENNA TR ::
LAWS Tse Annie G TR ::
HAL SIMPSON GENE N MWF ::
FSB CAMET SOPHIE L TR ::
HAL PALMISANO PAUL J TR ::
FSB CAMET SOPHIE I TTh ::
HAL SAMUELS MARK TR ::ntify at least data quality issues with the data as it is intended to be used. In the text box below, briefly describe these problems one sentence each You should then provide a brief answer to each of the following questions one or two sentences each:
How might data redundancy have caused some of these problems?
Considering the TIME column, how might we make this data more useable by converting the column to multiple fields in a database table?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
