Perform Normalization on the database below, and explain (Describe the information requested in narrative form about Normalization
Question:
Perform Normalization on the database below, and explain (Describe the information requested in narrative form about Normalization steps you use to create an efficient and a functional database). The process must include creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Given a poor database design turn the unstructured data into a properly designed set of tables an data elements.
Test | Student | Date | Totalpoints | Grade | Testformat | Teacher | Assistant |
Pronoun Quiz | Amy | 2022-03-02 | 10 | 8 | Multiple Choice | Smith | Collins |
Pronoun Quiz | Jon | 2022-03-02 | 10 | 6 | Multiple Choice | Jones | Brown |
Solids Quiz | Beth | 2022-03-03 | 20 | 17 | Multiple Choice | Kaplan | NULL |
China Test | Karen | 2022-02-04 | 50 | 45 | Essay | Harris | Taylor |
China Test | Alex | 2022-03-04 | 50 | 38 | Essay | Harris | Taylor |
Grammar Test | Karen | 2022-03-05 | 100 | 88 | Multiple Choice, Essay | Smith | Collins |
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall