Given the functional dependencies: UserId -> UserFullName ProductId -> ProductCampaign PromotionId -> PromoDescription U

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Given the functional dependencies: UserId -> UserFullName ProductId -> ProductCampaign PromotionId -> PromoDescription U

Post by answerhappygod »

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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply