1.1 Database Basics

studied byStudied by 0 people
0.0(0)
learn
LearnA personalized and smart learning plan
exam
Practice TestTake a test on your terms and definitions
spaced repetition
Spaced RepetitionScientifically backed study method
heart puzzle
Matching GameHow quick can you match all your cards?
flashcards
FlashcardsStudy terms and definitions

1 / 10

encourage image

There's no tags or description

Looks like no one added any tags here yet for you.

11 Terms

1


Data

Is numeric, textual, visual, or audio information that describes real-world systems.

New cards
2

Analog

Historically, data was mostly _____, encoded as continuous variations on various physical media. Examples include vinyl records, magnetic tapes, and film.

New cards
3

Digital

Today, data is mostly ____, encoded as zeros and ones on electronic and magnetic media.

New cards
4

Database


Is a collection of data in a structured format. In principle, ____ can be stored on paper or even clay tablets. In practice, however, modern ____ are invariably stored on computers.

New cards
5

DBMS

Is software that reads and writes data in a database. Database systems ensure data is secure, internally consistent, and available at all times. These functions are challenging for large databases with many users, so database systems are complex.

New cards
6

Query Language


A ____ is a specialized programming language, designed specifically for database systems.

New cards
7

Database Application

A ____ is software that helps business users interact with database systems.

New cards
8

Database Administrator

A ____ is responsible for securing the database system against unauthorized users. A ____ enforces procedures for user access and database system availability.

New cards
9

Database Designer

A ____ determines the format of each data element and the overall database structure. ____ must balance several priorities, including storage, response time, and support for rules that govern the data. Since these priorities often conflict, ____ is technically challenging.

New cards
10

Database Programmer

A ____ develops computer programs that utilize a database.

New cards
11

Database User

A ____ is a consumer of data in a database. ____ request, update, or use stored data to generate reports or information. ____ usually access the database via applications but can also submit queries directly to the database system.

New cards
robot