They ask me to draw a diagram on 3rd. NF based on a file with a certain format he provided on the board that included fields like "Physician name", "date of service", "Physician type" , etc. I modeled and it was great then he ask me to do it on star schema based on reports he wanted to produce. The scenarios requested were nor clearly defined ( Again no clear direction or any specifics ) bottom line the interviewer was looking for an answer he didn't provide much information and made things really confusing to me to design. At the end I designed what I best understand with the information I had he told me he wanted me to build bridge tables as a solution . Which industry standard dictates that are obsolete and causes performance issues. So it was not the best solution after all.
