Answer:
The answer is below
Explanation:
The the sql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales is:
SELECT S.CUS_CODE, T.TM_MONTH, S.P_CODE,
SUM(S.SALE_UNITS*S.SALE_PRICE) AS "TOTSALES"
FROM DWDAYSALESFACT AS S INNER JOIN DWTIME AS T ON S.TM_ID =
T.TM_ID
GROUP BY S.CUS_CODE,T.TM_MONTH,S.P_CODE WITH ROLLUP;
Answer:
Explanation:
Transitive dependency
In this case, we have three fields, where field 2 depends on field 1, and field three depends on field 2.
For example:
Date of birth --> age --> vote
Partial dependency
It is a partial functional dependency if the removal of any attribute Y from X, and the dependency always is valid
For example:
Course and student these tables have a partial dependency, but if we have the field registration date, this date will depend on the course and student completely, we must create another table with the field registration date to remove this complete dependency.
If we remove or update the table registration date, neither course nor student must not change.
When adding a header, you need to double tap the top of the document.
