Chapter 11 Flashcards Preview

CSCI 1250 > Chapter 11 > Flashcards

Flashcards in Chapter 11 Deck (40)
Loading flashcards...
1

database

collection of data organized in a manner that allows access, retrieval, and use of that data

2

data

collection of unprocessed items (text, numbers, images, audio, video)

3

information

processed data

4

Database Management System (DBMS)

allows users to create a computerized database, add/modify/delete data, sort and retrieve data, and create forms/reports from the data

5

Data is organized in levels

hierarchy- each higher level of data consists of one or more items from the lower level (characters, field records, and files)

6

character

one byte

7

field

a combo of one or more related characters (given field size and data type)

8

data type

specifies the kind of data a field can contain and how the field is used

9

record

a group of related fields

10

data file

a collection of related records that's stored on a storage medium

11

primary key

a field that uniquely identifies each record

12

composite key

when the primary key is made up of multiple fields

13

file maintenance

the procedures that keep data current- adding, modifying, and deleting records

14

validation

compares data with a set of rules or values to find out if the data meets certain criteria

15

file processing system

each department has its own set of files, redundant data, and isolated data.

16

database approach

programs and users share data
reduced data redundancy
improved data integrity
shared data
easier access
reduced development time

17

back end

the DBMS

18

front end

a program that generally has a more user-friendly interface than the DBMS (webpage)

19

collaborative databases

where users store and share photos, videos, recordings, and other personal media

20

database server

stores and provides access to a database

21

data model

defines how users view the organization of thedata

22

3 types of data models are:

relational, object-oriented, and multidimensional

23

relational database

stores data in tables that consist of rows and columns

24

object-oriented database

stores data in objects

25

multidimensional database

stores data in dimensions

26

data dictionary aka repository

contains data about each file in the database and each field in those files

27

DBMS tools

query language, query by example, form, and report writer

28

query

a request for specific data from the database

29

query language

consists of simple, English-like statements that allows users to specify the data to display, print, store, update, or delete

30

Structured Query Language (SQL)

a popular query language that allows users to manage, update, and retrieve data