Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Cardinality of a table
Rahul Jain25
asked
in
Unknown Category
Oct 4, 2016
4,099
views
3
votes
3
votes
sql
databases
Rahul Jain25
asked
in
Unknown Category
Oct 4, 2016
by
Rahul Jain25
4.1k
views
answer
comment
Follow
share this
share
3 Comments
by
Rahul Jain25
commented
Oct 4, 2016
reply
Follow
share this
What if worksfor table had two more rows <7,7>,<7,7> each
0
0
by
Hira Thakur
commented
Nov 4, 2016
reply
Follow
share this
@rahul i'm not getting ur points plz clear what is7,7
0
0
by
Rahul Jain25
commented
Nov 4, 2016
reply
Follow
share this
I am saying that what if the worksfor table has two more rows which contain 7,7 i.e. they are duplicate rows.
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
5
votes
5
votes
Best answer
cardinality=no of tuples or rows
degree= no of attributes or columns
so answer will be 6..if u add two more rows..cardinality will become 8;;
sudsho
answered
Oct 5, 2016
selected
Nov 4, 2016
by
Prashant.
by
sudsho
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
1
answer
1
Isha Gupta
asked
in
Databases
Jun 12, 2016
4,055
views
which operation is used to extract specific columns from a table
which operation is used to extract specific columns from a table?
Isha Gupta
asked
in
Databases
Jun 12, 2016
by
Isha Gupta
4.1k
views
databases
sql
5
votes
5
votes
1
answer
2
Vikrant Singh
asked
in
Databases
Dec 28, 2014
778
views
A relational table employee.
A relational table Employee (ENo, EName, Dept) has $88$ number of tuples. What will be the result of following SQL statement? SELECT COUNT (ENo) FROM Employee WHERE ENo NOT IN (NULL); $88$ $44$ $0$ $87$
Vikrant Singh
asked
in
Databases
Dec 28, 2014
by
Vikrant Singh
778
views
sql
databases
0
votes
0
votes
0
answers
3
mohit chawla
asked
in
Databases
Jan 25, 2017
1,443
views
repeted values in Relation Table
I want to know as we know codd's rule says that no two tuples in a relation should be same. i.e we can not have 2 tuples with same values in clm feilds. now to maintain these constraints, we choose to have some key over the relation ... having mutiset values, (as there are no keys present), how Dbms do indexing to retrive records? someone help me on this pls.
mohit chawla
asked
in
Databases
Jan 25, 2017
by
mohit chawla
1.4k
views
databases
sql
relational-dbms
0
votes
0
votes
2
answers
4
Arjun
asked
in
Unknown Category
Nov 5, 2017
407
views
UGC NET CSE | November 2017 | Part 2 | Question: 17
In SQL, ________ is an Aggregate function. SELECT CREATE AVG MODIFY
Arjun
asked
in
Unknown Category
Nov 5, 2017
by
Arjun
407
views
ugcnetcse-nov2017-paper2
databases
sql
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy