An application tracks usage of educational courses in a company. Many people can take one
course. Each person can take multiple courses. The data has been stored in one table but it
is growing too large. You decide to normalize the table.
What would a normalized data model contain?
A.
Two tables: employee and course, with foreign keys on employee ID and course ID.
B.
Three tables: employee, course, and a table cross-referencing employee IDs and course
IDs
C.
Two tables: an employee table with multiple course IDs , and a course table
D.
Four tables: employee, course, courses by employee, and employees by course
Explanation:
Reference:
http://stackoverflow.com/questions/1258743/normalization-in-mysql
B —> see n to m relation
B
https://www.youtube.com/watch?v=GJbtDTGmOGY
Watch this video if you have problem with many to many relationship.