Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Slides
Recent questions tagged database-normalization
5
votes
1
answer
391
UGC NET CSE | Junet 2015 | Part 3 | Question: 11
The relation schemas $R_1$ and $R_2$ form a Lossless join decomposition of $R$ if and only if $R_1 \cap R_2 \twoheadrightarrow (R_1-R_2)$ $R_1 \rightarrow R_2$ $R_1 \cap R_2 \twoheadrightarrow (R_2-R_1)$ $R_2 \rightarrow R_1 \cap R_2$ $\text{i and ii}$ happen $\text{i and iv}$ happen $\text{i and iii}$ happen $\text{ii and iii}$ happen
The relation schemas $R_1$ and $R_2$ form a Lossless join decomposition of $R$ if and only if$R_1 \cap R_2 \twoheadrightarrow (R_1-R_2)$$R_1 \rightarrow R_2$$R_1 \cap R_2...
go_editor
4.1k
views
go_editor
asked
Jul 31, 2016
Databases
ugcnetcse-june2015-paper3
databases
decomposition
database-normalization
+
–
4
votes
2
answers
392
UGC NET CSE | Junet 2015 | Part 3 | Question: 10
The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because Non_key attribute V_name is dependent on V_no which is part of composite key Non_key attribute V_name is dependent on Qty_sup Key attribute Qty_sup is dependent on primary key unit_price Key attribute V_ord_no is dependent on primary key unit_price
The RelationVendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF becauseNon_key attribute V_name is dependent on V_no which is part of composite keyNon_ke...
go_editor
3.3k
views
go_editor
asked
Jul 31, 2016
Databases
ugcnetcse-june2015-paper3
databases
database-normalization
+
–
3
votes
1
answer
393
UGC NET CSE | December 2013 | Part 3 | Question: 59
Armstrong $(1974)$ ... $\text{a-ii, b-i, c-iii, d-iv}$ $\text{a-iv, b-iii, c-i, d-ii}$
Armstrong $(1974)$ proposed systematic approach to derive functional dependencies. Match the following w.r.t functional dependencies:$\begin{array}{} & \textbf{List-I} ...
go_editor
1.7k
views
go_editor
asked
Jul 29, 2016
Databases
ugcnetcse-dec2013-paper3
databases
database-normalization
+
–
6
votes
2
answers
394
UGC NET CSE | December 2014 | Part 3 | Question: 12
Which of the following is false ? Every binary relation is never be in $BCNF$. Every $BCNF$ relation is in $3NF$. $1 NF, 2 NF, 3 NF$ and $BCNF$ are based on functional dependencies. Multivalued Dependency $(MVD)$ is a special case of Join Dependency $(JD)$
Which of the following is false ? Every binary relation is never be in $BCNF$. Every $BCNF$ relation is in $3NF$. $1 NF, 2 NF, 3 NF$ and $BCNF$ are based on functional de...
makhdoom ghaya
5.2k
views
makhdoom ghaya
asked
Jul 25, 2016
Databases
ugcnetcse-dec2014-paper3
databases
database-normalization
+
–
4
votes
2
answers
395
UGC NET CSE | December 2014 | Part 3 | Question: 10
Let $R = ABCDE$ is a relational scheme with functional dependency set $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$. The attribute closures of $A$ and $E$ are $ABCD, \phi$ $ABCD, E$ $\Phi, \phi$ $ABC, E$
Let $R = ABCDE$ is a relational scheme with functional dependency set $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$. The attribute closures of $...
makhdoom ghaya
2.7k
views
makhdoom ghaya
asked
Jul 25, 2016
Databases
ugcnetcse-dec2014-paper3
databases
database-normalization
+
–
4
votes
1
answer
396
UGC NET CSE | December 2014 | Part 2 | Question: 20
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$ $AE$ $BE$ $CE$
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$...
makhdoom ghaya
4.4k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
database-normalization
+
–
5
votes
1
answer
397
UGC NET CSE | December 2014 | Part 2 | Question: 19
The best normal form of relation scheme $R(A, B, C, D)$ along with the set of functional dependencies $F = \left\{AB \rightarrow C, AB \rightarrow D, C \rightarrow A, D \rightarrow B\right\}$ is Boyce-Codd Normal form Third Normal form Second Normal form First Normal form
The best normal form of relation scheme $R(A, B, C, D)$ along with the set of functional dependencies $F = \left\{AB \rightarrow C, AB \rightarrow D, C \rightarrow A, D \...
makhdoom ghaya
5.8k
views
makhdoom ghaya
asked
Jul 20, 2016
Databases
ugcnetcse-dec2014-paper2
databases
database-normalization
+
–
5
votes
3
answers
398
UGC NET CSE | June 2013 | Part 3 | Question: 9
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a $\rightarrow$ c, b $\rightarrow$ d holds in the following relation. In 1NF not in 2NF In 2NF not in 3NF In 3NF in 1 NF
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a $\rightarrow$ c, b $\rightarrow$ d holds...
go_editor
1.5k
views
go_editor
asked
Jul 16, 2016
Databases
ugcnetcse-june2013-paper3
databases
database-normalization
+
–
3
votes
2
answers
399
UGC NET CSE | December 2012 | Part 3 | Question: 63
The third normal form is based on the concept of_____ Closure Dependency Transitive Dependency Normal Dependency Functional Dependency
The third normal form is based on the concept of_____Closure DependencyTransitive DependencyNormal DependencyFunctional Dependency
go_editor
3.6k
views
go_editor
asked
Jul 13, 2016
Databases
ugcnetcse-dec2012-paper3
databases
database-normalization
+
–
1
votes
2
answers
400
UGC NET CSE | June 2014 | Part 3 | Question: 22
Consider the following relational schemas for a library database : Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection(Title, Author, Catalog_no) with the following functional dependencies : I. Title, Author $\rightarrow$ ... . Book is in $2$NF and Collection in $3$NF. Both Book and Collection are in $2$NF.
Consider the following relational schemas for a library database :Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection(Title, Author, Catalog_no) with the ...
makhdoom ghaya
2.0k
views
makhdoom ghaya
asked
Jul 9, 2016
Databases
ugcnetjune2014iii
databases
database-normalization
+
–
0
votes
0
answers
401
navathe,FD #inference rules for functional dependency
anonymous
504
views
anonymous
asked
Jul 4, 2016
Databases
database-normalization
+
–
2
votes
3
answers
402
UGC NET CSE | June 2014 | Part 2 | Question: 49
Let $R =\{A, B, C, D, E, F\}$ be a relation schema with the following dependencies $C \rightarrow F$, $E \rightarrow A$, $EC \rightarrow D$, $A \rightarrow B$. Which of the following is a key for $R$ ? CD EC AE AC
Let $R =\{A, B, C, D, E, F\}$ be a relation schema with the following dependencies $C \rightarrow F$, $E \rightarrow A$, $EC \rightarrow D$, $A \rightarrow B$. Which of t...
makhdoom ghaya
20.0k
views
makhdoom ghaya
asked
Jul 1, 2016
Databases
ugcnetcse-june2014-paper2
databases
database-normalization
+
–
10
votes
4
answers
403
ISRO2014-63
Consider the following table The table is in which normal form? First Normal Form Second Normal Form Third Normal Form but not BCNF Third Normal Form and BCNF
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
go_editor
8.3k
views
go_editor
asked
Jul 1, 2016
Databases
isro2014
databases
database-normalization
+
–
4
votes
2
answers
404
Dbms Normalization
Second Normal form is designed to A. Ensure that a table is in first normal form is decomposed into two fields B. Ensure that every non key field in a record has a corresponding foreign key in at-least one other table C. Ensure that a table ... decomposed into two or more tables D. Ensure that every non key field in a record is fully functionally dependent upon the key field
Second Normal form is designed toA. Ensure that a table is in first normal form is decomposed into two fieldsB. Ensure that every non key field in a record has a correspo...
geet.m
916
views
geet.m
asked
Jun 25, 2016
Databases
databases
database-normalization
+
–
4
votes
2
answers
405
Dbms Normalization
Normalization is A. The process of ensuring that each table has a key B. A process whereby a limit is put on the number of fields a record can contain C. A process whereby the design of a table(relation) is decomposed into more tables that more precisely fit the relational model D. The process of ensuring that a relational database has at least two tables in it
Normalization isA. The process of ensuring that each table has a keyB. A process whereby a limit is put on the number of fields a record can containC. A process whereby t...
geet.m
923
views
geet.m
asked
Jun 25, 2016
Databases
databases
database-normalization
+
–
2
votes
2
answers
406
Dbms Normalization
geet.m
816
views
geet.m
asked
Jun 25, 2016
Databases
databases
database-normalization
+
–
–1
votes
7
answers
407
BCNF
Every BCNF decomposition is A)Dependency preserving B)not a dependency preserving C)Need not be dependency preserving D)None of the above
Every BCNF decomposition is A)Dependency preservingB)not a dependency preservingC)Need not be dependency preservingD)None of the above
vivekpinto07
2.5k
views
vivekpinto07
asked
Jun 19, 2016
Databases
bcnf
docm
bcnf-decomposition
database-normalization
+
–
8
votes
2
answers
408
ISRO2015-20
Let $\text{R = (A, B, C, D, E, F)}$ be a relation scheme with the following dependencies $\text{C} \rightarrow \text{F, E} \rightarrow \text{A}, \text{EC} \rightarrow \text{D, A} \rightarrow \text{B}$. Which of the following is a key of $\text{R}?$ $\text{CD}$ $\text{EC}$ $\text{AE}$ $\text{AC}$
Let $\text{R = (A, B, C, D, E, F)}$ be a relation scheme with the following dependencies $\text{C} \rightarrow \text{F, E} \rightarrow \text{A}, \text{EC} \rightarrow \te...
go_editor
3.9k
views
go_editor
asked
Jun 17, 2016
Databases
isro2015
databases
database-normalization
functional-dependency
+
–
1
votes
1
answer
409
UGC NET CSE | December 2012 | Part 2 | Question: 13
Which of the following is true? A relation in BCNF is always in 3NF A relation in 3NF is always in BCNF BCNF and 3NF are same A relation in BCNF is not in 3NF
Which of the following is true?A relation in BCNF is always in 3NFA relation in 3NF is always in BCNFBCNF and 3NF are sameA relation in BCNF is not in 3NF
im.raj
5.7k
views
im.raj
asked
Jun 16, 2016
Databases
databases
ugcnetcse-dec2012-paper2
database-normalization
+
–
6
votes
2
answers
410
ISRO2011-53
In functional dependency Armstrong inference rules refers to Reflexive, Augmentation and Decomposition Transitive, Augmentation and Reflexive Augmentation, Transitive, Reflexive and Decomposition Reflexive, Transitive and Decomposition
In functional dependency Armstrong inference rules refers toReflexive, Augmentation and DecompositionTransitive, Augmentation and ReflexiveAugmentation, Transitive, Refle...
Isha Gupta
6.3k
views
Isha Gupta
asked
Jun 15, 2016
Databases
isro2011
databases
database-normalization
+
–
2
votes
2
answers
411
Normal Form
Consider the following relations R1 and R2 given below R1(ABCD) And functional dependency are {AB→C ,C→A ,AC→D} and R2(ABCD) functional dependency are {AB→C ,BC→D}. (a)Both R1 and R2 in 3NF (b)R1 is not in 2NF and R2 in 2NF (c)R1 in 2NF and R2 in 3NF (d)None of the above
Consider the following relations R1 and R2 given belowR1(ABCD) And functional dependency are {AB→C ,C→A ,AC→D} andR2(ABCD) functional dependency are {AB→C ,BC→...
ManojK
1.8k
views
ManojK
asked
Jun 14, 2016
Databases
database-normalization
+
–
4
votes
2
answers
412
ISRO2007-54
BCNF is not used for cases where a relation has Two (or more) candidate keys Two candidate keys and composite The candidate key overlap Two mutually exclusive foreign keys
BCNF is not used for cases where a relation hasTwo (or more) candidate keysTwo candidate keys and compositeThe candidate key overlapTwo mutually exclusive foreign keys
go_editor
7.8k
views
go_editor
asked
Jun 10, 2016
Databases
isro2007
databases
database-normalization
+
–
5
votes
2
answers
413
ISRO2007-51
Armstrong’s inference rule doesnot determine Reflexivity Augmentation Transitivity Mutual dependency
Armstrong’s inference rule doesnot determineReflexivityAugmentationTransitivityMutual dependency
go_editor
2.1k
views
go_editor
asked
Jun 10, 2016
Databases
isro2007
databases
database-normalization
+
–
0
votes
2
answers
414
bcnf
Sourabh Kumar
491
views
Sourabh Kumar
asked
Jun 8, 2016
Databases
database-normalization
+
–
17
votes
4
answers
415
ISI2011-PCB-CS-5b
Suppose we have a relation $R(A, B, C, D, E)$ with the functional dependencies: $A \rightarrow D, B \rightarrow C, D \rightarrow E, CE \rightarrow B$. If we project $R$ and therefore its functional dependencies onto the schema $ABC$, what will the key(s) for $ABC$ be?
Suppose we have a relation $R(A, B, C, D, E)$ with the functional dependencies:$A \rightarrow D, B \rightarrow C, D \rightarrow E, CE \rightarrow B$.If we project $R$ and...
go_editor
2.0k
views
go_editor
asked
Jun 3, 2016
Databases
descriptive
isi2011-pcb-cs
databases
database-normalization
+
–
1
votes
0
answers
416
ISI2013-PCB-CS-6b
A school database maintains the following relations for its students, teachers and subjects: Student(st_name, st_address, class, section, roll_no, regn_no) Teacher(t_name, t_address, tel_no) Subject(s_name, t_name, text_book, class) Consider the following constraints on ... Class V and reside in Baranagar (name of a locality). Consider that any address offers a locality name.
A school database maintains the following relations for its students, teachers and subjects:Student(st_name, st_address, class, section, roll_no, regn_no)Teacher(t_name, ...
go_editor
545
views
go_editor
asked
Jun 1, 2016
Databases
descriptive
isi2013-pcb-cs
databases
database-normalization
sql
+
–
1
votes
3
answers
417
UGC NET CSE | December 2015 | Part 2 | Question: 20
A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G}. Which of the following is a candidate key? A AB ABC ABD
A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G}. Which of the following is a candidate key?AABABCAB...
im.raj
5.3k
views
im.raj
asked
May 26, 2016
Databases
ugcnetcse-dec2015-paper2
databases
database-normalization
+
–
2
votes
1
answer
418
Data base Normalisation
A locked DB file can be a)accessed by only 1 user b)modified by user with correct passwords c)used to hide sensitive information d)Update by more than 1 user
A locked DB file can bea)accessed by only 1 userb)modified by user with correct passwordsc)used to hide sensitive informationd)Update by more than 1 user
Dexter
385
views
Dexter
asked
May 6, 2016
Databases
database-normalization
+
–
8
votes
1
answer
419
ISRO-2013-25
Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation. ISBN $\rightarrow$ Title ISBN $\rightarrow$ Publisher Publisher $\rightarrow$ Address First Normal Form Second Normal Form Third Normal Form BCNF
Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation.ISBN $\rightarrow$ TitleISBN $\rig...
makhdoom ghaya
6.5k
views
makhdoom ghaya
asked
Apr 26, 2016
Databases
isro2013
databases
database-normalization
+
–
1
votes
0
answers
420
Normalisation
Hi I am currently refering To IIT KGP lectures for DBMS . ( Normalisation to be specific ) . here the sir has tried to give an alternative definition of 3NF . We know that a 3NF is one in which non key attribute of a relation must not be fully ... apart from this definition he said an alternative definition ( all the 3 bullets ) . Can anyone just verify my given below explanation ?
Hi I am currently refering To IIT KGP lectures for DBMS . ( Normalisation to be specific ) . here the sir has tried to give an alternative definition of 3NF .We know th...
Dexter
606
views
Dexter
asked
Apr 24, 2016
Databases
database-normalization
+
–
Page:
« prev
1
...
9
10
11
12
13
14
15
16
17
18
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register