Register
Filter

Recent activity by gauravalgo

1 answer
1
write down Domain Relational Calculas query?
employee(person-name,street,city) works(person-name,company-name,salary) company(company-name,city) manages(person-name,manager-name) Find all employees who earn more than every employee of small bank co-operation
employee(person-name,street,city)works(person-name,company-name,salary)company(company-name,city)manages(person-name,manager-name) Find all employees who earn more than e...
2 answers
2
find whether given relation is dependency preserving
R={ABCDEG} AB->C AC->B AD->E B->D BC->A E->G for the following relations {AB , BC ,ABDE, EG}
R={ABCDEG}AB->CAC->BAD->EB->DBC->AE->Gfor the following relations {AB , BC ,ABDE, EG}
2 answers
3
write down a minimal cover
Consider the attribute set R = ABCDEGH (where Functional Dependencies are F= {AB·--> C,AC --> B: AD ---> E, B -----> D, BE --> A, B -> G}.
Consider the attribute set R = ABCDEGH (where Functional Dependencies areF= {AB· C,AC B: AD - E, B - D, BE A, B - G}.