You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data: You need to normalize the data to third normal form. How many tables should you create?
The third normal form eliminates columns that are not dependent on the column that contains the key. Here the primary ingredient and category column are not entirely dependent on RecipeName (which holds the key), two other tables should be created for either.
three tables. ID with Category, ID with Primary Ingredient, ID with Recipe Names. SInce ID is the Primary key It will uniquely identify each table row.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
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.
NinjaTurtle
Highly Voted 5 years, 3 months agopatryk106
4 years, 4 months agowelr348jhnksdf
Highly Voted 4 years, 4 months agodzoni68
Most Recent 3 years agoTalhaaz
3 years, 4 months ago