Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Oracle Discussions

Exam 1z0-882 topic 1 question 53 discussion

Actual exam question from Oracle's 1z0-882
Question #: 53
Topic #: 1
[All 1z0-882 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
Reference:
http://stackoverflow.com/questions/1258743/normalization-in-mysql
by lorrazen at Jan. 17, 2020, 2:18 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
ekpo
2 years, 10 months ago
Answer is A.Normalize with two tables and add a FK
upvoted 1 times
...
lorrazen
4 years, 3 months ago
not B?
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel