2.4

2.4 Performance Assessment How many records does the file contain? 7 How many fields (attributes) are there per record? 5 What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? Cities are listed under the Data Manager attribute but the data would need to be manipulated to parse out the data (2NF) If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? The content in the Project Manager field would have to be pulled out and additional fields would need to be created. What data redundancies do you detect? How could those redundancies lead to anomalies? Multiple people on the same projects would result in redundant data. Human error in inputting data can lead to anomalies. Discuss the redundancies and anomalies caused by the design. Student names are repetitious. Input may differ from student input to student input. Stu_I D Stu_Name CodeClass NameClass CredHrs Instr_Name ClassDay s ClassTimes Room 5664 Kenardo Felix CIS223 Int. to DB 3 Marvin Million TTh 5pm- 10:30pm Online 5664 Kenardo Felix CIS403 Ethical Hacking 3 K. Flowers MW 5pm- 10:30pm Online 2716 Jacob Cook CIS223 Database I 3 M. Million TTh 5:30pm- 10:30pm 165 2716 Jacob Cook CIS230 Advance Cyber Security 3 Armstrong MW 5:30pm- 10:30pm 165 309 Antonio Diaz CIS223 Introductio n to Databases 3 Million, Marvin NTR 5:30 - 10:30 Virtual 309 Antonio Diaz CIS282 Web Interface Desing 3 Fuller, Charles NMW 5:30 - 10:30 Virtual 0057 Spencer Oswald CIS223 Introductio n to Databases 3 Marvin Million TTh 5:30 327 0057 Spencer Oswald CIS230 Advanced Cybersecur 3 Austin Armstrong MW 5:30 327