Viewing 15 posts - 16 through 30 (of 431 total)
OCTom (8/6/2014)
For the OP:Here is a link with a straightforward explanation of the normal forms.
http://databases.about.com/od/specificproducts/a/normalization.htm
You should be able to create the 1st and 2nd normal forms from that explanation.
Tom
"Straightforward" but...
August 6, 2014 at 6:58 am
A common misconception about the idea of "NO-SQL" is that such products must be "non-relational". That isn't what NO-SQL implies however. The NO-SQL wave of products try to address limitations...
August 6, 2014 at 6:50 am
pietlinden (8/5/2014)
How can you get to 3NF if you don't go through 1NF and 2NF first?
Very easily, you just need to ensure that the non-trivial determinants of every non-key attribute...
August 6, 2014 at 6:04 am
In a BI solution the role of SSIS is usually to perform data integration functions, e.g. "ETL" - Extracting, Transforming and Loading data into a target database.
Real Time BI just...
July 29, 2014 at 5:29 am
Dalkeith (7/18/2014)
I also believe it [Access] is an excellent tool for teaching database design principles and UI design principles.
patriciahartman (7/21/2014)
July 25, 2014 at 6:37 am
Grant Fritchey (7/23/2014)
July 23, 2014 at 9:30 am
Brandie Tarvin (7/23/2014)I mean add a new column called MyTableID (alter the "MyTable" part to the table name or a user-friendly description that tells everyone what it is). Then cluster...
July 23, 2014 at 6:41 am
Brandie Tarvin (7/23/2014)
July 23, 2014 at 6:01 am
Here's a small example:
CREATE TABLE t
(x INT NOT NULL UNIQUE,
y INT NOT NULL,
z INT NOT NULL UNIQUE,
CONSTRAINT pkc PRIMARY KEY (x,y));
"pkc" is not the primary key of this...
July 19, 2014 at 4:30 am
winston Smith (7/3/2014)
We are beginning exploration of all our systems and data, with the aim of eventually building a Data Warehouse.
I would suggest that may be the wrong way to...
July 7, 2014 at 1:51 pm
SQLTougherGuy (7/7/2014)
Quick question... I need to learn a new data model. What is the fastest most efficient way to achieve this? I do not have a lot of options in...
July 7, 2014 at 1:31 pm
bkubicek (6/29/2014)
Comments posted to this topic are about the item <A HREF="/articles/Primary+key/110374/">Why Primary Keys can be important on large tables</A>
In a nutshell: wrong title and wrong content. How did this...
July 1, 2014 at 12:29 pm
Bill Talada (5/2/2014)
May 2, 2014 at 7:38 am
Bill Talada (4/30/2014)
The number one rule of a primary key is that it must be "meaningless" yet unique.
That's your number one rule but definitely not the number one rule. In...
May 2, 2014 at 4:47 am
mishka-723908 (4/3/2014)
April 4, 2014 at 10:16 am
Viewing 15 posts - 16 through 30 (of 431 total)