Hi Everyone,
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Thanks a lot! 8 2044 sq*************@yahoo.com wrote:
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Using your definitions, it'd probably be "the cardinality of the
domain."
Larry Coon
University of California
On Apr 12, 11:47 am, sqlservernew...@yahoo.com wrote:
Hi Everyone,
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Thanks a lot!
distinct values
For a column or set of columns which together an index is created from
you can think of it as distinct keys sq*************@yahoo.com wrote:
Hi Everyone,
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Thanks a lot!
(Column) Cardinality = number of distinct column/attribute values.
Table Cardinality = number of rows in a table.
--
Jeroen
In article <46*********************@news.xs4all.nl>, us****@No.Spam.Please.invalid says...
sq*************@yahoo.com wrote:
Hi Everyone,
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Thanks a lot!
(Column) Cardinality = number of distinct column/attribute values.
Table Cardinality = number of rows in a table.
Shouldn't that be *distinct* (non-duplicate) rows in the table?
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
On Apr 12, 4:14 pm, David Kerber
<ns_dkerber@ns_WarrenRogersAssociates.comwrote:
In article <461e877b$0$328$e4fe5...@news.xs4all.nl>,
use...@No.Spam.Please.invalid says...
sqlservernew...@yahoo.com wrote:
Hi Everyone,
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Thanks a lot!
(Column) Cardinality = number of distinct column/attribute values.
Table Cardinality = number of rows in a table.
Shouldn't that be *distinct* (non-duplicate) rows in the table?
I believe that one of the cardinal rules (pun intended) of RDBMS
theory is that a table can never have duplicate rows.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
Attribute
a named column/field of a relation
Domain
a set of allowable values for one or more attributes
Tuple
a row of a relation
Degree
the number of attributes a relation contains
Number of fields in a table
Cardinality
the number of tuples/rows a relation contains
But!
What is the definition for the number of unique values in a field?
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
What do we call this concept?
"the number of unique values in a column?"
Is there one?
Thanks a lot!
(Column) Cardinality = number of distinct column/attribute values.
Table Cardinality = number of rows in a table.
Shouldn't that be *distinct* (non-duplicate) rows in the table?
I believe that one of the cardinal rules (pun intended) of RDBMS
theory is that a table can never have duplicate rows.
True. There's no point in having duplicate rows, cause you can't tell
which one you're handling :-)
--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions http://www.upscene.com
My thoughts: http://blog.upscene.com/martijn/
Database development questions? Check the forum! http://www.databasedevelopmentforum.com
In article <46***********************@dreader14.news.xs4all.n l>, m.******@upscene.removethis.com says...
>
Here is a theoretical, and definition question for you.
>
In databases, we have:
>
Relation
a table with columns and rows
>
Attribute
a named column/field of a relation
>
Domain
a set of allowable values for one or more attributes
>
Tuple
a row of a relation
>
Degree
the number of attributes a relation contains
Number of fields in a table
>
Cardinality
the number of tuples/rows a relation contains
>
But!
>
What is the definition for the number of unique values in a field?
>
So, if you have 100 rows in a table, and the field is
the gender field, with only values of: M, F.
The result is 2 unique values.
>
What do we call this concept?
"the number of unique values in a column?"
>
Is there one?
>
Thanks a lot!
>
(Column) Cardinality = number of distinct column/attribute values.
Table Cardinality = number of rows in a table.
>
Shouldn't that be *distinct* (non-duplicate) rows in the table?
I believe that one of the cardinal rules (pun intended) of RDBMS
theory is that a table can never have duplicate rows.
True. There's no point in having duplicate rows, cause you can't tell
which one you're handling :-)
True, but are you telling me you've never had it happen accidentally??
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
David Kerber wrote:
>True. There's no point in having duplicate rows, cause you can't tell which one you're handling :-)
True, but are you telling me you've never had it happen accidentally??
Assuming the database is being used as more than an electronic form
of Excel or 3x5 cards ... no. Primary key constraints were invented
for a reason. Like seat belts they are most useful when used.
--
Daniel A. Morgan
University of Washington da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group www.psoug.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: sqlservernewbie |
last post by:
Hi Everyone,
Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |