Chapter 1 Overview

Question 1

Any person, place or thing with characteristics or attributes that will be included in the system

Answer 1

entity

Question 2

Diagram identifying the entities (customers, books, orders, etc) in the database

Answer 2

E-R model or ERD

Question 3

Shows how entities are related to one another

Answer 3

E-R model/ERD

Question 4

Serves as the logical representation of the physical system to be built

Answer 4

E-R model/ERD

Question 5

In an ERD, an entity is usually represented as a ____ or ___

Answer 5

square or rectangle

Question 6

A ____ depicts how an entity’s data relates to another entity

Answer 6

line

Question 7

If the line connecting two entities is solid, the relationship between the entities is _____

Answer 7

mandatory

Question 8

If the line connecting two entities is dashed, the relationship between the entities is _____

Answer 8

optional

Question 9

3 types of relationships that can exist between 2 entities

Answer 9

1. one-to-one
2. one-to-many
3. many-to-many

Question 10

One-to-one relationships are depicted in an ERD as a ___ line

Answer 10

simple straight

Question 11

A one-to-many relationship is represented by a ___ line with a ___ at the “___” end

Answer 11

straight; crow’s foot; many

Question 12

A ___ line with a ____ at ___ end indicates a many-to-many relationship

Answer 12

straight; crow’s foot; each