AFM241 Study Guide - Midterm Guide: Data Warehouse
30 May 2018
School
Department
Course
Professor
Some minor differences in the name of the above figure
The tables “INVOICE” AND “LINE” in figure 5.12 have been replaced with “tOrders” and
“tOrderline” respectively in figure 5.13
The ERD is a prominent tool for designing production databases
Based on transactions such as the sale of books, the payment of a loan, the enrollment of
courses
DSS databases used today are more complex and require multidimensional information that cannot
always be modeled in the form of an ERD, therefore a process known as multi-dimensional modeling
was developed for data warehouse design
Product Order Module
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
Some minor differences in the name of the above figure. The tables invoice and line in figure 5. 12 have been replaced with torders and. The erd is a prominent tool for designing production databases. Based on transactions such as the sale of books, the payment of a loan, the enrollment of courses. Dss databases used today are more complex and require multidimensional information that cannot always be modeled in the form of an erd, therefore a process known as multi-dimensional modeling was developed for data warehouse design. This is the product module in bluebikes database. The following steps/items apply to a typical product order process: All products are ordered from vendors which are listed in the vendor table. Bluebikes, will create a product order and sends it to the vendor. This leads to a new entity called order. It is possible that not all vendors will receive an order or have not yet received one.
