Brainscape's Knowledge GenomeTM

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


See full index

computer systems > chapter 3 > Flashcards

chapter 3 Flashcards

1
Q

Which of the following is not something a model of database structures must be able to describe?

A

The sequence that entities are accessed

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

Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class

A

The number of trucks used in the delivery

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

Which of the following is the best description of an association

A

The relationship between two classes

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

Which of following are possible options for minimum multiplicities?

A

0 and 1

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

Which of the following best describes the purpose of a primary key

A

Uniquely identifies each instance of the class

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

Which of the following statements about foreign keys is not true

A

A foreign key cannot be NULL

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

Which of the following is not a criterion for selection of a primary key

A

Longer key values are better than shorter key values

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

Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams

A

Model each process separately

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

Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database

A

Map Associations to Primary Keys

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

Which of the following is not a form of business rules

A

Compulsory

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

Which of the following is a well-formed business rule

A

All of these are well-formed business rules

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

Entity-relationship diagrams (ERDs) are similar in content and purpose to Unified Modeling Language (UML) Class diagrams. Which of the following is not a basic building block of ERDs

A

Associations

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

Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database?

A

Post the primary key of Customers as a foreign key in Sales

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

Consider an association between a Sales class and an Inventory class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Sales class are 0..* and the multiplicities next to the Inventory class are 1..*. Which of the following is the best way to implement that association in your database

A

Create a linking table

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

Consider an association between a Cash Disbursements class and a Cash Accounts class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Cash Accounts class are 1..1. Which of the following is the best way to implement that association in your database?

A

Post the primary key of Cash Accounts as a foreign key in Cash Disbursements

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

Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which of the following is the best way to implement that association in your database

A

Post the primary key of Pet Owners as a foreign key in the Pets

17
Q

Consider an association between a Cities class and a Neighborhoods class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cities class are 1..1 and the multiplicities next to the Neighborhoods class are 1..*. Which of the following is the best way to implement that association in your database

A

Post the primary key of Cities as a foreign key in Neighborhoods

18
Q

Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1. Which of the following is the best way to implement that association in your database

A

Post the primary key of Shipping Companies as a foreign key in Deliveries

19
Q

Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Accountants class are 0..* and the multiplicities next to the States class are 0..*. Which of the following is the best way to implement that association in your database

A

Create a linking table

20
Q

Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1. Which of the following is the best way to implement that association in your database

A

Post the primary key of Vendors as a foreign key in Cash Disbursements

computer systems (9 decks)

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