Marks 1
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
Which of the following is NOT a superkey in a relational schema with attributes $$V, W, X, Y, Z$$ and primary key $$V Y?$$
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 b...
An index is clustered, if
Given the basic $$ER$$ and relational models, which of the following is INCORRECT?
Consider a relation table with a single record for each registered student with a single record for each registered student with the following attribu...
Consider the entities 'hotel room', and 'person' with a many to many relationship 'lodging' as shown below
If we wish to store information about the...
Marks 2
In an Entity-Relationship $$(ER)$$ model, suppose $$R$$ is a many-to-one relationship from entity set $$E1$$ to entity set $$E2.$$ Assume that $$E1$$ ...
Consider the following $$ER$$ diagram
The minimum number of table needed to represent $$M,$$ $$N,$$ $$P, R1, R2$$ is ...
Consider the following $$ER$$ diagram
Which of the following is a correct attribute set for one of the tables for the correct answer to the above qu...
Let $${E_1}$$ and $${E_2}$$ be two entities in an E-R diagram with simple single-valued attributes, $${E_1}$$ and $${E_2}$$ are two relationships betw...
The following table has two attributes $$A$$ and $$C$$ where $$A$$ is the primary key and $$C$$ is the foreign key referencing $$A$$ with on-delete ca...
Consider the following entity relationship diagram $$(ERD),$$ where two entities $$E1$$ and $$E2$$ have a relation $$R$$ of cardinality $$1:m.$$
The...