Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged rdbms
2
votes
0
answers
31
database
what is the concept of nested loop join in database????????? link plz or give any example.
what is the concept of nested loop join in database?????????link plz or give any example.
akankshadewangan24
177
views
akankshadewangan24
asked
Jan 12, 2018
Databases
rdbms
+
–
0
votes
1
answer
32
ER Diagram
ankitgupta.1729
373
views
ankitgupta.1729
asked
Dec 16, 2017
Databases
databases
er-diagram
er-to-relational
rdbms
+
–
0
votes
1
answer
33
Number of tables
Number of tables required and also the attribute set of the tables
Number of tables required and also the attribute set of the tables
Mk Utkarsh
376
views
Mk Utkarsh
asked
Dec 11, 2017
Databases
databases
rdbms
+
–
3
votes
1
answer
34
MadeEasy Test Series: Databases - Er Diagram
In the solution they have merged E1 R4 E4 , E2 R3 E3 R5 , R6 E5. MY DOUBT IS , why cant we only merge R4 E4 instead of E1 R4 E4. since there is total participation on the E4 side of the relation and it would also decrease the number of attributes .
In the solution they have merged E1 R4 E4 , E2 R3 E3 R5 , R6 E5.MY DOUBT IS , why cant we only merge R4 E4 instead of E1 R4 E4. since there is total participation on the ...
shaurya vardhan
1.1k
views
shaurya vardhan
asked
Dec 4, 2017
Databases
databases
er-diagram
er-to-relational
rdbms
made-easy-test-series
+
–
0
votes
1
answer
35
database self doubt
what does this line means - Let r and s be two relations over the relation schemes R and S respectively and R has attribute A.
what does this line means - Let r and s be two relations over the relation schemes R and S respectively and R has attribute A.
iarnav
414
views
iarnav
asked
Nov 27, 2017
Databases
databases
rdbms
relational-algebra
+
–
6
votes
2
answers
36
One to one relationship with total participation of one entity. Can a single table be formed?
I am confused whether we need to have 2 tables or a single table when 2 strong entities are in 1:1 relationship with one having complete participation. Ex: How is it possible that we join Person and ... Bank Account may refer to some of the Person records which may go away on joining Person and License.
I am confused whether we need to have 2 tables or a single table when 2 strong entities are in 1:1 relationship with one having complete participation.Ex: How is it possi...
Ashish Sharma 3
12.8k
views
Ashish Sharma 3
asked
Nov 24, 2017
Databases
databases
er-diagram
relations
rdbms
+
–
5
votes
1
answer
37
Minimum relations required for ER diagram
How many minimum relations required for the above ER diagram? According to me it should be 7. Please let me know the answer according to you.
How many minimum relations required for the above ER diagram?According to me it should be 7. Please let me know the answer according to you.
Ashish Sharma 3
2.6k
views
Ashish Sharma 3
asked
Nov 24, 2017
Databases
databases
er-diagram
er-to-relational
relational
rdbms
+
–
1
votes
5
answers
38
UGC NET CSE | November 2017 | Part 3 | Question: 12
Consider a schema $R(A, B, C, D)$ and following functional dependencies. $A \rightarrow B$ $B \rightarrow C$ $C \rightarrow D$ $D \rightarrow B$ Then decomposition of $R$ ... preserving and lossless join Lossless join but dependency preserving Dependency preserving but not lossless join Not dependency preserving and not lossless join
Consider a schema $R(A, B, C, D)$ and following functional dependencies.$A \rightarrow B$$B \rightarrow C$$C \rightarrow D$$D \rightarrow B$Then decomposition of $R$ into...
Arjun
3.4k
views
Arjun
asked
Nov 5, 2017
Databases
ugcnetcse-nov2017-paper3
databases
relational-schema
rdbms
+
–
2
votes
1
answer
39
UGC NET CSE | November 2017 | Part 3 | Question: 10
Consider a relation $R (A, B, C, D, E, F, G, H)$ where each attribute is atomic, and following functional dependencies exist. $ CH \rightarrow G$ $A \rightarrow BC$ $B \rightarrow CFH$ $E \rightarrow A$ $F \rightarrow EG$ The relation $R$ is ________ In $1NF$ but not in $2NF$ In $2NF$ but not in $3NF$ In $3NF$ but not in $BCNF$ In $BCNF$
Consider a relation $R (A, B, C, D, E, F, G, H)$ where each attribute is atomic, and following functional dependencies exist.$ CH \rightarrow G$$A \rightarrow BC$$B \righ...
Arjun
4.6k
views
Arjun
asked
Nov 5, 2017
Databases
ugcnetcse-nov2017-paper3
databases
rdbms
database-normalization
+
–
0
votes
1
answer
40
Database doubt
Why B or B+ tree is prefer for database indexing rather than AVL tree ????
Why B or B+ tree is prefer for database indexing rather than AVL tree ????
air1ankit
334
views
air1ankit
asked
Oct 28, 2017
Databases
databases
database-normalization
rdbms
+
–
0
votes
0
answers
41
Database #1NF
R(ABCDE) { A,BC,CD} are candidate key of relation R after 1 NF design which one is possible multi valued attributes before 1 NF design ???
R(ABCDE) { A,BC,CD} are candidate key of relation R after 1 NF design which one is possible multi valued attributes before 1 NF design ???
air1ankit
460
views
air1ankit
asked
Oct 27, 2017
Databases
databases
data-dependency
rdbms
+
–
4
votes
1
answer
42
Doubt Database
What is difference between attributes set of cross product and attributes set of joine ???
What is difference between attributes set of cross product and attributes set of joine ???
air1ankit
566
views
air1ankit
asked
Oct 22, 2017
Databases
databases
database-normalization
rdbms
relational-algebra
+
–
1
votes
1
answer
43
Doubt database
What is basic difference between mandatory attributes and multivalued attributes???
What is basic difference between mandatory attributes and multivalued attributes???
air1ankit
292
views
air1ankit
asked
Oct 19, 2017
Databases
databases
database-normalization
rdbms
+
–
0
votes
0
answers
44
Participation constraints
For what type of relationships we can't have participant constraints? I mean from unary, binary and ternary relationship is there any that we can't specify a participation constraint.
For what type of relationships we can't have participant constraints? I mean from unary, binary and ternary relationship is there any that we can't specify a participatio...
V MIDHUN 2
462
views
V MIDHUN 2
asked
Aug 30, 2017
Databases
rdbms
databases
+
–
0
votes
1
answer
45
ERDiagram conversion to Database
Suppose i have Two strong entity E1 and E2 connected by a 1 to many relationship R. E1 <--------- R ---------- E2 How many table will be created when i will convert the above ER diagram into database ? I know that when E2 ... above. I have seen multiple places and found different answer. I am looking for some solid argument with answer. Answer can be 2 or 3.
Suppose i have Two strong entity E1 and E2 connected by a 1 to many relationship R.E1 < - R E2How many table will be created when i will convert the above ER diagram...
lifeisshubh
441
views
lifeisshubh
asked
Jan 21, 2017
Databases
databases
er-diagram
rdbms
+
–
1
votes
2
answers
46
ER to Table Conversion
Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?
Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?
PEKKA
1.4k
views
PEKKA
asked
Nov 29, 2016
Databases
er-diagram
rdbms
databases
+
–
1
votes
1
answer
47
ER to Relational mapping
How can trainer id be p.key of Parts??
How can trainer id be p.key of Parts??
KISHALAY DAS
1.5k
views
KISHALAY DAS
asked
Oct 19, 2016
Databases
er-diagram
rdbms
+
–
0
votes
2
answers
48
UGC NET CSE | August 2016 | Part 2 | Question: 18
Consider the following statements regarding relational database model : (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. (b) Suppose that table T has only one candidate key. If Q is in $3$NF, then it is also in BCNF. (c) The ... ) are true. (a) and (c) are true. (b) and (c) are true. (a), (b) and (c) are true.
Consider the following statements regarding relational database model :(a) NULL values can be used to opt a tuple out of enforcement of a foreign key.(b) Suppose that tab...
makhdoom ghaya
3.1k
views
makhdoom ghaya
asked
Sep 24, 2016
Others
ugcnetcse-aug2016-paper2
databases
rdbms
+
–
0
votes
1
answer
49
UGC NET CSE | August 2016 | Part 2 | Question: 16
DBMS provides the facility of accessing data from a database through DDL DML DBA Schema
DBMS provides the facility of accessing data from a database throughDDLDMLDBASchema
makhdoom ghaya
1.4k
views
makhdoom ghaya
asked
Sep 24, 2016
Others
ugcnetcse-aug2016-paper2
databases
rdbms
+
–
4
votes
1
answer
50
UGC NET CSE | June 2016 | Part 2 | Question: 18
In a relational database model, NULL values canbe used for all but which one of the following? To allow duplicate tuples in the table by filling the primary key column(s) with NULL To avoid confusion with actual legitimate data ... is unknown To fill a column in a tuple when that column does not really "exist" for that particular tuple
In a relational database model, NULL values canbe used for all but which one of the following?To allow duplicate tuples in the table by filling the primary key column(s) ...
go_editor
4.7k
views
go_editor
asked
Aug 14, 2016
Databases
ugcnetcse-june2016-paper2
rdbms
sql
databases
+
–
4
votes
1
answer
51
UGC NET CSE | June 2016 | Part 2 | Question: 16
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: Referential integrity Multi-valued dependency Entity integrity Functional dependency
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:Referential integrityMulti-valued dependencyEntity integrityFunctional dependency
go_editor
2.5k
views
go_editor
asked
Aug 14, 2016
Databases
ugcnetcse-june2016-paper2
databases
rdbms
sql
+
–
3
votes
2
answers
52
UGC NET CSE | June 2013 | Part 3 | Question: 34
Horn clauses are special kinds of propositions which can be described as Single atomic proposition on left side Single or multiple atomic proposition on left side A single atomic proposition on left side and a single atomic proposition on right side A single atomic proposition on left side or an empty left side
Horn clauses are special kinds of propositions which can be described asSingle atomic proposition on left sideSingle or multiple atomic proposition on left sideA single a...
go_editor
2.4k
views
go_editor
asked
Jul 17, 2016
Databases
ugcnetcse-june2013-paper3
databases
rdbms
+
–
0
votes
1
answer
53
UGC NET CSE | June 2013 | Part 3 | Question: 7
The “PROJECT” operator of a relational algebra creates a new table that has always More columns than columns in original table More rows than original table Same number of rows as the original table Same number of columns as the original table
The “PROJECT” operator of a relational algebra creates a new table that has alwaysMore columns than columns in original tableMore rows than original tableSame...
go_editor
3.2k
views
go_editor
asked
Jul 16, 2016
Databases
ugcnetcse-june2013-paper3
databases
rdbms
+
–
3
votes
2
answers
54
ISRO2011-21
Which type of DBMS provides support for maintaining several versions of the same entity? Relational Database Management System Hierarchical Object Oriented Database Management System Network
Which type of DBMS provides support for maintaining several versions of the same entity?Relational Database Management SystemHierarchicalObject Oriented Database Manageme...
Isha Gupta
3.7k
views
Isha Gupta
asked
Jun 15, 2016
Databases
isro2011
databases
rdbms
+
–
6
votes
4
answers
55
ISRO2007-50
A view of database that appears to an application program is known as Schema Subschema Virtual table None of these
A view of database that appears to an application program is known asSchemaSubschemaVirtual tableNone of these
go_editor
13.1k
views
go_editor
asked
Jun 10, 2016
Databases
isro2007
databases
rdbms
+
–
Page:
« prev
1
2
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register