Investigate the following table recording of students and courses at a university and answer the following questions.
Fantastic news! We've Found the answer you've been seeking!
Question:
Investigate the following table recording of students and courses at a university and answer the following questions.
Will this table satisfy 1NF, 2NF, and 3NF? Explain why.
Give examples for insertion anomaly, deletion anomaly and update anomaly that may happen when using this table to record data.
Student_lD | Student_Name | Student_Age | Course_ID | Course_Name | Course_lnstructor | Course_Credits | Course_Department | Department_Location | Department_Head | |
1 | John | 20 | 101 | Math | Prof. Smith | 3 | Math | Building A | Prof. Johnson | |
1 | John | 20 | 102 | physics | Prof. Johnson | 4 | Physics | Building B | Prof. Adams | |
2 | Mary | 22 | 103 | Chemistry | Prof. Lee | 3 | Chemistry | Building C | Prof. Lee | |
3 | Mike | 19 | 101 | Math | Prof. Smith | 3 | Math | Building A | Prof. Johnson | |
3 | Mike | 19 | 104 | Biology | Prof. Davis | 4 | Biology | Building D | Prof. White | |
4 | Lisa | 21 | 105 | History | Prof. Wilson | 3 | History | Building E | Prof. Wilson | |
5 | Alex | 20 | 106 | English | prof. Turner | 3 | English | Building F | Prof. Turner | |
6 | Sarah | 22 | 103 | Chemistry | Prof. Lee | 3 | Chemistry | Building C | Prof. Lee | |
7 | Bob | 19 | 107 | Computer Sci. | Prof. Johnson | 4 | Computer Science | Building G | Prof. Adams | |
8 | Emily | 20 | 108 | Psychology | Prof. White | 3 | Psychology | Building H | Prof. White |
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: