DATA MODEL ASSIGNMENT

BA 325: Data Model/Database Resources

Data Model Terminology

Data Model Figures:

Data Modeling Process:

One Method: 1. Identify the Entities

2. Identify the Relationships* i. Determine the Interactions

ii. Establish the details of the Interactions

3. Determine Unique Identifiers

4. Set the Foreign Keys

5. Identify the Attributes

Second Method: 1. Identify the Entities

2. Identify the Attributes

3. Identify the Relationships* i. Determine the Interactions

ii. Establish the details of the Interactions

4. Determine Unique Identifiers

5. Set the Foreign Keys *Cardinalities: It is important to carefully “read” each relationship both ways.

So for example, you will ask: Given a single instance of MOVIE, how many DVDs can that MOVIE be related to? And given a single instance of DVD, how many movies will show up on that DVD?

Entity Name

Identifier Attribute Attribute . . .

Entity Name

Identifier Attribute Attribute . . . Foreign key (FK)

(1 or many)

(exactly 1)

(0,1, or many)

(0 or 1)