Phase 1. -
using the information shown in bus
matrix table, make a first-draft, high-level dimensional model to represent the fact table and dimensions tables that will form the data warehouse for the university.
phase 2 - Identify all dimension and fact attributes for the DM
Using the information in the BUS matrix table, produce a dimensional model as a star schema for the student module results business process. (only one DATA MART)
A. Based on your (assumed) knowledge of this business process as a current or past student, add a maximum of five (possible )attributes to each dimension table in your schema.
b.The star schema by adding a maximum of 10(possible) attributes to your fact table.
c. Describe how your choice of attributes can support the analysis of student result.
Recently Asked Questions
- 1. SELECT statement that returns these columns from the Orders table: The order_id column The order_date column A column named approx_ship_date that's
- Case 1 - SSN - > LastName, FirstName Case 2 - SSN, LastName - > FirstName Both Case 1 and Case 2 are examples of functional dependency. Only Case ! is an
- Tables Division( DID, dname, managerid) Employee( Empid , name, salary, did(fk)) Project( Pid , pname, budget, did(fk)) Workon( Pid, empid , hours) I tried