Use the Academic Database Entity Relationship Diagram to: Identify the unique identifier for each table by placing an X in the appropriate column
Give an example of data that might exist in each field for the table
List the appropriate data type for each field in the table
Student Course Fields Unique Identifier? Sample Data Data Type and Size
Student ID
Course ID
Student Fields Unique Identifier? Sample Data Data Type and Size
Student ID
First Name
Student Reg Year
Student Email
Faculty Course Fields Unique Identifier? Sample Data Data Type and Size
Faculty ID
Course ID
Department Fields Unique Identifier? Sample Data Data Type and Size
Department ID
Department Name
HOD (Head of Department)