Generally speaking,for a weak entity set to be meaningful it must be part of a 1. one-to-one relationship 2. one-to-many relationship 3. many-to-many relationship 4. depends on a particular situation
Latest Answer: Star schema - normalized one snow flake-denormalized ...
Latest Answer: Data sparsity is term used for how much data we have for a particular dimension/entity of the model. It affects aggregation depending on how deep the combination of members of the sparse dimension make up. If the combination is a lot and those combinations ...
What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
Latest Answer: When there are performance issues, that would be improved by denormalizing the database. ...
Latest Answer: Entity-Relationship diagram ...
Latest Answer: False, all databases need not be in 3NF, however in most cases in the business world databases tend to be in 3NF or BCNF ...
Latest Answer: 3NF allows transitive dependency ...
Latest Answer: We have used a different way of maintaning recursive relationship. We have created a ancestry table which will give the childs for each entry upto n th level. This way you can fire queries directly to get the child upto any specific level. ...
Latest Answer: It is a system-assigned number that is unique for each row of data in a table. It is used by database administrators to allocate rows of evenly and efficiently on data storage / servers. ...
View page << Previous 1 [2] 3 Next >>

Go Top