Dark Mode

Recent questions tagged normal-forms

0 votes

1 answer

1

ISRO 2024
Fifth Normal form is concerned with Join Dependency Domain-key Multivalued dependency Functional dependency

Ramayya asked in Databases Jan 7

163 views

0 votes

0 answers

2

Finding minimum number of tables needed to represent ER diagram
Find minimum number of tables needed to represent following ER diagram? This question would have been relatively simple as we would implicitly convert the ERD to 3NF (asked in GATE 2008). But what if the questions asks us to find minimum tables needed to represent above ERD in 1NF or 2NF?. What would our approach will be in that case?

rexritz asked in Databases Aug 29, 2023

470 views

0 votes

1 answer

3

2NF DECOMPOSITION

ROMITDUTTA asked in Databases Jul 5, 2023

224 views

0 votes

2 answers

4

Database Relations | Heighest normal form
MSQ A relation R(A,B,C,D) has only trivial functional dependencies of the form ( A→A, AB→AB,ABC→A, etc) Then consider the following options: The relation is surely in BCNF The relation is surely in 3NF The relation is surely in 2NF None of the above

Souvik33 asked in Databases Dec 17, 2022

752 views

0 votes

0 answers

5

Best Open Video Playlist for Normal Forms Topic | Databases
Please list out the best free available video playlist for Normal Forms from Databases as an answer here (only one playlist per answer). We'll then select the best playlist and add to GO classroom video lists. You can add ... but standard ones are more likely to be selected as best. For the full list of selected videos please see here

makhdoom ghaya asked in Study Resources Aug 20, 2022

by makhdoom ghaya

270 views

1 vote

1 answer

6

DBMS, 2NF
Given a relation R( P, Q, R, S, T) and Functional Dependency set FD = { PQ → R, S → T }, determine whether the given R is in 2NF? If not convert it into 2 NF.

Toxic_2432 asked in Databases Apr 28, 2022

5.0k views

0 votes

0 answers

7

Doubt - Database
Relation R has at least one simple candidate key and is in BCNF. Which of the following statement true? a) R may not be in 4NF b) R in 4NF also c) R in BCNF but not 4NF d) Can not conclude from given information.

Sumit Singh Chauhan asked in Databases Sep 12, 2018

by Sumit Singh Chauhan

236 views

To see more, click for the full list of questions or popular tags.

Recent questions tagged normal-forms