Database Management Systems (3130703) MCQs

MCQs of Data Models

Showing 1 to 10 out of 40 Questions
1 2 3 4
1.

Consider the following ER diagram depicting the relationship of an employee and supervisor: What is the possible relation if the above ERD is mapped into a relational model?

(a)

Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName)}
(b)

Supervision (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), EmpID)
(c)

Supervisor (SupervisorID, BirthDate, Salary, Name(FirstName, MiddleName, LastName),EmpID), {EmpID})
(d)

Employee (EmpID, BirthDate, Salary, Name(FirstName, MiddleName, LastName), SupervisorID)
Answer:

Option (d)

2.

The methodology for documenting databases illustrating the relationship between various entities in the database is

(a)

Data flow diagram
(b)

State transition diagram
(c)

Entity-relationship diagram
(d)

Entity sequence diagram
Answer:

Option (c)

3.

An entity set that does not have sufficient attributes to form a primary key is a

(a)

Strong entity set
(b)

Weak entity set
(c)

Simple entity set
(d)

Primary entity set
Answer:

Option (b)

4.

In an E-R diagram attributes are represented by

(a)

Rectangle
(b)

Square
(c)

Ellipse
(d)

Triangle
Answer:

Option (c)

5.

In an E-R diagram an entity set is represent by a

(a)

Rectangle
(b)

Ellipse
(c)

Diamond box
(d)

Circle
Answer:

Option (a)

6.

E-R model uses which symbol to represent weak entity set ?

(a)

Dotted rectangle
(b)

Diamond
(c)

Doubly outlined rectangle
(d)

Doubly outlined diamond
Answer:

Option (c)

7.

Which of the following are the properties of entities?

(a)

Groups
(b)

Table
(c)

Attributes
(d)

Switchboards
Answer:

Option (c)

8.

In E-R Diagram derived attribute are represented by _________

(a)

Ellipse
(b)

Dashed ellipse
(c)

Rectangle
(d)

Triangle
Answer:

Option (b)

9.

In E-R Diagram relationship type is represented by ______________

(a)

Ellipse
(b)

Dashed ellipse
(c)

Rectangle
(d)

Diamond
Answer:

Option (d)

10.

In E-R diagram generalization is represented by

(a)

Ellipse
(b)

Dashed ellipse
(c)

Rectangle
(d)

Triangle
Answer:

Option (d)

Showing 1 to 10 out of 40 Questions
1 2 3 4