Introduction of the term non-additive facts
Give a brief introduction of the term non-additive facts?
Expert
The facts which can’t be summed up for the dimensions there in the fact table are named as non-additive facts . The facts can be functional if there are alters in dimensions. For illustration, profit margin is a non-additive fact for it has no importance to add them up for the account level or day level.
When is a functional dependency F considers as to be minimal?
States the term second normal form?
Describe briefly the ‘paradigm mismatch’ among SQL and application programming languages.
What is Data Manipulation Language?
What is OLAP? Briefly define it.
Name the methods and types of Collision Resolution Techniques used in each of the type?
Describe some of the major objectives of normalization?
Explain about Server Job and Parallel Jobs?
Write down the some of the important security characteristics of a DBMS?
What can be done with the Data Stage Director?
18,76,764
1954334 Asked
3,689
Active Tutors
1434001
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!