Question

A) Multi-valued attribute
B) Single-valued attribute
C) Identifier
D) Candidate key

Answer 1

A

Answer 2

Storyboarding uses a sequence of static pictures or drawings to narrate a story. The basics of storyboarding are straightforward: a set of frames, connected by navigation lines, tells a story or displays scenes from a story. The frames can be simple or elaborate, and the same frame can be used to narrate the same story from a different viewpoint or under different conditions. Storyboarding is a cost-effective and flexible modeling technique that can be used not only in design, but throughout the development process.

Answer 3

A

Answer 4

Organizational change is sometimes equated with organizational transformation. In other words, this term is referring to some kind of fundamental or radical reorientation in the way the organization operates. Some examples could be restructuring the organization, changing the mission, merging with another organization, and reengineering core processes.

Answer 5

T

Answer 6

B

Answer 7

FALSE

Answer 8

FALSE
Explanation: Because they impose additional overhead, indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.
CL

Answer 9

TRUE

Answer 10

FALSE

Answer 11

Version control is the process of limiting the actions that can be taken by a particular user on shared documents. Version management systems improve the tracking of shared content and potentially eliminate problems caused by concurrent document access. They do not, however, provide version control. With version control systems, each team member is given an account with a set of permissions. Shared documents are placed into shared directories, which are sometimes called libraries. Furthermore, document directories can be set up so that users are required to check out documents before they can modify them. When a document is checked out, no other user can obtain it for the purpose of editing it. Once the document has been checked in, other users can obtain it for editing. Microsoft SharePoint is the most popular version control application for general business.

Answer 12

E-learning

Answer 13

TRUE

Answer 14

C

Answer 15

B

Answer 16

B

Answer 17

A

Answer 18

Information about purchased software can be collected from the vendor; you can actually use the software (software, training materials, documentation, and technical support facilities); you can obtain feedback from other users, and you can use independent software testing services.

Answer 19

D

Answer 20

1. Customers generally key or enter data themselves.
2. Data entered by customers are stored for later use.
3. Data entered at the point of sale are reused throughout the entire order fulfillment process.
4. Information is used as feedback to customers.

Answer 21

D

Answer 22

FALSE

Answer 23

TRUE

Answer 24

(public-key) certificate

Answer 25

B

Answer 26

C

Answer 27

The first task in implementing ERP systems is to create a model of current business procedures and practices, which is called the as-is model. Managers and analysts then compare those as-is processes to the ERP process blueprints and note differences. The company then must find ways to eliminate the differences, either by changing the existing business process to match the ERP process or by altering the ERP system.
Once the differences between as-is processes and the blueprint have been reconciled, the next step is to implement the system. Before implementation starts, however, users must be trained on the new processes, procedures, and use of the ERP system's features and function. Additionally, the company needs to conduct a simulation test of the new system to identify problems. Then, the organization must convert its data, procedures, and personnel to the new ERP system. All of this happens while the business continues to run on the old system.

Answer 28

D

Answer 29

D

Answer 30

TRUE

Answer 31

TRUE

Answer 32

FALSE

Answer 33

Organizations store data in separate databases for several reasons. Given a choice, organizational departments prefer to control the data they use; they are, after all, the experts about the data. For example, accountants know more than anyone about how the accounting database should be used, so it is natural for them to want to control how it is set up, what the data will look like, and how the database will be updated. Also, a department may have very different objectives than other departments in the firm. These objectives might be to minimize inventory or serve customers. A department system that supports a key objective, even if it is an information silo, might be a better solution for the department than an enterprise system that doesn't support that objective as well.

Answer 34

ODBC stands for Open Database Connectivity. It is used to solve the problem caused by each DBMS having its own proprietary application program interface (API). OBDC was created to be a bridge between program code and the APIs. A programmer can write code using ODBC standard statements, and an ODBC driver translates these statements into a form that the DBMS API can understand. Similarly, results sent though the API back to OBDC are translated into standard ODBC forms. This allows application programmers to write to OBDC as a common interface rather than having to learn many APIs.

Answer 35

B

Answer 36

TRUE

Answer 37

Answer: C

Answer 38

B

Answer 39

data stores

Answer 40

prerequisite

Answer 41

FALSE

Answer 42

C

Answer 43

C

Answer 44

A

Answer 45

TRUE

Answer 46

TRUE

Answer 47

FALSE

Answer 48

TRUE

Answer 49

To determine how many rows are in a table, use a SELECT query that contains the SQL COUNT(*) function. This function will return the number of rows in the table.

Answer 50

An association relationship is very similar to an N:M relationship except that the intersection table has attributes of its own. This means that in addition to the foreign key fields linking to the two strong entities, there is at least one additional field in what would otherwise be called the intersection table but is now an association table. For example, intersection table ENROLLMENT for STUDENT and CLASS showing student enrollment in each class would normally have two columns: StudentID and ClassID. However, we can turn this intersection table into an association table by adding the column Grade, which records each student's grade in each class.

Answer 51

Student answers will vary, but should include reference to social networks broadening their offerings to become more portal-like. An example answer is: While Facebook can be a primary destination, the goal of Facebook is to keep users occupied and communicating with each other. One of the main goals of a portal is to provide avenues to third party content and other areas of the Internet. Although social networks are aiming to include portal-like features, in order to keep and grow audiences, the primary goals of a portal currently don't include social sharing.

Answer 52

B

Answer 53

A