The Tables For The University

v Goal: Avoid redundancy

Avoid redundancy by keeping like information together in a table and linking to it when it is needed elsewhere

Bad design … in the Classes table, do not include instructor’s name, email, etc … rather link to the instructor information by ID