Given the following table of students, assignments, and grades for a single class: Student ID Student_Name Assignment_1_Date Assignment_1_Name Assignment_1_Grade Assignment_2_Date Assignment_2_Name Assignment_2_Grade Assignment_3_Date Assignment_3_Name Assignment_3_Grade Susan J. Smith 2015-06-01 1011 2015-06-05 Chapter 7 Quiz 88 2015-06-12 Homework Chapter 76 Seven Homework - A Chapter 8 2332 Jones, Jamal K. 2015-06-01 Homework - Chapter 84 2015-06-05 Quiz - Chapter 7 89 2015-06-12 Seven Homework - Chapter 8 95 3432 Brown, Ronald 2015-06-01 Homework Chapter 66 Seven 2015-06-05 Quiz - Chapter 7 78 2015-06-12 Homework - Chapter 8 B 5435 Killen, Katie 2015-06-01 Homework Chapter 97 Seven 2015-06-05 Chapter 7 Quiz 95 2015-06-12 Homework - Chapter 8 94 7574 Powell, B. 2015-06-01 Homework Chapter 68 Seven 2015-06-05 Quiz - Chapter 7 89 9677 Pat Hayes 6/1/2015 Homework - Chapter 89 Seven 2015-06-05 Quiz Chapter 7 85 2015-06-12 Homework - Chapter 8 99 Examine the data in the table above and identify any columns that contain data inconsistencies. Place an X in the Consistent or Inconsistent column.

icon
Related questions
Question
Given the following table of students, assignments, and grades for a single class:
Student ID Student_Name Assignment_1_Date Assignment_1_Name Assignment_1_Grade Assignment_2_Date Assignment_2_Name Assignment_2_Grade Assignment_3_Date Assignment_3_Name Assignment_3_Grade
Susan J. Smith 2015-06-01
1011
2015-06-05
Chapter 7 Quiz
88
2015-06-12
Homework Chapter 76
Seven
Homework -
A
Chapter 8
2332
Jones, Jamal K. 2015-06-01
Homework - Chapter 84
2015-06-05
Quiz - Chapter 7
89
2015-06-12
Seven
Homework -
Chapter 8
95
3432
Brown, Ronald 2015-06-01
Homework Chapter 66
Seven
2015-06-05
Quiz - Chapter 7
78
2015-06-12
Homework -
Chapter 8
B
5435
Killen, Katie
2015-06-01
Homework Chapter 97
Seven
2015-06-05
Chapter 7 Quiz
95
2015-06-12
Homework -
Chapter 8
94
7574
Powell, B.
2015-06-01
Homework Chapter 68
Seven
2015-06-05
Quiz - Chapter 7
89
9677
Pat Hayes
6/1/2015
Homework - Chapter 89
Seven
2015-06-05
Quiz Chapter 7
85
2015-06-12
Homework -
Chapter 8
99
Examine the data in the table above and identify any columns that contain data inconsistencies. Place an X in the Consistent or Inconsistent column.
Transcribed Image Text:Given the following table of students, assignments, and grades for a single class: Student ID Student_Name Assignment_1_Date Assignment_1_Name Assignment_1_Grade Assignment_2_Date Assignment_2_Name Assignment_2_Grade Assignment_3_Date Assignment_3_Name Assignment_3_Grade Susan J. Smith 2015-06-01 1011 2015-06-05 Chapter 7 Quiz 88 2015-06-12 Homework Chapter 76 Seven Homework - A Chapter 8 2332 Jones, Jamal K. 2015-06-01 Homework - Chapter 84 2015-06-05 Quiz - Chapter 7 89 2015-06-12 Seven Homework - Chapter 8 95 3432 Brown, Ronald 2015-06-01 Homework Chapter 66 Seven 2015-06-05 Quiz - Chapter 7 78 2015-06-12 Homework - Chapter 8 B 5435 Killen, Katie 2015-06-01 Homework Chapter 97 Seven 2015-06-05 Chapter 7 Quiz 95 2015-06-12 Homework - Chapter 8 94 7574 Powell, B. 2015-06-01 Homework Chapter 68 Seven 2015-06-05 Quiz - Chapter 7 89 9677 Pat Hayes 6/1/2015 Homework - Chapter 89 Seven 2015-06-05 Quiz Chapter 7 85 2015-06-12 Homework - Chapter 8 99 Examine the data in the table above and identify any columns that contain data inconsistencies. Place an X in the Consistent or Inconsistent column.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer