Register

Recent questions tagged goclasses-da-dpp-day-273

2 2 votes
2 2 answers
154
154 views
GO Classes DPP | GATE CS, DA | DBMS | Decomposition
Consider relation $R(A,B,C,D,E,F)$ with$A\to B$$A\to C$$F\to D$$F\to E$Suppose $R$ is decomposed into $R_1(A,B,C)$ and $R_2(D,E,F)$.Which statement best describes this de...
User Avatar
1 1 vote
1 1 answer
118
118 views
GO Classes DPP | GATE CS, DA | DBMS | Decomposition & Redundancy
A redundant relation is decomposed appropriately to improve its logical database design.Which of the following benefits can be relied upon as a purpose of the decompositi...
User Avatar
1 1 vote
1 1 answer
99
99 views
GO Classes DPP | GATE CS, DA | DBMS | Insertion - Deletion Anomaly
Consider the single relation containing $\text{Course, Teacher, Room, Hour, StudentID, Grade}$.\[\begin{array}{|c|c|c|c|c|c|}\hline\text{Course} & \text{Teacher} & \text{...
User Avatar
1 1 vote
1 1 answer
82
82 views
GO Classes DPP | GATE CS, DA | DBMS | Update Anomaly
A relation contains four tuples for course $\text{CS 186}$, and every tuple stores the teacher as $\text{Hellerstein}$.Lets consider the set of data is as follows :\[\beg...
User Avatar
1 1 vote
1 1 answer
85
85 views
GO Classes DPP | GATE CS, DA | DBMS | Natural Join
Consider $\text{Postings(post, position, user, ptext)}$.Two aliases of this relation are used:$\text{P1 = Postings}$$\text{P2 = Postings}$Consider the query:SELECT count(...
User Avatar
To see more, click for the full list of questions or popular tags.