Decesion support schema

Design a star schema, snow flake schema, face constellation schema for the data warehouse that consist of the following four dimensions: (doctor, Patient, disease, Location).

Association Mining

Find all frequent item sets for the given training set and support count SC=2 using Apriori and FP-growth, respectively. Compare the efficiency of the two mining process. Tran ID Items Purchased I1 {M,O,N,K,E,Y} I2 {D,O,N,K,E,Y} I3 {M,A,K,E} I4 {M,U,C,K,Y} I5 {C,O,O,K,I,E}