An ER model of a database consists of entity types A and B. These are connected by a relationship R which dose not have its own attribute. Under which one of the following condiditons, can the relational table for R be merged with that of A?
Consider an Entity-Relationship(ER) model in which entity sets E_{1} and E_{2} are connected by an m:n relationship R_{12}. E_{1} and E_{3} are connected by a 1: n (1 on the side of E_{1} and n on the side of E_{3}) relationship R_{13}. E_{1} has two single-valued attributes a_{11} and a_{12} of which a_{11} is the key attribute. E_{2 }has two single-valued attributes a_{21} and a_{22} of which is the key attribute. E_{3} has two single-valued attributes a_{31} and a_{32} of which a_{31} is the key attribute. The relationships do not have any attributes. If a relational model is the derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is _______.
Given an instance of the STUDENTS relation as shown below:
For (StudentName,StudentAge) to be a key for this instance,the value X should NOT be equal to ________.
Given the basic ER and relational models, which of the following is INCORRECT?
Consider the following ER diagram
The minimum number of tables needed to represent M, N, P, R1, R2 is
Which of the following is a correct attribute set for one of the tables for the correct answer to the above question?