Recent questions tagged database-normalization

0 votes

1 answer

1

Normalization-(prime attribute -> prime attribute dependency is there in BCNF)

asked Apr 11 in Databases by srestha Veteran (81.7k points) | 54 views

+1 vote

4 answers

2

Lossy or Lossless
Consider the relation $R(ABCDEG)$ and $FD's$ are $\{AB \rightarrow C,AC \rightarrow B,AD \rightarrow E,B \rightarrow D,BC \rightarrow A,E \rightarrow G\}$ then the decomposition$\{ABC,ACDE,ADG\}$ is lossless and not dependency preserving is not lossless and dependency preserving is lossless and dependency preserving is not lossless and not dependency preserving

asked Mar 19 in Databases by shivanisrivarshini Boss (14k points) | 85 views

+6 votes

3 answers

3

GATE2018-42
Consider the following four relational schemas. For each schema , all non-trivial functional dependencies alre listed, The bolded attributes are the respective primary keys. Schema I: Registration(rollno, courses) Field courses' is a set-valued attribute containing the set ... Which one of the relational schemas above is in 3NF but not in BCNF? Schema I Schema II Schema III Schema IV

asked Feb 14 in Databases by gatecse Boss (17.8k points) | 1.2k views

+1 vote

0 answers

4

normalization
what is procedure to convert one normal form to another normal form ??? i.e. how to convert 1NF to 2NF ? please explain with example

asked Jan 30 in Databases by Rahul_Rathod_ (297 points) | 26 views

+2 votes

1 answer

5

MADE EASY test series - Minimum relations required in 2NF form?

asked Jan 28 in Databases by tarunmaganti (265 points) | 91 views

+1 vote

0 answers

6

3NF Normalization Doubt
Is a relation with multiple candidate keys in 3NF? According to this, As per the first definition any relation having multiple candidate keys will have transitive dependency to a non key attribute. My Inference : Since it has a Transitive dependency ... given is correct or not.And if it is correct can you please provide some other reference illustrating the same concept.

asked Jan 25 in Databases by Sourajit25 Junior (587 points) | 38 views

+1 vote

1 answer

7

Normal Form
Given a relation with five attributes and the following FDs: A -> D A -> E DE -> BC B -> A D -> C What is the highest normal form satisfied by the relation?

asked Jan 13 in Databases by Tuhin Dutta Loyal (7.6k points) | 121 views

0 votes

2 answers

8

Ace Test - Database

asked Jan 12 in Databases by hacker16 Active (2.6k points) | 64 views

+2 votes

1 answer

9

Test Series

asked Jan 10 in Databases by vishal chugh Active (1.6k points) | 115 views

+3 votes

2 answers

10

BCNF, lossless, functional dependency preserving.

asked Jan 7 in Databases by Hemant Parihar Boss (14.6k points) | 167 views

+1 vote

2 answers

11

Highest normal form achieved by given $FDs$ is?

asked Dec 31, 2017 in Databases by Aghori Loyal (5.9k points) | 75 views

0 votes

1 answer

12

normalization

asked Dec 21, 2017 in Databases by Meenakshi Sharma Active (2.9k points) | 51 views

+1 vote

1 answer

13

Normal Forms

asked Dec 17, 2017 in Databases by ankitgupta.1729 Active (4.2k points) | 88 views

0 votes

0 answers

14

[DBMS] Decompose into BCNF and 4NF
Minimum relations to decompose into BCNF and 4NF.List only relation names with attributes and total number of relations

asked Dec 15, 2017 in Databases by rahul sharma 5 Boss (22.7k points) | 94 views

0 votes

0 answers

15

NORMALIZATION
WHICH OF THE FOLLOWING IS CORRECT IF RELATION R IS IN 3NF 1. NO NON PRIME ATTRIBUTE OF R IS TRANSITIVELY DEPENDENT ON KEY(SUPER KEY,PRIMARY KEY,CANDIDATE KEY). 2.PRIME ATTRIBUTE OF R CAN BE TRANSITIVELY DEPENDENT ON KEY(SUPER KEY,PRIMARY KEY,CANDIDATE KEY). 3. A ... R. 4.A relation R is in 3NF, if every non-prime attribute of R, is fully functionally dependent on every key of R.

asked Dec 13, 2017 in Databases by Jaspreet Kaur Bains Junior (753 points) | 94 views

0 votes

1 answer

16

Database
Consider the following statements. S1: If relation R is in 3NF and every key is simple, then R is in BCNF S2: If relation R is in 3NF and R has only one key, then R is in BCNF A).Both S1 and S2 are true. B).S1 is true S2 is false. C).S2 is true S1 is false. D).Both S1 and S2 are false.

asked Dec 10, 2017 in Databases by Bad_Doctor Junior (921 points) | 73 views

0 votes

0 answers

17

Normalization
Which of the following statement false is relation R is in 3NF but not BCNF? A) Relation R must consist atleast two over-lapped candidate keys. B) Relation R must consist proper subset of candidate key determines proper subset of some other candidate key ... atleast two compound candidate keys. Someone please explain what does Option A refers here.......i.e overlapped candidate keys

asked Dec 6, 2017 in Databases by shivangi5 Active (1.4k points) | 67 views

0 votes

1 answer

18

BCNF DECOMPOSTION
Can the given relation can be decomposed into BCNF with dependency preserving and lossless join decomposition R(ABCDEFG) : {AB → C, BC → A, AC → B, B → D, D → E}.

asked Dec 3, 2017 in Databases by junaid ahmad Loyal (8.8k points) | 88 views

0 votes

1 answer

19

Dbms normalization
https://gateoverflow.in/?qa=blob&qa_blobid=11537552088967137608

asked Dec 1, 2017 in Databases by Harikesh Kumar Active (1.4k points) | 51 views

0 votes

0 answers

20

Multivalued Dependency
Can anyone please explain it ?

asked Nov 30, 2017 in Databases by ankitgupta.1729 Active (4.2k points) | 45 views

0 votes

0 answers

21

database normalisation
consider: T1: {A11, A12, A13} - key is A11 T2: {A21, A22, A11} - key is A21 T3: {A21, A23} - key is {A21 A23} T1, T2, T3 all are in which normal form? a) 2nf b) 3nf c) BCNF FUNCTIONAL DEPENDENCIES ARE NOT MENTIONED. SO, PLEASE EXPLAIN HOW TO CHECK NORMAL FORM FOR THE RELATION?

asked Nov 24, 2017 in Databases by iarnav Loyal (6.5k points) | 102 views

0 votes

1 answer

22

Normalization
Please explain with example how lossless decomposition into BCNF is possible but dependency preservating BCNF decomposition may not be possible for all relations?

asked Nov 24, 2017 in Databases by Mk Utkarsh Boss (11.7k points) | 53 views

0 votes

1 answer

23

self doubt
4th and 5th normal form are in gate syllabus?

asked Nov 23, 2017 in Databases by arch Active (3.2k points) | 60 views

+3 votes

1 answer

24

Database Normal Form

asked Nov 22, 2017 in Databases by Lakshman Patel RJIT Loyal (7.5k points) | 48 views

0 votes

2 answers

25

#normalization

asked Nov 21, 2017 in Databases by garam_masala_ (73 points) | 46 views

0 votes

2 answers

26

2NF decomposition
How is it option D??

asked Nov 20, 2017 in Databases by Parshu gate Active (4.8k points) | 193 views

+3 votes

2 answers

27

Normalisation
A prime attribute can be intransitively dependent on a key in a 3NF relation. True / False Pls. Do Explain what does intransitivity actually mean here.

asked Nov 19, 2017 in Databases by yogi_p Active (1.7k points) | 97 views

+5 votes

2 answers

28

#testseries
Consider the following E-R diagram: What is the minimum relations required which satisfied the 2nd normal form? A) 1 B) 2 C) 3 D) 4

asked Nov 18, 2017 in Databases by Rohit Gupta 8 Active (2.1k points) | 165 views

+3 votes

4 answers

29

Made Easy Test series, GATE2018

asked Nov 18, 2017 in Databases by ashish pal Active (1.1k points) | 267 views

0 votes

2 answers

30

Normalization
ABC is key of R(ABCDE). Is A -- DBC is Partial dependncy .

asked Nov 17, 2017 in Databases by garam_masala_ (73 points) | 42 views

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 questions tagged database-normalization

Recent Posts

Recent Blog Comments