Oracle
1Z0-882 · Question #46
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…
The correct answer is B. Three tables: employee, course, and a table cross-referencing employee IDs and course IDs. See the full explanation below for the reasoning.
Question
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?
Options
- ATwo tables: employee and course, with foreign keys on employee ID and course ID.
- BThree tables: employee, course, and a table cross-referencing employee IDs and course IDs
- CTwo tables: an employee table with multiple course IDs , and a course table
- DFour tables: employee, course, courses by employee, and employees by course
How the community answered
(43 responses)- A9% (4)
- B72% (31)
- C14% (6)
- D5% (2)
Community Discussion
No community discussion yet for this question.