Explain the business process

Assignment Help Database Management System

Reference no: EM132983579

Advanced Database Systems

Review Questions

With the rapid development of business, information that has analytical capabilities is needed. Imagine how a retail company (supermarket/hypermarket) works with thousands or even millions of items. How much capital do they have to spend if they have to buy to stock all these items. Maybe some of you know that not all goods in retail companies are purchased by themselves, many of which are consignment.

Apart from all that, you as a Master Candidate, are asked to use your knowledge and your analytical power to advise top executives of the company about the DWH architecture and the form of Data marts and Metadata to support the required analytic information.

So your task is;
- Choose only one and explain the Business Process (Such as the sales side of the customer) and Explain the Background and Problem Issued why you choose that business process.
- Draw the Architecture of your proposed Data Ware House (DWH).
- Create Metadata for Dimension Tables and Fact Tables (You Can Got the Data From Internet, Your Previous Project, or Build Dummy Data for it).
- Draw the Entity Relationship Diagram (ERD) of your Proposed Data Ware House (DWH) and Explain it.
- Draw the Star Schematic and Explain it.

Reference no: EM132983579

Questions Cloud

Calculate profit and loss on sale : At the beginning of June your company has 180 units of good A measured at 280 USD/unit. Calculate profit and loss on sale

Safe design standard operating procedure : Safe Design Standard Operating Procedure - Your standard operating procedure document must ensure these requirements are met in the designs

What is the cost of equity : The common stock of ABC Company has a beta of 1.10. If the expected return on the market is 10% and the risk-free rate is 5%, what is the cost of equity

Obtained the expected after-tax rate of return : The company decided to sell the equipment for $180,000 at the end of 4 years. Determine if the company obtained the expected after-tax rate of return

Explain the business process : Explain the Business Process (Such as the sales side of the customer) and Explain the Background and Problem Issued why you choose that business process

How would you report it in the cashflow statement : This equipment originally cost $ 24,000 and had a book value of $ 14,000 at the date of sale. How would you report it in the cashflow statement

Effect of state court dismissal of discrimination complaint : What is the effect of a state court's dismissal of a discrimination complaint on the complainant's right to file suit in federal court? What is the effect of a

List of six major competencies : The key HR roles, competencies, and areas of expertise. Explain whether you agree with the list of six major competencies:

Role of supervisors in performance appraisal of employees : You are the HR manager for an accounting firm. What is the difference between your role and the role of supervisors in Performance Appraisal of employees?

User Account

All Pages