Appendix C

Question 1

Entity relationship diagram (ERD)

Answer 1

A technique for documenting the relationships between entities in a database environment

Question 2

Types of attributes

Answer 2

Simple vs. Composite
Single-valued vs. multi-valued
Stored vs. derived
Null-valued

Question 3

Two most commonly used styles of ERD notation are

Answer 3

Chen

Information engineering

Question 4

Chen model

Answer 4

Uses rectangles to represent entities

- attributes are expressed in ovals

Question 5

Types of basic data relationships

Answer 5

One to one
One to many
Many to many

Question 6

Problems with many to many relationships

Answer 6

Relational data model cannot handle many to many relationships directly
Relationships cannot have attributes

Question 7

Table and entity are used synonymously

Answer 7

.

Question 8

The only three pieces of information to retrieve for any specific bit of data

Answer 8

The name of the table
The name of the column
The primary key of the row

Question 9

The underlying relationships in a database environment are:

Answer 9

Independent of the data model

Independent of the DBMS that is being used