Recent content by Ianthelmt

So maybe I should then delete student table and make just the registration tabke, with the addition of student ID field, studentFirstName, StudentLastName fields?

As far as I know, the Reporting must be possible by campus and course. The instructions I was given state that the reg data extracted from the online trans. system will be summ'd by term. I am told to assume that the reg. counts already exist, ie the process by which info is extracted has...

Hi pat, sorry I had realized I uploaded the wrong one. the link should be correct now!

Okay here is attempt no. 1. I hope I am at least on the correct track... Any input on attempt no. 1 would be much appreciated!

Yes, that is correct. Okay excellent. That is my step no. 1 then. I appreciate the direction. I will try and work on it tomorrow. It is due next Sunday so I have a good deal of time to tinker. Now as far as creating tables, I need to brush up on creating the dimension tables(i assume these...

Hello, I am trying to create a star schema but I am a bit lost. I dont even know where to start and this is very confusing to me. I have attached an Access example of what it should look like, but I have no idea how to translate this data into such a design. Can anyone help me? Here are my...