Brainscape's Knowledge GenomeTM

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


See full index

Fall Sem 2022 > 2141 > Flashcards

2141 Flashcards

1
Q

Data

A

Raw representation of facts

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

Information

A

data put into context (patterns trends relationships)

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

Knowledge

A

Application of data and information. (patterns, assumptions, theories experience

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

How does accurate, relevant and timely information interact with organizational survival?

A

It leads to good descision making which in turn leads to success in global organizational survival

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

Three types of file systems

A

Manual, computerized and modern end-user productivity tools (think microsoft excel)

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

Field

A

A character or group of characters (alphabetic or numeric) that has a specific meaning. A field is used to define or store data

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

Record

A

A connected set of fields that describes a person place or thing. (think row in a data table)

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

File

A

A collection of related records (think column in a database)

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

Problems with file systems

A
  • lengthy development time
  • difficulty of getting quick answers
  • complex system administration
  • Lack of security and limited data sharing
  • Extensive programming
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Structural dependence

A

Access to a file is dependent on its structure. This means all file system programs need to be modified to conform to a new file structure

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

Structural independence

A

File structure can be changed without affecting the applications (or file system programs) ability to access data –> this is good

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

Data dependence

A

Data access changes when data storage characteristics change

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

Data independence

A

Data storage characteristic is changed without affecting the programs ability to access data

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

Data redundancy

A

Unnecessarily storing same data at different places leads to poor security, inconsistency, and data entry errors

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

Islands of information

A

Scattered data locations

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

Data anomaly

A

develops when not all the required changes in the redundant data are made successfully

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

Types of data anomaly

A

Update anomalies, Insertion anomalies and Deletion anomalies

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

Database

A

a shared integrated computer structure that stores a collection of end user data, metadata and

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

Meta data

A

Data about data describes data relationships and characteristics

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

Database management system (DBMS)

A

Collection of programs that controls access to data stored in a database and manages its structure

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

Data management

A

Process of acquiring, storing and retrieving data (addition, deletion and modification)

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

What two kinds of data does a database contain

A

End user data craw facts) and metadata

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

Advantages of a DBMS

A

Improved data sharing, data security, integration, access and minimized data inconsistency

24
Q

Data inconsistency

A

A condition in which different versions of the same data yield different (inconsistent) results

25
Q

Query

A

A question/task from the end user or application to the DBMS (in the form of an SQL code)

26
Q

Ad hoc query

A

A spur of the moment question

27
Q

Query result set

A

The DBMS response to a query. Typically en the form of a collection of data rows

28
Q

Data quality

A

A comprehensive approach to ensuring the accuracy validity and timelines of data

29
Q

Single user database us multiuser

A

A database that supports one vs multiple concurrent users (no way)

30
Q

Desktop vs. Work group database

A

Desk top → single user runs on a personal computer
Workgroup → multiple users (fewer than 50) usually used for a specific department or organization

31
Q

Database Enterprise

A

One step up from a workgroup data base supports more than 50 users, typically an entire organization

32
Q

Centralized vs distributed database

A

Centralized located at one single site
Distributed → logically related database stored in two or more physically independent sites

33
Q

General purpose database vs discipline specific database

A

GP → contains wide variety of data used in multiple disciplines
DP → contains data focused on specific subject areas

34
Q

Operational / online transaction processing (oltp) / transactional / production database

A

All terms referring to the same thing: A database designed to primarily support a company’s day to day operations

35
Q

Analytical database

A

A daterbased used to stove historical data and business metrics used f for strategic/ tactical decision making

36
Q

Two main components of an analytic database

A

Date warehouse → stones data in a format optimized for descision making
Online analytic processing (olap) → took for retrieving processing and modelling data from a data warehouse

37
Q

Business intelligence

A

A set of tools and processes used to capture, collect process, store and analyze business data for descision making

38
Q

Structured unstructured and semi structured data

A

Unstructured exists their original state, structured results from formatting and format is applied based on type of processing to be performed. Semi structured is processed to someextent

39
Q

Extensible markup language (XML)

A

Represents dater elements in textual format → it is a metalanguage

40
Q

Database design

A

The second stage of the database life cycle → process that yields the description of the database structure and thus determines the database components

Essentially just the design of database structure that will be used to store and manage end-user data

41
Q

A well designed database..

A

Facilitates data management and generates accurate and valuable information → No difficult to trace errors

42
Q

Evolution of file system data processing

A

From manual file Systems to computerized file systems to end user productivity tools

43
Q

Transaction

A

A sequence of database requests that access a database s A transaction is a logical unit of work. This means it must be either entirely completed or aborted

44
Q

What properties must all transactions have?

A

Atomicity → All or nothing
Consistency → any transaction brings the database from one valid state to another
Isolation → Data undergoing a transaction cannot undergo another transaction until the first is finished which is especially useful for multiuser databases
Durability → once a transaction has been committed it will remain so, even in the event of a power loss, crash or breakdown.

45
Q

Base model

A

Usually employed by no SQL databases, this model favours availability over consistency

Basic availability → system guarantees availability as regards to the cap theorem (consistency, availability and partition)
Soft state → system state could change over time even without input due to eventual consistency -
Eventual consistency → system will eventually become consistent when it stops receiving input

46
Q

Database vs. A file

A

A database is better for storing structured dater and more of it with well defined data formats
A file is for more arbitrary unstructured data

47
Q

Entity in data modelling

A

Something representing a particular type of object in the real world → each entity occurrence is distinguishable

Eg) a customer entity would contain customer occurrences

48
Q

Atribute in data modelling

A

A characteristic of an entity

49
Q

Relationships in data modelling

A

Describes the association among entities

50
Q

Three kinds of data modeling relationships

A

One to many 1:m
Many to many m:n
One to one 1:1

51
Q

Data constraint

A

A role put into place to ensure data integrity

52
Q

Business rule

A

A description of a policy procedure or principle within an organization
Helps standardize the companies View of data
Can be a communication tool between users and designers

53
Q

Which two questions should you ask in data modelling to properly identify the relationship type?

A

How many instances of A are related to one instance of B

How many instances of B are related to one instance of A

54
Q

Conceptual data model

A

Provides a global View of the entire database and describes the main objects avoiding detail

55
Q

The physical data model

A

This one operates on the lowest level of abstraction this model is both hardware and software dependent

56
Q

Logical model

A

Fall Sem 2022 (4 decks)

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