Given the functional dependencies:UserId -> UserFullNameProductId -> ProductCampaignPromotionId -> PromoDescriptionUserId, ProductId -> UserFullName, ProductCampaign,PromotionId, PromoDescription, MediaFormat
What is the set of table which will be created when thefollowing table is normalized to 3rd normal form?
UserPurchase (UserId, UserFullName, (ProductId,ProductCampaign), PromotionId, PromoDescription,MediaFormat)
A. UserPurchase((UserId, ProductId, Promotion-Id, MediaFormat)User(UserId, UserFullName)Product(ProductId, ProductCampaign)Promotion(PromotionId,PromotionDesc)
B. UserPurchase((UserId, ProductId, Promotion-Id, MediaFormat)User(UserId, UserFullName)Product(ProductId, ProductCampaign)Promotion(PromotionId,PromotionDesc)
C. UserPurchase((UserId, ProductId, PromotionId,PromotionDesc, MediaFormat)User(UserId, UserFull-Name)Product(ProductId, ProductCampaign)
D. UserPurchase((UserId, ProductId, PromotionId)User(UserId, UserFullName)Product(ProductId,ProductCampaign, MEdiaFormat)Promotion(PromotionId,PromotionDesc)
Given the functional dependencies: UserId -> UserFullName ProductId -> ProductCampaign PromotionId -> PromoDescription U
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am