Er Diagrams · Database Management System · GATE CSE

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." ...

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

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...

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...