A example of the employee in mysql, including 6 tables:
Employee: there are employee number, name, gender, etc information
Dept_emp: have employee number, department number and staff belong to department of commencement date
Department: department number and department name
Dept_manager: department of information management personnel, containing department number, management personnel number and commencement date
Titles: staff number, and the staff's title and the title of the commencement date
Salary: staff number, salary and get the date of beginning and ending salary

To use the star model example, the following three problems:
1) companies each employee's monthly salary is how much?
2) which department on every month salary is higher?
3) what kind of title get a monthly salary is higher?
How do I build this star model, to make a few dimension table? Key date dimension is what, a great god taught:

CodePudding user response:

, in 1, the staff number, name, department number, department name, title number, title name, pay
Weak give an opinion, this model do summary is not solved,

CodePudding user response:

Class 1501 or 1502 of the upstairs are

CodePudding user response:

The elder brothers pour! 100 minutes,,,,,,,, is one of their own, waiting for the great god

CodePudding user response:

Be I found
To beg!
According to teachers and students are bei...

CodePudding user response:

The fact table:
Date (month of wages) employee salary number department number title number

Dimension tables:
Employee number employee name
Department number department name
Title number title name

CodePudding user response:

Ha ha, 17 level is liu on data warehouse, and now faced with the homework

CodePudding user response:

Be a Lao ke do homework

CodePudding user response:

17 level to make a card

CodePudding user response:

Agree with the practice of the first floor, originally table field, less a fact table can solve the problem, why so many dimension tables, give yourself a bother in the back of the data extraction,
The database should follow the third paradigm, but cannot completely follow the third paradigm, data warehouse or to reduce the query speed, this is the space in time,

CodePudding user response:

Could you tell me where are you to participate in the training data warehouse?