Bissoy.com
Doctors Medicines MCQs Q&A

Consider the relation schema: Singer(singerName, songName). What is the highest normal form satisfied by the "Singer" relation schema?

Consider the relation schema: Singer(singerName, songName). What is the highest normal form satisfied by the "Singer" relation schema? Correct Answer BCNF

The correct answer is option 3.

Concept:

Normalization:

Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies.

1NF (First Normal Form):

  • Each table cell should contain a single value.
  • Each record needs to be unique.

2NF (Second Normal Form):

  • It should be in 1NF.
  • Single Column Primary Key that does not functionally dependant on any subset of candidate key relation.

3NF (Third Normal Form):

  • It should be in 2NF.
  • It has no transitive functional dependencies.

Boyce-Codd Normal Form (BCNF):

  • A relation R is in BCNF if R is in Third Normal Form and for every FD, LHS is super key.
  • A relation is in BCNF iff in every non-trivial functional dependency X –> Y, X is a super key.

The given relation schema:

Singer(singerName, songName).

  • Every Binary Relation ( a Relation with only 2 attributes ) is always in BCNF. If a relation is BCNF then it should be in 3NF, 2NF, 1NF.

Hence Singer(singerName, songName) is Boyce-Codd Normal Form (BCNF).

Hence the correct answer is BCNF.

Related Questions

Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema I: Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency: rollno → courses Schema II: Non-trivial functional dependencies: rollno, courseid → email email → rollno Schema III: Non-trivial functional dependencies: rollno, courseid → marks, grade marks → grade Schema IV: Non-trivial functional dependencies: rollno, courseid → credit courseid → credit Which one of the relational schemas above is in 3NF but not in BCNF?
Which of the following statements is/are FALSE? (i) By definition a relation schema is in first normal form. (ii) A relation schema which is in third normal form is definitely in BCNF.
A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE (VOLUME, NUMBER) → YEAR (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE The database is redesigned to use the following schemas. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not?  
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. Employee (empId, empName, empAge) Dependent(depId, eId, depName, depAge) Consider the following relational algebra query: ΠempId(employee)-ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent) The above query evaluates to the set of empIds of employees whose age is greater than that of
Consider the following remarks pertaining to the irrotational flow: 1. The Laplace equation of stream function \(\frac{{{\delta ^2}{\rm{\Psi }}}}{{\delta {x^2}}} + \frac{{{\delta ^2}{\rm{\Psi }}}}{{\delta {y^2}}} = 0\) must be satisfied for the flow to be potential. 2. The Laplace equation for the velocity potential \(\frac{{{\delta ^2}{\rm{\varphi }}}}{{\delta {x^2}}} + \frac{{{\delta ^2}{\rm{\varphi }}}}{{\delta {y^2}}} = 0\) must be satisfied to fulfil the orate . of mass conservation i.e continuity equation.. Which of the above statements is/are correct?
Given a relation schema R(ABCDEFGH) in first normal form. For the set of dependencies F={ A → B, A → C, CG → H, B → H, G → F}, which dependency is logically implied?
Consider the following properties: A. Reflexive B. Antisymmetric C. Symmetric Let A = {a, b, c, d, e, f, g} and R= {(a, a),(b, b),(c, d),(c, g),(d, g),(e, e),(f, f),(g, g)} be a relation on A. Which of the following property (properties) is (are) satisfied by the relation R ?
If a relation is in third normal form, it does not need to be in second normal form.
In the following figure, the square represents teacher, the triangle represents singer, the circle represents dancer and rectangle represents biker. Which letter represents the teachers who are dancer and biker  but not singer?
There are nine member in a family. Mukesh is younger brother of Arun who is elder brother of Arvind who is father of Tanu. Singer is father of Businessman who is son of Tanu. Doctor is sister of Shivam who is nephew of Arvind and Mukesh. Student is niece of Arvind and Arun. Tanu is married to singer. How many female member in the family?