ch 3 Flashcards

1
Q

What are the two major types of business process models?

A

Activity and structure

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

The structure model is what

A

(data) describe the information structure of the process
Create a blueprint for the development of a relational database

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

The structure model describes the — and the – in the domain of interest

A

entities; things

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

Class diagrams are what?

A

separately identifiable collections of entities in which the organization wants to collect and store information

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

Define Associations

A

depict the relationship between two classes

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

Example of association

A

person –> auto
Means: that a person owns an auto

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

What are multiplicities

A

describe the minimum and maximum number of times one class can be associated with another class

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

Define these multiplicities
1) 0..1
2) 1..1
3) 0..*
4) 1..*

A

1) Zero or one
2) one only
3) zero or more
4) one or more

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

What are the characteristics of a table

A
  1. attributes
  2. primary keys
  3. foreign keys
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are attributes?

A

elments that describe characteristics of classes or rows in a table

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

The primary key is what?

A

uniquely define instances of a class or row

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

Foreign keys

A

Allows tables to be linked
Like data in one datd to another table

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

can a primary key be null? what is null?

A

NO; null means blank

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

Which of the following symbols is used to represent a class in a UML class diagram

A

Rectangle

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

Contrast the UML class diagrams with the entity relationships, which of the following is not equivalent?

Class and entity
association and relationship
multiplicity and cardinality
Class and relationship

A

Class and relationship

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

REVIEW HOMEWORK FOR EXAMPLES OF MULTIPLICITES

A

REVIEW HOMEWORK FOR EXAMPLES OF MULTIPLICITES

17
Q

What is REA:

A
  • Resources: our resources
  • Events: sales purchases
  • Agents/ persons
18
Q

what are the Primary key features

A
  • Contain unique value for each row
  • Cannot be null
  • Every row must have a primary key value
19
Q

How are classes in a UML implemented

A

Separately identifiable collections of things that the organizations wants to collect