Brainscape's Knowledge GenomeTM

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


See full index

CCINFOM > Database Environment > Flashcards

Database Environment Flashcards

1
Q

It is a software system that is used to create, maintain, and provide controlled access to user database

A

Data Management System

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

Name the 6 functions of the DBMS

A
  1. Maintains the database
  2. Ensures what we store are persistently stored in the database
  3. Data manipulation
  4. Sharing of data to different users
  5. Enforces rules to avoid data duplication and inconsistency
  6. Security for data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Name the 3 cons of using DBSM

A
  1. Expensive
  2. Requires frequent update and maintenance
  3. Requires a database administrator (DBA) to maintain DB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a Database Environment

A

shows the components that affect data management and the database itself

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

What are the components of a Database Environment?

A
  1. Hardware
  2. Software
  3. Data
  4. People
  5. Procedure
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

This database component involves the use of physical devices in data management

A

Hardware

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

This database component uses an operating system in which the DBMS and database will be working with

A

Software

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

This database component describes the clients and technical users of the database system

A

People

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

Give 2 meanings of procedure

A
  1. Set of task, functions, processes of clients that will affect data management
  2. Set of task, functions, processes of technical users to ensure that the database system is what the client needs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Who are the people in the Database Environment?

A
  1. Non technical users
  2. Technical users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Who are the non technical users?

A

Clients or end users

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

Who are the technical users?

A
  1. Database administrator
  2. System administrator
  3. Database architect/designer
  4. System analyst
  5. Application developer
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Define the categories that the technical users are divided in:

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

Who belongs to the development team?

A
  1. System analyst
  2. Database architects/designers
  3. Application developer
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Who belongs to the deployment team?

A
  1. Database administrator
  2. System administrator
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

This person identifies the requirements that will be the basis of a database system

A

System Analyst

17
Q

This person designs the database

A

Database architect/ designers

18
Q

This person programs the application to its intended use and functionality

A

Application Developer

19
Q

This person manages the DBSM and the database

A

Database Administrator

20
Q

This person manages the database system and other infrastructure where the database system is deployed on

A

System Administrator

21
Q

This person uses SQL DDL SELECT to generate reports

A

Database Operator

22
Q

This person uses SQL DDL to enable applications to interact with database

This person alsu uses advanced structures in DB to enhance data management capabilities, make queries run
faster, and implement rules followed by the DB

A

Database Developer

23
Q

This person uses advanced structures and methods in DB
to implement ETL to populate Analytics DB

A

Data engineer

24
Q

What are the 3 levels of the Three Schema Architecture

A
  1. External View
  2. Conceptual View
  3. Internal View
25
Q

What is the goal of the Three Schema Architecture?

A

To separate the user applications and the physical database

26
Q

This level describes the physical storage structure of the database

A

Internal

27
Q

This level hides the details of the physical storage structure and concentrates on describing entities, data types, etc

A

Conceptual

28
Q

This level describes the part of the database that the user is interested in and hides the rest of the database from the group

A

External

29
Q

What are the top database server products in the market

A
  1. Oracle DB
  2. MySql DB
  3. IBM DB/2
30
Q

When we interact with the database, do we see the physical representation of the data storage? If yes or no, why?

A

No because we only see the logical representation of storage. Such as for relational databases, we only see tables

31
Q

Do all the components of the database system need to be in one computer machine?

A

No the database server can be on a different machine

32
Q

Are there other logical representations of data storage? Give examples

A

Yes

Tables are found in relational databases
Objects are found in Object Database
Trees are found in Network Database
Documents are found in Document Databases

CCINFOM (3 decks)

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