Is it possible to have a relational schema in BCNF but not Ist normal form? a) Y

Question

Is it possible to have a relational schema in BCNF but not Ist normal form? a) Yes b) No

Order Order Part Part aty Priee Warh Rp Num Date Num Des Nom IName Order and Spert 556 v..vu ?1610 1?20/2007 DR., Gw Raw ' sosno , as 9s365 48 The Everything 2161 1021/2007 K12 Dry 329 95 21617 10/23/2007 ?V06 Ikrar Gym 2 S794.95 2 65 Dear tmen 21617 10/23/2007 CDS2 Microwave$150.006s Oven Deparunment Store 21623 10/23/2007 KV29 Treadmil$1.290.00 Figure 1. Functional dependencies F with sample OrderInfo relation 1. Is it possible to have a relational schema in BCNF but not Ist normal form? a) Yes b) No

Explanation / Answer

answer: No

Explantion:

Database is normalised first into 1NF and 1NF into 2NF, then 2NF into 3NF. , then 3NF into BCNF.

so BCNF has stronger requirements than 1NF. The opposite is true, Database can be 1NF , but not BCNF.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.