Brainscape's Knowledge GenomeTM

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


See full index

CIS4301 - Information and Database Management Systems I > 1.1: Traditional File Management vs Database Management > Flashcards

1.1: Traditional File Management vs Database Management Flashcards

1
Q

Problems Of Early Data Processing

A

Redundancy, Inconsistency, Data-program dependence, Inflexibility

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

Data-program dependence (early data processing)

A

Strict data gathering by the application program, changes in data structure, will require changes in the program.

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

Redundancy (early data processing)

A

Repeated data, wasted memory, etc.

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

Inconsistency (early data processing)

A

Errors between data sets, since one can be updated by not another.

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

Inflexibility (early data processing)

A

Problematic to analyze data, since there’s several files that must have to be combined with high costs

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

Advantages of Database Systems

A

Data Independence, Efficient data access, Common data basis, Concurrent data access, Lacking or Controlled Redundancy, Consistency of Data, Integrity of Data

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

Data Independence (database systems)

A

Independent of application programs, no need to update program when data structure changes.

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

Efficient data access (database systems)

A

Index structures (allows quick access)

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

Common data basis (database systems)

A

since data is not repeated, it is updated correctly in the database. (avoids mismatch of data)

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

Concurrent data access (database systems)

A

Allows multiple users to access data. Concept of transaction for the synchronization of concurrent data accesses.

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

Lacking or Controlled Redundancy (database system)

A

avoids copies of same data, or controlled redundancy to improve performance.

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

Consistency of data (database system)

A

lacking redundancy, DBMS ensures consistency of data for controlled redundancy

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

INTEGRITY of data (database system)

A

Correctness and completeness of data. Formulation of integrity constraints or integrity rules. DBMS checks constraints for each insertion, change, and deletion of data

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

SECURITY of Data (database system)

A

Protection of unauthorized access (view on data). Access control, authentication and encoding are possible protection mechanisms.

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

Backup and Recovery (database system)

A

backup - copies of external storage media (e.g. tapes, discs)
recovery - automatic reconstruction of the last, up-to-date, and consistent database status with aids of tapes and listing the executed changes.

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

Posing QUERIES (database system)

A

Query language, allows, to pose queries to get an immediate answer
Queries can be pose ad hoc (keyboard), embedded into database application programs. Importance of query optimization, query processing, and query execution.

17
Q

Provision of diversified USER INTERFACES (database system)

A

query languages for occasional users, programming interfaces for implementers, etc.

18
Q

Database (DB)

A

Structured storage of large collections of persistent data, reliable basis of up-to-date information.

19
Q

Database Management System (DBMS)

A

All-purpose software system. Allows user to build and manipulate databases in an efficient manner. Software level between physical database and user.

20
Q

Database System (DBS)

A

DBS = DBMS + DB
The Database Management System in addition of Database

21
Q

Meta Data (Stored database definitions)

A

Data about the data. ex. For a student we will store (first name, last name, DOB, etc)
Structure of a database

22
Q

Raw Data (Stored database definitions)

A

The actual data. (Carlos, 18, Student)

23
Q

Data Model

A

Description of structure of a database (data types, relationships, conditions) alongside operations for handling and manipulating the data.

24
Q

Data Model Offers:

A

specs of data objects
specs of relationships between data
specs of operations on data objects

25
Q

DBS has at least 2 data models:

A

Physical, and Logical (data models)

26
Q

Physical data model

A

storage-oriented representation of data.

27
Q

Logical data model

A

user-oriented representation of data.

28
Q

Types of Logical data models

A

Object-based & Record-based

29
Q

Name 3 object based (logical) models

A

Entity-Relationship Model
Object-Oriented Data Model
Object-Relational Data Model (object & record)

30
Q

Name 4 record-based (logical) models

A

Object-Relational Model (object & record)
Relational Data Model
Network Data Model
Hierarchical data model

31
Q

Select all disadvantages of file systems found in the following list:
* Inflexibility
* Redundancy
* Data-program independence
* Consistency

A

Inflexibility
Redundancy

32
Q

Select all ADVANTAGES of database systems found in the following list:
* Efficient data access
* Concurrent data access
* Data independence
* Integrity of data
* Common data basis

A
  • Efficient data access
  • Concurrent data access
  • Data independence
  • Integrity of data
  • Common data basis
33
Q

A data definition language allows the user to:

A) Define and change the structure of a database.
B) Design the structure of a database.
C) No answer text provided.
D) Manipulate the data in a database.

A

A) Define and change the structure of a database.

34
Q

A query allows the user to pose ad hoc queries by using the keyboard and get an immediate answer
(True or False)

A

TRUE

35
Q

Which statements are correct? A database management system is:
* A set of programs for the management of and access to the data in the database.
* An all-purpose software system, which supports the user in the definition, construction and manipulation of databases for different applications in an application-neutral and efficient manner.
* A hardware level between the physical database and the user.
* A repository of data.

A
  • A set of programs for the management of and access to the data in the database.
  • An all-purpose software system, which supports the user in the definition, construction and manipulation of databases for different applications in an application-neutral and efficient manner.
36
Q

Which statements are correct? Metadata:

  • Mean “data about data”
  • Describe the operations of a database system.
  • Are data about the definition of the structure of a database.
A
  • Mean “data about data”
  • Are data about the definition of the structure of a database.
37
Q

The user-oriented representation of data is provided by the:

A) Logical Data Model
B) Physical Data Model

A

A) Logical Data Model

38
Q

What type of data model is a relational data model?

A

A record-based data model

CIS4301 - Information and Database Management Systems I (7 decks)

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