In one sense, yes I was asking about data warehousing approaches, but what I was really looking for is an explanation of the type of table that I described and...

I don't think a Star Schema accurately reflects what I'm seeing in my table. Are you sure that's the type that's used in my situation? Again, I have a lot...

GSquared, how would one report off of a structure like that? I suppose you could use derived tables, only selecting 2 columns at a time. For example:

SELECT program, major

FROM Programs

WHERE...

It's not homework, it has to do with academic programs.

Shirt = Program (e.g. BS in Math)

Year = Academic Year

Color = Major

Size = Specialization

The number of rows per program in the...

opc.three (2/24/2011)

---

I would designate the values you have for Products (Shirt), Colors (Green, Blue, etc.) and Sizes (S, M, L, etc.) as "natural keys". Surrogate keys (IDENTITY) are my preferred...

It seems odd though that I'd have to normalize it just to turn around and denormalize again, right?

And yes, I agree the xref table will have the same number of...

Craig,

Thanks for your explanation. Your recommendations make sense, so I'll dig a little deeper with those.

CELKO,

Thanks for the input, but I think you are looking too far into this. My...

GSquared, I feel the exact same way about it. I'm contemplating not going through the trouble of getting it sorted properly since it will end up being the most lines...

GSquared (12/29/2010)

---

SQL Challenge 46, right?

The answer is, only the person who wrote it knows what they meant, and they haven't replied yet. So, nobody knows.

Thus far, the guesses on...

Both of you are correct. It makes the most sense to add PersonID to the Positions table. However, based on how this administrative interface works, it looks like it NEEDS...

Unfortunately, there is no other way to determine their relationship.

Initially, this database was modeled differently (made a lot more sense and would not have caused this problem). However, it was...

I should have specified. Yes, there are more columns in the Positions table that differentiate the rows, such as Phone number, Preferred title, etc.

Also, I'd rather not use a cursor....

Ok, I'll try to make it a little more clear. Let's say I have Jim Smith and John smith in the People table:

ID, EmployeeID, LastName, FirstName

1, M1234, Smith, Jim

2, M2222,...

This may already have been answered, but you can use database mirroring in conjunction with transactional replication, correct?

Thanks for the response Perry!

I'm not sure I understand the difference between transactional replication and database mirroring, but I don't mind using mirroring on the cluster if that will keep...