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:
The veins carry oxygen depleted blood away from body parts, hence the color blue.
Explanation:
Answer:
Software development life cycle is about building a software (“only”) in a phased approach systematically.
System development life cycle is about implementing hardware and software in a phased manner systematically.
Explanation:
Here both the hardware and the software is considered as a system.
Hope this helps!
Answer:
The database models depend very much on what will be the use in the business logic of the company will have directly with the database, primarily implying whether or not to use a relational or non-relational database.
Explanation:
In relational databases there is something called normalization, which after the construction of a data model allows me to optimize in a greater way the way in which I will make the queries within this database, that is a fundamental aspect, since one of the fundamental aspects today about the business logic of companies with databases is the capacity to respond when waiting for a query and if it is delayed a lot there will be inconvenience with the expected result.
Currently there are different examples of in which scenario what kind of database is better, distributed, centralized databases, clusters is.. And it is where you need to be very clear about what is my business and what type of database is adapted more to be.
I hope I could help you.
