so overall, is it ok with my schema?

I also wrote a query to insert huge amount of data from the relational schema into fact table.

insert into Fact_Table(DeptId, CrsCode, Id, SemesterId,...

Is it necessary to define the address as a hierarchy?

Also, do you mean these primary keys in those tables are redundant?

Hi, there are what I have done. can you check over for me if it's wrong?

//Create dimensional tables

create table [dbo].[Dim_Course](

[CrsCode] [char](8) not null,

[CrsName] [nvarchar](50) not null,

[Descr] [nvarchar](200)

Constraint [PK_Dim_Course] primary key...

I am using developer edition. I remembered that I checked on every thing provided and I dont know which one I have missed.

Oh, thank you for helping me.

that is what I am asking for. to create the database, can I use the normal way as relational database? and which table do I have to create first, dimensional...

you are great. honestly, this is one of my assignment, I just have to define a schema for the fact table, and the dimensional tables in SQL with the information...

that's right. I want to measure the number of students in class.