edited by
242 views
0 votes
0 votes
employee(person_name,street,city)
works(person_name,company_name,salary)
company(company_name,city)

What are primary keys and does this relation is in BCNF  ?
edited by

1 Answer

0 votes
0 votes
There are 3 relations and no functional dependency is given so all we have to do is based on our assumption

in company relation company_name can be a primary key and since it has only 2 column so it is in BCNF and so in 3NF.in employee table .person name , street and city all 3 may or may not uniquely identify a row in the best case all 3 fields can act as a composite primary key and since every determinant is part of key it is also in BCNF AND 3NF. same is the case for works table  

unless some dependency or some more constraints are not given these questions can not have definite ans

Related questions

1.6k
views
1 answers
1 votes
srestha asked Apr 11, 2018
1,594 views
$AB\rightarrow CD$CD\rightarrow AB$A\rightarrow C$Is it in 3NF or BCNF?Is prime attribute -> prime attribute dependency is there in BCNF?
451
views
1 answers
0 votes
hem chandra joshi asked Nov 5, 2017
451 views
R(A,B,C,D)1. A->B , B->CD2. A->B , B->C , C->D3. AB->C , C->AD4. A->BCD
813
views
3 answers
1 votes
radha gogia asked Jan 14, 2016
813 views
In the relation R(ABCD) , AB-->C , C-->AD How should the table be decomposed so that it is in BCNF , One decomposed relation will be ACD ,what should be other ... >A but C is not a superkey in ABC , so how should the decomposition be done ?