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 (ProductID(PK), 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 3rd NF version of the schema: Product(ProductID(PK), ProductName, Price, SubcategoryName(FK)); SubCategory(SubCategoryName(PK), CategoryName(FK)); Category(CategoryName(PK), CategoryDescription)
The initial Product table is in 3rd Normal Form
The initial Product table is in 2nd Normal Form
The following would be a 3rd NF version of the schema: Product(ProductID(PK), ProductName, Price, SubcategoryName(FK)); SubCategory(SubCategoryName(PK), CategoryName, CategoryDescription);
Given the same Product table as previously:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!