Oracle Database MySQL 5.6 Developer — Question 12

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?

Answer options

• 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

Correct answer: A

Explanation

The correct answer is A, as it effectively separates the entities into two distinct tables, which helps eliminate redundancy and maintain data integrity by using foreign keys. Option B introduces an unnecessary third table, while option C fails to properly normalize the data by allowing multiple course IDs in one table. Option D adds complexity without improving the structure.