Brainscape's Knowledge GenomeTM

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


See full index

Database > Unit 1 > Flashcards

Unit 1 Flashcards

On y va !

1
Q

Critical raw asset that requires to be processed

A

Data

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

The process of ingesting, organizing and maintaining data (collected by an organization).

A

Data Management

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

Different levels of developing data management

A

Three. Manual, Traditional file based and Database approaches.

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

Which approach uses data retrieval by cabinet, file and information hierarchy? (could have an indexing system)

A

Manual

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

Limitations of Manual approach

A

Prone to error

Difficult to update, retrieve, integrate

It is difficult to compile information

Limited to small size information

Cross referencing is difficult

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

Which approach stores data in permanent files and uses different applications to retrieve and record files?

A

File based

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

Which approach uses different application programs which manage its own sets of data?

A

File based

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

Limitations of file based

A
  1. Redundancy
    –the same information may be duplicated in several places (files) resulting to higher storage and access cost
    Inconsistency
    –the various copies of the
    same data may no longer agree
  2. Difficulty accessing data
    –users being unaware of potentially useful data in other programs so its inefficient and inconvenient
  3. Data isolation
    –hard to make a program to retrieve the appropriate data
  4. Data dependence
    –change in the data structure need to changes the program
    –physical structure and storage are defined in the application code

5.Incompatible file formats
–Programs might written in different languages, and so cannot easily access each other’s files
6. Fixed Queries/Proliferation of app programs
–programs are specific and new things require new programs

7.Security problems (hard to set security)

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

What is data isolation?

A

determines when and how changes made by one operation become visible to other concurrent users and systems

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

The ability of the database to allow multiple users access
to the same record without adversely affecting transaction processing

A

Concurrency

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

Two main reasons of File based was mauvais

A

data is stored in application programs instead of separately

no control over access and manipulation of data beyond application programs

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

Repository of related data that supports efficient data maintenance

A

Database

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

What is a Database management system?

A

Software system that enables user to use a computerized database

Interface between application programs and data files

Separates the logical and physical view

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

What is a database system?

A

collection of interrelated files and set of programs that allow users to access and modify these files

Provides a layer of abstraction

DBMS + data + maybe applications

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

Components of a database system

A

Hardware(multiple or single computers)

Software (the DBMS,OS and the network software)

Data( contains operational and meta data)

Procedures ( instructions of the database)

People (professional and end users)

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

The three levels of data abstractions:

A

Physical, logical and view level.

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

What is physical level abstraction?

A

describes complex low level data structures in detail

17
Q

Which level of abstraction is the lowest/most complex?

A

Physical

18
Q

which abstraction level describes the entire database in terms of a small number of relatively simple structures

A

Logical

19
Q

How is abstraction done in a logical level

A

by describing what is stored and the relationship among the data

20
Q

View level abstraction

A

Highest level of abstraction which describes only part of the entire database

21
Q

Which level of abstraction is used to simplify user interaction?

A

View level

22
Q

Prevention of users form accessing certain parts is done by which level of abstraction?

A

View level

23
Q

Benefits of data abstraction:

A

–Reduce complexity

–Provide a level of security

–Provide a mechanism to customize the appearance of the database

–Present a consistent, unchanging picture of the structure of the
database, even if the underlying database structure is changed (
Abstraction)

24
Q

Advantages of DBS

A

–Control of data redundancy
–Data consistency
–More information from the same amount of data
–Sharing of data
–Improved data integrity
–Improved security
–Enforcement of standards
–Economy of scale
–Improved data accessibility and responsiveness
–Increased productivity
–Improved maintenance through data independence
–Increased concurrency
–Improved backup and recovery services

25
Q

Disadvantages of DBS

A

–Complexity
–Size
–Cost of DBMS
–Additional hardware costs
–Cost of conversion
–Performance
–Higher impact of a failure

26
Q

What does a Data administrator aka data analyst do?

A

–Processing data into a data model
–figure out which data is relevant to be stored in the database
–Overall management of data resources

27
Q

Creating and updating the database is whose job?

A

DBA

27
Q

What does a database administrator do?

A

–Creating, maintain, backup, optimize the database and ensures the safety
– Integrate database to applications

27
Q

What is aka Database programmer /database coordinator

A

DBAdmin

28
Q

What do logical database designers do?

A

identify data that is to be stored (entity with attributes, relationship between the entities, constraints on the entities)

29
Q

Who should have a thorough and complete understanding of the organization’s data and constraints.

A

logical db designers

30
Q

the types of database designers

A

Physical and logical

31
Q

Which DB designers decide how the logical DB design is physically realized?

A

Physical database designers

32
Q

Responsibilities of physical DB designers

A

–Map logical database design into a set of integrity constraints

–Select specific storage structures and access methods for the data to achieve good performance.

33
Q

Applications developers are…

A

developers that implement applications programs which provide functionality to the end users, only once after the DB is implemented.

34
Q

Responsibilities of application developers

A

–Designing and developing database applications

–translate the requirements of the software into programming code

–maintain and update applications

35
Q

End users

A

The “clients” , DB is designed to serve their needs.

36
Q

Clients familiar with the structure of the database and the facilities offered by the DBMS are called

A

Sophisticated end users

37
Q

Uses who use existing applications(online library system, ATM…) to interact with the database are called

A

Naive users

38
Q

Roles in DB environment

A

DAdmin, DBAdmin, DB designers, App developers, End users

Database (4 decks)

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