Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

DBMS > Vocab Quiz 1 > Flashcards

Vocab Quiz 1 Flashcards

(67 cards)

Start Studying
1
Q

Data

A

Known facts that can be recorded and have implicit meaning

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

Database

A

A collection of related data

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

Miniworld or UoD

A

Represents some aspect of the real world

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

Logically coherent

A

There is a rhyme and reason to why its there
* Random assortments of data is not a database
* Designed, built, and populated with data for a specific purpose

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

DMBS

A

A computerized system that enables users to create and maintain a database

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

Defining a database

A

Specifying types, structures, constrains of data to be stored within the database

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

Metadata

A

data about the data (definitions, dictionary, etc)

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

Constructing a DMBS

A

The process of storing the data on some storage medium that is controlled by the DBMS

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

Manipulating functions

A

Querying, updating, generating reports

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

Sharing

A

Allows access to database

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

Application program

A

Accesses the database by sending queries to the DBMS

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

Queries

A

Cause data to be retrieved

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

Transaction

A

May cause some data to be read and some data to be read into the database

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

System Protection

A

Protect against hardware or software malfunction

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

Security Protection

A

Against unauthorized or malicious access

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

Database System

A

The database and DBMS software together

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

Describe a Database

A
  • Elements, types, Information System
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Conceptual design

A

Entity Relationship model

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

Logical design

A

expressed in a data model

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

Physical Design

A

Storing and accessing DB recs - miniworld created

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

Database Approach

A

Define once and access repeatedly

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

DBMA catalog

A

Stores a complete definition or description of the database structure and contains - stores metadata

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

Data Abstraction

A

Allows for program data and operation independence - suppression of details between organization and storage

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

Program-data Independence

A

DB catalog separate from access programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Program-operation independence
application programs operate on the data by invoking these operations through name and arguments, regardless of how the operations are implemented
26
Data model
Type of data abstraction that provides a conceptual representation (no details of data storage and implementation)
27
Concurrency control software
Several users updating the database is correct
28
Online Transaction Processing applications
Airline agents booking tickets
29
Transaction
Executing program that includes one or more data base accesses - reading or updating records
30
Database Administrators
Authorize access, monitor its use, and acquire software and hardware resources as needed
31
Database Designers
Identify the data to be stored, choose appropriate structures to represent and store data
32
End Users
People whose jobs require access to the database for querying, updating, and generating reports
33
Casual End Users
Occasional users who may need something different everytime
34
Naive or Parametric End Users
Revolves around constant querying and updating a database, using standard queries
35
Canned Transactions
Bank customers and tellers check account balances and post withdrawals and deposits
36
Sophisticated End Users
Very familiar with the DBMS and have more complex requirements - engineers, scientists etc
37
Standalone End Users
Ready made program packages that provide ease of use menus or GUIs
38
System Analyst
Determine requirements for end users
39
Data Model
Collection of concepts that can be used to describe the structure of a database
40
Dynamic Aspect or behavior
Allows designer to specify valid user-defined operations
41
High-level Data Models (conceptual data models)
Close to the way many perceive data
42
Representational (implementation)
Easily understood by end users - use record structures
43
Low level (physical data models)
Concepts that describe the details of how data is stored on the computer storage media Represents info such as record formats, record orderings, and access paths
44
Entity
Represents a real-world object or concept
45
Attribute
Represents some property of interest that further describes an entity
46
Access Path
search structure that makes the search for particular database record efficient such as indexing or hashing
47
Index
Example of an access path that allows direct access to data using an index term or keyword
48
Self-describing models
- Combines a description of the data with the data values themselves - Models include XML, NOSQL systems
49
Schema
Description of Database - specified during db design and does not change frequently unless there is a schema evolution
50
Schema Diagram
displays structure of each record type
51
Database state, snapshot, occurrences, instances
The data in the database at a particular moment in time - extension of the schema
52
Internal level
Describes the physical storage structure of the database
53
Conceptual level
Describes the structure of the whole database of a community of users - Representational data model is usually used to describe the entities, data types, relationships, user operations and constraints
54
External or view level
Includes a number of external schemas or user views - describes the part of the database that a particular user group is interested in and hides the rest of the database from the user group
55
Data definition language
Used in DBMSs where no strict separation levels are maintained
56
Storage Definition Language
Used to specify the internal schema
57
View Definition Language
Used to specify views and their mappings to the conceptual schema
58
Data Manipulation language
Set of operations provided by the DBMS - users use this to manipulate the database
59
SQL
- combo of DDL, VDL, and DML
60
Database Interfaces
- Menu-based interfaces for web clients - Apps for mobile devices - Forms-based INterface - Graphical User Interfaces - Natural Language Interfaces - Keyword-based Database Search - Speech Input and Output - Interfaces for Parametric Users - Interfaces for the DBA
61
Database Systems Utilities
Database Utilities help the DBA manage the database system - Utilities have the following types of functions: - Loading - Backup - Database storage reorganization ( create new access paths and improve performance if needed) - Performance Monitoring - Usage and stats
62
Data dictionary system
Information repository
63
Application Development Environments
- Provide an environment for developing database applications and facilities that help in many areas of db systems (DB design, GUI development, querying/updating, etc)
64
Communication Facilities
Allow remote access to the database system site through computer terminals, workstations or personal computers
65
Centralized DBMS
All the DBMS functionality, application program execution, and user interface processing carried out on one machine (not feasible)
66
Client/Server Architecture
Developed to deal with computing environments in which a large number of PCs, workstations, file servers, printers, database servers, web servers, e-mail servers, and other software and equipment are connected via a network.
67
Specialized servers
file server, printer server, web server - all accessed by client machines

DBMS (2 decks)

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