Thanks for quick response.

yes, its Visio related issue. 😐

thanks

I am using Visio 2007 Professional and it seems VISIO doesn't allow relating a single column (from parent table) to 3 different columns. It associates with Either ColA or ColB...

yeah, i am creating 'glue' tables for defining many to many relationship.

I think this approach makes model more flexible -- adaptive to future changes.

ERwin & Visio:

That is so true.

Erwin is...

Its helpful.

I got your point

Thanks

Loner,

Working for an education Dept, I have to design a data model for a DB containing information about students, teachers, courses, accomodation, discipline, attendance, schedule, testscores, Parent/Gaurdian information etc.

Here, the...

Jack,

I also feel option 2 is better. It provides flexibility. thanks

But before that, I am trying to resolve the issue of MIGHTY PKs. I feel resolving this issue can...

Hi Jack,

Multiple addresses exists for single student. So, basically it is One to Many relationship between studentId and Address.

But then so....?

I didn't get implications by such relation

thanks

Thanks for your inputs. I appreciate your time & thoughts

Well, not sure about the multiple address. need to research on that aspect.This is going to be first draft...

So, trying to...

Hi

I am also working in similar environment.

Regarding # of students in particular grade Or achieving particular grade, I think Fact table should have student ID as one of...

yeah, I also came to same conclusion.

I came across this article: which explains advantages of having surrogate keys.

http://www.dbmsmag.com/9805d05.html

While going through some articles, it seems for generating...

Hi Steve,

I have a question. I don't have much experience with SQL server..so, I am not sure about my conclusions. I would appreciate if you have any inputs for me...

I don't think that is possible. One should go with creating surrogate key for DIM table.

however, i still have doubt regarding dealing with composite PKs as in.. creating SKs

Sorry!

damn...its standard edition. my bad

Sorry for missing out on providing more information.

Its Windows XP, professional, SP2

SQL server -- Enterprise edition

NO IIS

Any other info you need?

thanks

Steve,

I was caught up in some other issues, hence, slow in responding..

Thank you so much for your invaluable inputs.