Skip to content
Advertisement

Tag: normalization

How to make it into BCNF

Good morning, I wonder how I can make sure this schema is in BCNF. petition(ID, title, contents, budget, organizationID, official, resultID, applicantID) applicant(ID, name) official(ID, name, department) organization(ID, name, phoneNumber) *Each petition has an official. *Each petition should have more than one organization. This is the hardest option that I cannot handle. With the same petitionID, there can be several

Advertisement