Question

Fill in the blanks with correct word

Answer 1

Views

Answer 2

A
Explanation: A) Systems planning and selection is the first of four SDLC phases.
CL

Answer 3

The select operation creates a subset consisting of all records (rows) in the table that meets stated criteria. The join operation combines relational tables to provide the user with more information than is available in individual tables. The project operation creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the information required.

Answer 4

E

Answer 5

B

Answer 6

TRUE

Answer 7

FALSE

Answer 8

Middleware is software that takes information about sales and inventory shipments from the electronic commerce software and transmits it to accounting and inventory management software in a form that these systems can read. For example, the sales module of an accounting system might be designed to accept the input of a telephone salesperson.
Larger companies usually establish connections between their electronic commerce software (that is, their catalog display, shopping cart, and transaction processing software) and their accounting and inventory management databases or applications by using middleware.

Answer 9

B

Answer 10

SYSTEM

Answer 11

Ans: (d)

Answer 12

C

Answer 13

A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. Thus, user review of the data model is crucial. When a database is developed, users must carefully review the data model. If they do not understand any aspect of it, they should ask for clarification until they do. Entities must contain all of the data they need to do their jobs, and relationships must accurately reflect their view of the business. If the data model is wrong, the database will be designed incorrectly, and the applications will be difficult to use, if not worthless. Developers should not proceed with the database design unless the data model is accurate.

Answer 14

The obvious part of the database design is the ER drawing itself, for example as shown for VRG in Figure 6-39. However, this needs to be accompanied by a summary of the database design relationships as shown in Figure 6-40. This document summarizes the cardinalities of relationships. For each relationship, we need a set of actions to enforce the minimum cardinalities. These can be based on Figures 6-28(a) and 6-28(b), the examples for VRG are shown in Figures 6-41 and 6-42. Finally, we need a set of column characteristics for each table, as shown in Figure 6-43 for VRG.

Answer 15

Disaster contingency planning needs to be an integral part of doing business, and requires a commitment of resources to a disaster recovery process. In addition, business continuity and IT disaster recovery plans must be based on an assessment by top management of cost versus risk.

Answer 16

A

Answer 17

FALSE

Answer 18

A

Answer 19

I appreciate you answering this question. Great community

Answer 20

C

Answer 21

FALSE

Answer 22

C

Answer 23

FALSE

Answer 24

A

Answer 25

C

Answer 26

Ans: (a)

Answer 27

FALSE

Answer 28

TRUE

Answer 29

Kerberos

Answer 30

TRUE

Answer 31

TRUE

Answer 32

A semicolon ";" following the end of an SQL statement indicates the end of the SQL command. In a list of multiple SQL statements, the semicolon indicates where each SQL statement ends.

Answer 33

subtype

Answer 34

FALSE

Answer 35

FALSE

Answer 36

TRUE