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 Sheets--you're just going to look at it).
BLD_CODE ROOM_NUM INSTR_LAST INSTR_FIRST INST_INI TIME
FSB 2050 PALMISANO JAY J TTh 2:50-4:10
FSB 1038 CAMET SOPHIE L MWF 8:309:50
HAL 568 SAMUELS MARK G TR 4:25-5:45
FSB 31 LINK JENNA TR 4:25-5:46
LAWS 222 Tse Annie G TR 2:50-4:10
HAL 1099 SIMPSON GENE N MWF 8:30-9:50
FSB 1023 CAMET SOPHIE L TR 4:25-5:45
HAL 144 PALMISANO PAUL J TR 4:25-5:46
FSB 19 CAMET SOPHIE I TTh 2:50-4:10
HAL 901 SAMUELS MARK TR 2:50-4:11ntify at least 5 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):
1. How might data redundancy have caused some of these problems?
2. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!