1 Exam

Question 1

For each attribute of a relation, there is a set permitted values, called the______ of that attribute.

Answer 1

Domain

Question 2

The database ________ refers to the logical design of the database.

Answer 2

Schema

Question 3

The database ________ is a snapshot of the data in the database at a given instant in time.

Answer 3

instance

Question 4

The tuples of relation one can be of______ order.

Answer 4

Any

Question 5

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

Answer 5

Super key

Question 6

If the ______ key from one relation is used as an attribute in that relation.

Answer 6

Primary

Question 7

Tables in second normal form (2NF) must _______.

Answer 7

Eliminate all hidden dependencies

Question 8

Which form simplifies and ensures that there are minimal data aggregates and repetitive groups?

Answer 8

1NF

Question 9

Define function dependency!

Question 10

List the Armstrong axioms.

Question 11

Tuple means _______.

Answer 11

row

Question 12

Attribute means _______.

Answer 12

column

Question 13

The domain specifies what are acceptable ______ within a column.

Answer 13

data values

Question 14

The degree of a table is the width or number of ______.

Answer 14

columns

Question 15

The cardinality of a table is the depth or number of ______.

Answer 15

rows

Question 16

The table violates which Normal Form and why?

Answer 16

2nd Normal Form because there are two partial dependencies

Question 17

An example of an update anomaly is ______.

Answer 17

mistyping one of its instances

Question 18

An example of a delete anomaly is ______.

Answer 18

deleting students resulting in loss of module details

Question 19

The normalized table structure for students and modules consists of ______.

Answer 19

• Student(StudentID, StudentName)
• Module(ModuleID, ModuleName)
• Results(StudentID, ModuleID, Grade)

Question 20

The attribute ‘qualifications’ is multi-valued on the PK, hence the table is not in ______.

Answer 20

1NF

Question 21

To transform into 1NF tables, the solution can include ______.

Answer 21

• Students(StaffID, StaffName, Qualification1, Qualification2, Qualification3)
• Students(StaffID, StaffName)
• Qualifications(StaffID*, Qualification)

Question 22

Entity type describes an object, a noun, a class of ______.

Answer 22

meaningful collection of objects

Question 23

Ternary relationships have ______ participating entity types.

Answer 23

three

Question 24

Binary relationships have ______ participating entity types.

Answer 24

two

Question 25

The accuracy of the cardinality and participation is important in ______.

Answer 25

both cases

Question 26

NULL value means not applicable or ______.

Answer 26

unknown

Question 27

Types of integrity constraints include ______.

Answer 27

* Domain Integrity * Entity Integrity Constraint * Referential Integrity Constraint * Key Constraints

Question 28

A functional dependency is a constraint between ______.

Answer 28

two sets of attributes

Question 29

In an EER model, a category (union type) is created to include entities of ______.

Answer 29

different types

Question 30

The purpose of the HAVING keyword is to ______.

Answer 30

qualify a GROUP BY with a condition

Question 31

Stored procedures encapsulate frequently run segments of ______.

Answer 31

code written in SQL

Question 32

The relational model derived from an ER model cannot accommodate ______ relationships.

Answer 32

many to many

Question 33

Many to many relationships need to be resolved into ______ relationships.

Answer 33

one to many

Question 34

Many to many relationships introduce an associative entity that maps to a ______.

Answer 34

new table with a composite key