Deeps-965988 (4/24/2011)

---

Yes, I did ask them and they said that OBIEEE was a more standard reporting tool as compared to SSRS.

I am familiar with SSRS, worked on it for a...

Welsh Corgi (4/23/2011)

---

I have listed some information concerning the questions that you asked.

The definition of the following terms are as follows:

Data Warehouse: They use a Dimensial Data Model as opposed...

GSquared (4/26/2011)

---

Here's the definition I'm citing:

According to Date's definition of 1NF, a table is in 1NF if and only if it is "isomorphic to some relation", which means, specifically, that...

tabraham 36699 (4/26/2011)

---

I think the point to remember about theory vs practice is that theory explains the ideal, and CONSEQUENCES of not following the rules laid out by it. Practice...

GSquared (4/25/2011)

---

Steven: You do realize that your address lines table violates 1NF, right? Rows are specifically ordered within the data (you even have a column for that), which Date...

keshabheda (4/21/2011)

---

Hi All,

I ran across the issue which is stated in this topic. Two tables having primary key as foreign key to each other.

My problem is I want to insert...

Bear in mind that ERDs may be created for different purposes. Sometimes the purpose of an ERD is A: to model the Universe of Discourse. Sometimes the purpose is B:...

Tom.Thomson (4/11/2011)

---

On a somewhat related topic, I occassionally wonder how best to put together a proposal to allow Foreign Keys to reference multiple columns (when I'm not wondering that it's...

Null does not mean unknown according to...

martin catherall (4/11/2011)

---

for example, take a list of people where their birth date is stored in one column and the date of their death stored in another. That's fine for...

Tom.Thomson (4/7/2011)

---

I wonder if other people have seen Hugo's connect proposal to change SQL Server for the worse so that it conforms to the SQL standard on this - ...

Tom.Thomson (4/7/2011)

---

I regard anyone who allows NULL in unique columns as crazy (presumably David you agree with me, as you think anyone who allows NULL anywhere is crazy). I...

StudentID is nullable and so the Students table does not have a key at all (candidate keys do not permit nulls). Therefore the StudentID column in ClassList is actually not...

In a SQL database maybe, not in a relational one with decent constraint support. You don't need extra tables to restrict data...

If you call...