ER Model - Quiz 1

DBMS Basics and Entity-Relationship Model - Quiz 1

1. ER modeling is primarily used for

Database Programming
Organizing Databases
Designing Databases
None of the above

2. An Entity Set is

a set of entities of the same type that share the same properties
a set of entities of different type that share the same properties
a set of entities of different type that share the different properties
None of the above

3. The set of permitted values for an attribute is called as

Entity Set
Domain
Value Set
Both Domain and Value Set

4. An attribute which can have many values for a single entity is called as

Composite Attribute
Descriptive Attribute
Derived Attribute
Multivalued Attribute

5. If a record in table R is associated with only one record in table S, and a record in S is associated with only one record in table R, then the relationship between R and S is

One-to-Many
Many-to-One
One-to-One
Many-to-Many

6. The first step in database design is

Physical Database Design
Logical Database Design
Conceptual Database Design
Requirements Gathering and Analysis

7. A relationship is an association between

Two or more Entities
One or more Entities
Entities and Attributes
One or more Attributes

8. Which of the following is not the disadvantage of File Processing System?

Data isolation
Atomicity Problems
Data Redundancy
None of the above

9. The status of a relational table at a particular moment is called

Logical Schema
Metadata
Instance
Subschema

10. Data-Manipulation Language (DML) is a language that enables users to

Design the Database
Insert Data into the Database
Control the Transactions in Database
Define User Privileges

Score =

Correct answers: