Chap # 3 Database Design Process

An entity related to itself in an ERD model refers to:

• Recursive Relationship

• One-to-many relationship

• One-to-one relationship

• Many-to-many relationship

An advantage of partitioning is:

• Extra space

• Relaiability

• Effeciency

• Accuracy

Customers, cars and parts are example of:

• Cardinals

• Entities

• Attributes

• Relationships

In hybrid distribution,what types of fragments are stored at only one site?

• Critical Fragments

• Non critical fragments

• Only large fragments

• Critical and non critical fragments

In ERD model, relationship between two entities is represented by:

• Oval line

• Diamond Line

• Straight Line

• Rectangular box

An index may be created on:

• Foreign key

• Secondary key

• Primary key

• All

A technique for physically arranging the records of a file on secondary storage devices is called:

• Update program

• Retrieval program

• File organization

• Physical organization

Organizing the database in computer disk storage is done in:

• Physical Design

• Logical Design

• Implementation

• File Organization

A relationship between countries and capitals is an example of --------------- relationship.

• One-to-one

• One-to-many

• Many-to-many

• Many-to-one

Which of the following is related to modality?

• Optional

• Mandatory

• Unidirectional

• a and b