I am very new in data modelling. Sorry in advance if it is a silly question.
I have to design an star schema. I have one table "A" that has its PK and some attributes.
Another "B" table has it's own PK and some attributes in it, but it also has one Parent Key, this Parent key actually an equivalent of PK of Table "A".
I have to join table A as a dimension with Fact table. I am confused where to join Table B with? Either with Table A as Parent/child relationship? or with fact table?
I want to do reporting on both of them. They don't have any measures in them.
Please advice what should I do.
All i see are 3 tables .. with total of 4 pk .
what are these count max, min , avg columns for ? the hold what values
I am not an student but a new to this field.
I have to model a structure like Star Schema.
This is something to analyze the performance of the systems and the crystal reports running.
How many times a report (and/or its instances) was viewed in a day or a week or a month and so.
What is the average and min.and max time a report (and/or its instances)
was viewed in a day or so.
Report information is in Table A and the report instances information is in Table B.
Table A and Table B are in parent/child relationship, but both of them have their own Primary Keys (PK).
Table B has one ParentID field that corresponds to PK of Table A.
There are other tables also involved like security, users and usergroups. I have to make all of them dimensions but I leaving that piece for later.