You are an administrator of a state university and want to create a data warehouse for analytics on graduated students. The data warehouse keeps track of numbers of graduated students with various degrees from various schools/colleges (business, engineering, humanity, science, medical, law, etc.) in last 30 years (from 1991-2021, students usually graduate in Fall, Spring or Winter each year). You wanted to know which college/school they graduated from. There are several types of degrees offered to students: BS, BA, MS, MA, MBA, PhD, EdD, MD, JD, etc.

(a) Create a star schema based on the above narrative. Note, this schema is expressed by an ER model. Each entity represents a table. Clearly indicates maximum cardinalities, attributes, primary keys and foreign keys.