I Have A Star Schema With One Fact Table Date Student Course Test And Both The C (1)

I have a star schema with one fact table (Date, Student, Course, Test) and both the course and test dimension have date attributes in them and I was wondering if I just keep the dates as attributes in both dimensions or if I take all the date attributes out and have to make separate facts for a Test Date dimension and a Course Date dimension?

Leave a Reply

Your email address will not be published. Required fields are marked *