Chap#11 Database Design Process Flashcards

1
Q

Which of the following keys does not hold uniqueness property?

A

Secondary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

An entty related to tself in an ERD model refers to:

A

Recursive Relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Database development process involves mapping of conceptual data model:

A

Implementation Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Line

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

n hybrid distribution which kind of fragments are stored at only one site?

A

Non-critical Fragments

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The database system can be divided into ____ broad categories.

A

4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A relation correspods to the concept of a:

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A tuple is the relational term representing a:

A

Row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The number of tupules is called the:

A

Cardinality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

An attribute corresponds to a:

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The degree of a table is the total number of

A

Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the following is not a broad category of the database system?

A

Semantic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which of the following is a broad category of database systems?

A

Network

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Hierarchy system presents the data to the user in the form of a set of:

A

Tree structure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following are teh systems which have focused on the latest research about the relational database model?

A

➡Deduction
➡Expert
➡Semantic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Object-oriented is a:

A

Latest research on the relational database model

17
Q

A relational database system is a system in which:

A

THe operations are operate on tables only

18
Q

How many tables are present in a database?

A

As required

19
Q

The primary key is used:

A

➡To sort the data speedy
➡Searching is speeded up
➡Not allows duplicate entities

20
Q

In first normal form:

A

tables are break down