@

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

Self-doubt | DBMS | Functional Dependency

zeeshanmohnavi asked in Databases Jan 5, 2019

429 views

1 vote

1 vote

Can someone explain the paragraph marked based on relation $r$ given in Figure 7.2?

Reference: Database System Concepts by Silberschatz, Korth, Sudarshan 4^th Edition.

database-normalization
databases

zeeshanmohnavi asked in Databases Jan 5, 2019

by zeeshanmohnavi

429 views

0 Comments

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

← Previous Next →

← Previous in category Next in category →

Related questions

6 votes

6 votes

5 answers

1

srestha asked in Databases Apr 28, 2019

1,500 views

Made Easy Test Series:DBMS-Functional Dependency
Consider a relation $R\left ( A,B,C,D,E \right )$ and functional dependencies are $F=\left \{ AC\rightarrow B,C\rightarrow D,A\rightarrow E,C\rightarrow B \right \}$ Relation $R$ ... Then Is it a lossless decomposition? I am getting doubt, how it can be not lossless decomposition?

srestha asked in Databases Apr 28, 2019

1.5k views

database-normalization
databases
lossless-decomposition

2 votes

2 votes

0 answers

2

Na462 asked in Databases Jan 21, 2019

920 views

Ace Test Series: DBMS - Functional Dependency

Na462 asked in Databases Jan 21, 2019

by Na462

920 views

database-normalization
databases
ace-test-series

1 vote

1 vote

0 answers

3

Harsh Kumar asked in Databases Jun 22, 2018

768 views

Closure of a set of functional dependency
I am little bit confused about the CLOSURE OF A SET-OF-FUNCTIONAL-DEPENDENCIES . If I am given a set of Functional dependencies F, then how the F+ is defined ? Is it defined as the union of the closures of LHS of each of FD within F Or is ... a set of FD's, however, I did not find any procedure to find out the closure of the set of FDs. Thank You

Harsh Kumar asked in Databases Jun 22, 2018

768 views

database-normalization
databases
function-closure

1 vote

1 vote

2 answers

4

Durgesh Singh asked in Databases Oct 2, 2017

7,594 views

When does BCNF not able to preserve functional dependency?
I am trying to understand when does BCNF not able to preserve functional dependency What is the proof that 3NF always preserve functional dependency Suppose I have a relation R(A,B,C,D) and functional dependencies F ... an example. I referred this question but could not get answer- Decomposition that does not preserve functional dependency

Durgesh Singh asked in Databases Oct 2, 2017

by Durgesh Singh

7.6k views

database-normalization
databases

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:...

Send feedback
Rank Predictor
College Prediction
Useful Links
FAQ
Corrections
Discuss
Copyright
Request
Testimonials
Chat Logs
Chat
Badges
Search tips
Exam Category
Blog Category
Blog Tags
Privacy
Test Series
GATER
Refund Policy
Terms and Conditions
Contact Us

Developed by Chun

Twitter WhatsApp Facebook Reddit LinkedIn Email

Link Copied!