Examine the three tables with student data shown in Figure 9-1. Design a single-table format that will hold all of the data (non redundantly) that are contained in these three tables. Choose column names that you believe are most appropriate for these data.

 Figure 9-1

STUDENT DATA StudentNo LastName MI FirstName Telephone Status 123-45-6789 Enright T Mark 483-1967 Soph 389-21-4062 Smith R Elaine 283-4195 Jr STUDENT EMPLOYEE StudentID Address Dept Hours 123-45-6789 1218 Elk Drive, Phoenix, AZ 91304 Soc 8 389-21-4062 134 Mesa Road, Tempe, AZ 90142 Math 10