Database and Information Systems

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/89

encourage image

There's no tags or description

Looks like no tags are added yet.

90 Terms

1
New cards

What is a bit?

The smallest data unit: one binary digit, 0 or 1.

2
New cards

What is a byte?

A group of bits representing a character, number, or symbol; typically 8 bits.

3
New cards

What is a field?

A group of bytes representing one attribute, such as Student Name.

4
New cards

What is a record?

A group of related fields describing one entity, such as one student.

5
New cards

What is a file in the data hierarchy?

A collection of related records, such as all student records.

6
New cards

What is a database?

A collection of related files or data serving multiple applications.

7
New cards

What is an entity in a relational database?

A person, place, thing, or event about which data is stored.

8
New cards

What is an attribute?

A characteristic of an entity, represented by a field or column.

9
New cards

What is a relational database?

A database organizing data into related two-dimensional tables.

10
New cards

What is a row or tuple in a relational table?

One record describing an instance of an entity.

11
New cards

What is a column in a relational table?

A field containing one attribute for the records.

12
New cards

What is a primary key?

A field that uniquely identifies each record in a table.

13
New cards

What is a foreign key?

A field referencing a primary key in another table to link records.

14
New cards

SUPPLIER and PART: how is Supplier Number used?

Primary key in SUPPLIER; foreign key in PART.

15
New cards

What does a DBMS separate?

The logical view of data from its physical storage.

16
New cards

How does a DBMS improve traditional file systems?

Controls redundancy, reduces inconsistency, and centralizes data management.

17
New cards

What is data redundancy?

Unnecessary duplication of the same data in multiple places.

18
New cards

What is data inconsistency?

Conflicting values for the same data across files or records.

19
New cards

What is a Data Definition Language (DDL)?

Defines database structure, tables, and field characteristics.

20
New cards

What is a data dictionary?

A repository of definitions and characteristics of data elements.

21
New cards

What is a Data Manipulation Language (DML)?

Adds, changes, deletes, or retrieves data in a database.

22
New cards

What does SQL stand for?

Structured Query Language.

23
New cards

Which DBMS capability modifies or retrieves records?

Data Manipulation Language (DML).

24
New cards

What is an entity-relationship diagram?

A diagram showing entities and relationships in a data model.

25
New cards

What is a one-to-one relationship?

Each instance has exactly one related instance on the other side.

26
New cards

What is a one-to-many relationship?

One instance can relate to many; each of those relates to at most one.

27
New cards

What is a many-to-many relationship?

Instances on both sides can have multiple related instances.

28
New cards

What are the three sources of network effects?

Exchange, staying power, and complementary benefits.

29
New cards

What is a network effect?

A product becomes more valuable as the number of users grows.

30
New cards

What does staying power mean?

The long-term viability of a product or service.

31
New cards

What are complementary benefits?

Additional products or services that increase a network's value.

32
New cards

What is technological leapfrogging?

Skipping older technologies to adopt newer ones.

33
New cards

What is the data hierarchy?

Bit → byte → field → record → file → database.

34
New cards

What is a DBMS?

Software that manages databases and interfaces with applications.

35
New cards

Primary key vs. foreign key?

Primary uniquely identifies a record; foreign links to another table.

36
New cards

What are the three main DBMS capabilities?

Data definition, data dictionary, and data manipulation.

37
New cards

What are the original three Vs of Big Data?

Volume, variety, and velocity.

38
New cards

What are the additional two Vs of Big Data?

Veracity (trustworthiness) and value (business usefulness).

39
New cards

Descriptive vs. predictive analytics?

Descriptive explains the past; predictive forecasts future outcomes.

40
New cards

What does prescriptive analytics do?

Recommends actions or optimal decisions.

41
New cards

Moore's Law vs. Mass Digital Storage?

Moore: computing power doubles ~18 months; storage: amount stored doubles annually.

42
New cards

What is green computing?

Reducing the environmental impact of computing.

43
New cards

What is autonomic computing?

Systems that manage and maintain themselves with minimal human intervention.

44
New cards

Goal Seek vs. Data Table?

Goal Seek finds an input for a target; Data Table tests input values.

45
New cards

What are Solver's three model components?

Decision variables, objective function, and constraints.

46
New cards

What does a binding constraint mean?

The resource is fully utilized; slack equals zero.

47
New cards

What is a shadow price?

Marginal objective-value change from one more resource unit, within its valid range.

48
New cards

What does an Answer Report show?

Optimal objective, decision variables, and constraint slack.

49
New cards

What does a Sensitivity Report show?

Shadow prices and allowable changes to model parameters.

50
New cards

PMT vs. IPMT vs. PPMT?

Total periodic payment vs. interest portion vs. principal portion.

51
New cards

CUMIPMT vs. CUMPRINC?

Total interest vs. total principal over a range of periods.

52
New cards

Why is the initial investment outside Excel NPV?

It occurs at time zero and is already at present value.

53
New cards

Tableau dimensions vs. measures?

Dimensions categorize data; measures are numerical values.

54
New cards

When is AVG preferable to SUM?

When comparing per-transaction values across groups of different sizes.

55
New cards

What is the Tableau profit-margin formula?

[Profit]/[Sales] — without a leading equals sign.

56
New cards

What does unchecking Aggregate Measures do?

Displays individual marks instead of aggregated values.

57
New cards

What is a Tableau dashboard?

Multiple worksheets or visualizations combined into one view.

58
New cards

Why do firms use customer loyalty cards?

To gather purchase data and improve targeting, service, and retention.

59
New cards

Why do consumers use loyalty cards?

For rewards, discounts, or personalized benefits.

60
New cards

Why might data fail to create lasting advantage?

Competitors may obtain similar data or copy the analysis.

61
New cards

What is data analytics?

Using math and statistics to interpret data for decisions.

62
New cards

What is volume in Big Data?

The large quantity of data generated and stored.

63
New cards

What is variety in Big Data?

Different data formats and sources, such as text, images, and tables.

64
New cards

What is velocity in Big Data?

How quickly data is generated and must be processed.

65
New cards

What is veracity in Big Data?

The trustworthiness, accuracy, and quality of data.

66
New cards

What is value in Big Data?

The useful business benefit obtained from data.

67
New cards

Which analytics category uses dashboards and scorecards?

Descriptive analytics.

68
New cards

Which analytics category forecasts customer responses?

Predictive analytics.

69
New cards

Which analytics category uses optimization and simulation?

Prescriptive analytics.

70
New cards

What are network externalities?

Another name for network effects.

71
New cards

What is Metcalfe's Law?

Network value is proportional to the square of connected users.

72
New cards

What is exchange as a network-effect source?

Value created when network users interact or exchange information.

73
New cards

What are switching costs?

Money, time, learning, or data loss incurred when changing products.

74
New cards

What is a one-sided network?

A network deriving most value from one class of users.

75
New cards

What is a two-sided network?

A platform connecting two distinct participant groups.

76
New cards

What are cross-side network benefits?

More users on one side increase value for the other side.

77
New cards

Example of a two-sided network?

Job seekers and recruiters, or cardholders and merchants.

78
New cards

What must technological leapfrogging overcome?

Incumbent exchange benefits, switching costs, and complements.

79
New cards

Name a strategy for building network effects.

Move early, subsidize adoption, or leverage viral promotion.

80
New cards

What is IT infrastructure?

The technology platform supporting a business's information systems.

81
New cards

Name four IT infrastructure components.

Hardware, software, data management, and networking/telecommunications.

82
New cards

What are technology standards?

Specifications enabling product compatibility and network communication.

83
New cards

Batch processing vs. online processing?

Batch processes stored transactions together; online processes immediately.

84
New cards

What is grid computing?

Combining remote computers' processing power into a virtual supercomputer.

85
New cards

What is virtualization?

Making one physical computing resource function as multiple resources.

86
New cards

What is cloud computing?

Obtaining computing resources over the Internet.

87
New cards

What is SaaS?

Software delivered as a service over the Internet.

88
New cards

What is IaaS?

Computing infrastructure provided as a service over the Internet.

89
New cards

System software vs. application software?

System software controls hardware; application software serves user tasks.

90
New cards

What is open-source software?

Software whose source code is available to inspect and modify.