Use the following relation & functional dependencies to answer the questions. First Normal Form (1NF): Each relation
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the following relation & functional dependencies to answer the questions.
- First Normal Form (1NF):
Each relation has a primary key, all attributes are atomic (no repeating groups), and all attributes are Functionally Dependent on the primary key.
- Second Normal Form (2NF):
Each relation is in 1NF, and there are no Partial Functional Dependencies.
- Third Normal Form (3NF):
Each relation is in 2NF, and there are no Transitive Functional Dependencies.
Functional Dependencies
StudentID ➡ FirstName, LastName, StateCode
StateCode ➡ StateName
CourseID ➡ CourseName
StudentID, CourseID, Semester ➡ StudentGrade
- Describe the data anomalies you would be exposed to if you were to store your data in the table above.
- Is the table in First Normal Form (1NF)? If so, what is the Primary Key?
- Convert the model to Second Normal Form (2NF).
- Convert the model to Third Normal Form (3NF).
Expert Answer:
StudentID FirstName LastName StateCode StateName CourseID CourseName Semester Grade 1 Kody Johnson UT Utah 4410 Information Systems Fall 2019 B 2 Willy Lopez AZ Arizona 4415 Data Structures and Java F... View the full answer
Related Book For 
Posted Date:
