|
well remember databases consists of relations also called tables
relations consist of tuples also called records
tuples consist of attributes also called fields
databases cant have duplicates and tables are even unlikely to have duplicates, matter of fact duplicates generally refer to the attribute(s) that make up the primary key.
remember normal forms...in short a tuple must be indentifiable by the key, the whole key, and nothing but the key, so help me Codd
I worked for Informix for 5 years as a Sr Consultant and a Sr Instructor.
Theres a dozen ways to do what you want to do but if you dont know why ie your database design then yer just spinning your wheels.
__________________
Mike South
It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.
|