Question: Given the same Product table as previously: Product ( ProductID ( PK ) , ProductName, Price, SubCategoryName, CategoryName, CategoryDescription ) with functional dependencies ProductID ProductName,
Given the same Product table as previously:
Product ProductIDPK ProductName, Price, SubCategoryName, CategoryName, CategoryDescription
with functional dependencies
ProductID ProductName, Price, SubCategoryName
SubCategoryName CategoryName
CategoryName CategoryDescription
Which of the following are correct?
The following would be a rd NF version of the schema: ProductProductIDPK ProductName, Price, SubcategoryNameFK; SubCategorySubCategoryNamePK CategoryNameFK; CategoryCategoryNamePK CategoryDescription
The initial Product table is in rd Normal Form
The initial Product table is in nd Normal Form
The following would be a rd NF version of the schema: ProductProductIDPK ProductName, Price, SubcategoryNameFK; SubCategorySubCategoryNamePK CategoryName, CategoryDescription;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
