Given the following record structure, identify the data redundancy issues: ? BUI
ID: 3782987 • Letter: G
Question
Given the following record structure, identify the data redundancy issues: ?
BUILDING CODE ROOM CODE TEACHER LNAME TEACHER FNAME TEACHER INITIAL DAYS TIME KOM 204E Williston Horace G MWF 8:00-8:50 KOM 123 Cordoza Maria L MWF 8:00-8:50 LDB 504 Patroski Donald J TTh 1:00-2:15 KOM 34 Hawkins Anne w MWF 10:00-10:50 IJKP 225B Risell James TTh 9:00-10:15 LDB 301 Robertson Jeanette P TTh 9:00-10:15 KOM 204E Cordoza Maria I MWF 9:00-9:50 LDB 504 Williston Horace G TTh 1:00-2:15 KOM 34 Cordoza Maria L MWF 11:00-11:50 LDB 504 Patroski Donald J MWF 2:00-2:50Explanation / Answer
In the given table you cannot decide what is your primary key, because every column has some values repeating twice or more. So if you look in the table you can notice easily that Maria Cordoza's details like TEACHER_FNAME, TEACHER_LNAME, ROOM CODE, BUILDING CODE are all same for three fields because see sits in the same staff room and same building but only because she is taking three classes her name is appearing 3 times, suppose she was taking 50 classes what would have been happened?, table would have been flodded with almost same data at every row and person who is taking a glance at the table or database could not understand a word. That is data redundancy. Storing the same field values more than once (unnecessarily) is referred to as data redundancy.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.