Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ACC 340 > Chapter 5 > Flashcards

Chapter 5 Flashcards

1
Q

Conceptual Model

A

Is a representation that depicts the important objects and relationships between the objects that must be captured in a databse

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

Unified Modeling Language (UML)

A

A widely accepted notation for system analysis and design that includes several types of diagrams for different levels of analysis

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

Entity

A

Real world object that has separate existence (either physical or conceptual)

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

Association

A

Relationship between classes

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

Association Class

A

Represents a relationship in which there can be only one link between the related entities

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

Attribute

A

A characteristic possessed by a class or an association

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

Primary Key Attribute

A

Used to uniquely and universally describe each instance of a class or association class

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

Simple Attribute

A

Attribute that cannot be further decomposed

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

Composite (Complex) Attribute

A

May be decomposed into other attributes

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

Derivable Attribute

A

Attribute that can be derived (computed) from the values of other attributes in the database.

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

Static Derivable Attribute

A

Those for which the derived value will not change if new data is entered into the database

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

Volatile Derivable Attribute

A

Those for which the derived value will change if new data is entered into the database

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

Optional Participation

A

Means that any specific instance of the class can exist in the database without a corresponding instance of the associated class.

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

Mandatory Participation

A

Means that each instance of the class must be related to at least one instance of the associated class in order to be included in the database.

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

Maximum Multiplicities

A

Represent the maximum number of times each instance of a class may participate in an association with another class. (one and many)

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

Foreign Key

A

The primary key of one class table that is “posted” into another class table to represent an association between those classes.

17
Q

Referential Integrity

A

A value for a foreign key attribute must either by null or it must match one of the data values in the table in which the attribute is a primary key

18
Q

Which statement accurately interprets one or more of the multiplicities that are depicted below in the Alpha to Omega relationship?
Alpha to Omega
0..1 0..*

A

IDK

19
Q

Primary key attributes:

A

IDK

20
Q

Which statement accurately explains one or more of the following multiplicities between the “Customer Order” and the “Delivery” events?
Customer Order Delivery
1..* 0..1

A

IDK

21
Q

Customers that come in to Furniture Galore, Inc. may be helped by any available salesperson. If more than one salesperson helps the same customer with the same merchandise, any resulting sale to that customer will be credited to all involved salespeople, who will split the sale commission. Salespeople are added to the database as soon as they are hired. A sale cannot be made without a salesperson. The multiplicities for the association between the Sale and Salesperson for Furniture Galore, Inc. are:

A

IDK

22
Q

Any attribute that may be decomposed into other attributes is called a

A

IDK

23
Q

Which of the following represent invalid multiplicities for a class’ participation in an association?

A

IDK

24
Q

Which of the following minimum and maximum multiplicities represent a class that has optional participation in an association and can participate in the association multiple times?

A

IDK

25
Q

The intension of relational database table is its

A

IDK

26
Q

In relational database design, a primary key of one table that is also included in another table

A

IDK

27
Q

Which of the following is NOT another name for the columns in a relational database?

A

IDK

28
Q

Which of the following describes referential integrity?

A

IDK

29
Q

Which of the following statements about is correct regarding the concept of load?

A

IDK

30
Q

Load indicates

A

IDK

31
Q

Which of the following is most likely a violation of the one-fact, one-place rule?

A

IDK

32
Q

Creating separate tables to represent associations helps to avoid

A

IDK

ACC 340 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions