Create a 3NF Relational Schema for the given data,

and indicate primary/foreign keys as shown in the attached img

  

Transcribed Image Text:

Full Dependency PEPPE Student Birth Date Student Firstname Student Lastname Student Full Dependency Phone Course Data Course Name Classroom Transitive Dependency Course Credits Transitive Dependency Final Grade% Letter Grade Instructor Office Full Dependency Instructor Instructor Office Home Phone Phone Partial Dependency Partial Dependency Full Dependency PEPPE Student Birth Date Student Firstname Student Lastname Student Full Dependency Phone Course Data Course Name Classroom Transitive Dependency Course Credits Transitive Dependency Final Grade% Letter Grade Instructor Office Full Dependency Instructor Instructor Office Home Phone Phone Partial Dependency Partial Dependency

Answer rating: 100% (QA)

3NF Relational Schema for the given data Student StudentPhone Student Firstname StudentLastname Stu... View the full answer