Table 5 An example of a de-normalized ADR warehouse composed of six reports
Demo_key | Year | Age | Gender | Weight | Country | Drug | PT |
|---|---|---|---|---|---|---|---|
1 | y 3 | a 2 | g 1 | w 2 | c 3 | d 1 | s 1 |
1 | y 3 | a 2 | g 1 | w 2 | c 3 | d 2 | s 1 |
1 | y 3 | a 2 | g 1 | w 2 | c 3 | d 3 | s 1 |
2 | y 1 | a 1 | g 2 | w 2 | c 1 | d 2 | s 2 |
2 | y 1 | a 1 | g 2 | w 2 | c 1 | d 3 | s 2 |
3 | y 2 | a 2 | g 2 | w 2 | c 2 | d 1 | s 1 |
3 | y 2 | a 2 | g 2 | w 2 | c 2 | d 3 | s 1 |
3 | y 2 | a 2 | g 2 | w 2 | c 2 | d 1 | s 2 |
3 | y 2 | a 2 | g 2 | w 2 | c 2 | d 3 | s 2 |
4 | y 1 | a 2 | g 1 | w 1 | c 3 | d 1 | s 1 |
4 | y 1 | a 2 | g 1 | w 1 | c 3 | d 3 | s 1 |
5 | y 1 | a 1 | g 2 | w 1 | c 2 | d 2 | s 1 |
6 | y 3 | a 2 | g 1 | w 2 | c 1 | d 2 | s 3 |