So i got data warehouse subject. And one of the assignment is to install microsoft sql server, and do some…