Q 1. While designing a data model for an insurance company , we came across the situation where we are making relationship between customer entity and dependent entity(the one who are dependent on customer) for which the company is providing insurance but the primary key of dependent entity is comprised or primary key of customer and a partial key ? why is there such situation in the data model?
Q 2. We are designing a datawarehouse for a pet supplier chain which sells products for dogs ,cats and rabbits ,which is the best way to avoid many to many in this scenario where are dealing with only three different types of pets.
Q 3. We have been asked to design an audit dimension for a Sales fact , which are the key elements which we should include in our design?