Brainscape's Knowledge GenomeTM

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


See full index

CIS > Chapter 11 > Flashcards

Chapter 11 Flashcards

1
Q

Database?

A

Collection of data organized in a manner that allows access, retrieval, and use of that data

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

Data? what is it and examples

A 
Collection of unprocessed items
Text
Numbers
Images
Audio
Video
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Database software, often called a database management system (DBMS), allows users to?

A

Create a computerized database
Add, modify, and delete data
Sort and retrieve data
Create forms and reports from the data

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

A character is one byte. examples…

A

Numbers, letters, blank space, punctuation marks, or other symbols

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

A field is a?

A

combination of one or more related characters
Field name
Field size
Data type

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

A record is a?

A

group of related fields

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

A primary key is a?

A

field that uniquely identifies each record

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

A data file is a?

A

collection of related records

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

File maintenance refers to?

A
  • the procedures that keep data current
    Adding records
    Modifying records
    Deleting records
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Validation compares?

A 
-  data with a set of rules or values to determine if the data meets certain criteria
Alphabetic/Numeric check
Range check
Consistency check
Completeness check
Check digit
Other checks
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

File processing system?

A

Each department has its own set of files
Redundant data
Isolated data

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

Database approach?

A 
Programs and users share data
Reduced data redundancy
Improved data integrity
Shared data
Easier access
Reduced development time
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Disadvantages of a database approach? 3 things

A
  1. Can be more complex than a file processing system
  2. Require more memory and processing power
  3. Data can be more vulnerable
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Web databases offer information about?

A 
Jobs
Travel
Destinations
Television programming
Photos
Movies
Videos
Local and national weather
Sporting events
Legislative information
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A data model defines how?

A
  • users view the organization of the data
    ex.
    Relational database
    Object-oriented database (OODB)
    Multidimensional and other database types
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A data dictionary contains?

A

data about each file in the database and each field in those files

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

A DBMS (data base management system) provides?

A
  • several tools that allow users and programs to retrieve and maintain data in the database
    ex.
    Query language
    Query by example
    Form
    Report writer
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A query is a?

A

request for specific data from the database

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

A query language consists of?

A

simple, English-like statements that allow users to specify the data to display, print, store, update, or delete

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

Structured Query Language (SQL) is a

A

popular query language that allows users to manage, update, and retrieve data

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

A form is a window on the screen that provides?

A

areas for entering or modifying data in a database

22
Q

A report writer allows users to?

A

design a report on the screen, retrieve data into the report design, and then display or print the report

23
Q

A DBMS provides means to ensure that only authorized users access data such as …

A

Access privileges

Principle of least privilege policy

24
Q

A DMBS provides a variety of techniques to restore the database to a usable form in case it is damaged or destroyed such as…

A

Backup
Log
Recovery utility
Continuous backup

25
Q

An information system is a collection of hardware, software, data, people, and procedures that?

A

work together to produce information

26
Q

System development is a set of activities used?

A

to build an information system

27
Q

System development is a set of activities used to build an?

A

information system

28
Q

System development activities are grouped into phases, and is called the?

A

system development life cycle (SDLC)

29
Q

System development should follow three general guidelines?

A

Group activities into phases
Involve users
Define standards

30
Q

A systems analyst is responsible for?

A

designing and developing an information system

31
Q

Project management is the process of?

A

planning, scheduling, and then controlling the activities during system development

32
Q

To plan and schedule a project efficiently, the project leader identifies the following elements?

A 
Scope
Required activities
Time estimates for each activity
Cost estimates for each activity
Order of activities
Activities that can take place at the same time
33
Q

Feasibility is a measure of?

A 
how suitable the development of a system will be to the organization
Operational feasibility
Schedule feasibility
Technical feasibility
Economic feasibility
34
Q

The analysis phase consists of two major activities. what are they and describe them

A
  1. Conduct a preliminary investigation
    - Determines the exact nature of the problem or improvement
    - Interview the user who submitted the request
  2. Perform detailed analysis
    - Study how the current system works
    - Determine the users’ wants, needs, and requirements
    - Recommend a solution
35
Q

The system proposal assesses the?

A

feasibility of each alternative solution

36
Q

The steering committee discusses the?

A

system proposal and decides which alternative to pursue

37
Q

The design phase consists of two major activities?

A
  1. Acquire hardware and software

2. Develop all of the details of the new or modified information system

38
Q

A prototype (proof of concept) is a working model of the?

A

proposed system’s essential functionality

39
Q

The purpose of the implementation phase is to?

A

construct the new or modified system and then deliver it to users

40
Q

Various tests should be performed on the new system. four of them and what are they?

A
  1. Unit test
    - Verifies that each individual program or object works by itself
  2. Systems test
    - Verifies that all programs in an application work together properly
  3. Integration test
    - Verifies that an application works with other applications
  4. Acceptance test
    - Checks the new system to ensure that it works with actual data
41
Q

Training involves showing users what?

A 
exactly how they will use the new hardware and software in the system
ex. 
One-on-one sessions
Classroom-style lectures
Web-based training
42
Q

One or more of four conversion strategies can be used to change from the old system to the new system. what are they?

A

Direct conversion
Parallel conversion
Phased conversion
Pilot conversion

43
Q

The purpose of the support and security phase is to?

A

provide ongoing assistance for an information system and its users after the system is implemented

44
Q

A programming language is a set of

A

words, abbreviations, and symbols that enable a software developer to communicate instructions to a computer or mobile device

45
Q

An application development tool provides?

A

a means for creating, designing, editing, testing, and distributing programs and apps

46
Q

With a procedural language, the programmer writes instructions using English-like words that tell the computer?

A

what to accomplish and how to do it

47
Q

An object-oriented programming (OOP) language allows system developers?

A

to implement objects in a program

48
Q

C++ is an?

A

extension of the C programming language

Additional features for working with objects

49
Q

Visual Studio is Microsoft’s suite of object-oriented application development tools that?

A

assists software developers in building programs and apps for Windows or any operating system that supports the Microsoft .NET Framework

50
Q

HTML is a special formatting language that software developers use to?

A

format documents for display on the web

CIS (11 decks)

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