Register

Is in BCNF

• edited by
236 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
User Avatar

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
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
2
srestha asked Apr 11, 2018
1,582 views
Normalization-(prime attribute -> prime attribute dependency is there in BCNF)
$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?
$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?
User Avatar
0 votes
0 votes
1 answer
3
hem chandra joshi asked Nov 5, 2017
441 views
which of the following is in BCNF Form AND LOSSY OR LOSSLESS JOIN ?
R(A,B,C,D) 1. A->B , B->CD 2. A->B , B->C , C->D 3. AB->C , C->AD 4. A->BCD
R(A,B,C,D)1. A->B , B->CD2. A->B , B->C , C->D3. AB->C , C->AD4. A->BCD
User Avatar
Link Copied!