volume_mute
Identify the inconsistency between the two tables
publish date: 2025/09/05 22:21:3.507778 UTC
volume_mute
These two tables have been purposely kept redundant to improve query peformance. However, the DBMS controls were not effective. Can you identify which attribute is inconsistent?
STUDENT TABLE
| number | name | class | major |
| 17 | Smith | 1 | CS |
| 8 | Brown | 2 | CS |
GRADE REPORT TABLE
| number | name | identifier | course | grade |
| 17 | Brown | 112 | MATH2410 | B |
Correct Answer
The student name is 'Brown'
Explanation
The grade report table has a student number of 17, but according to the student table, the student with number 17 is named 'Smith', not 'Brown'. This is an inconsistency that would be prevented if the DBMS controlled the redundancy between the STUDENT and GRADE_REPORT files.
Reference
Fundamentals of database systems (7th edition)