Info tech Flashcards

1
Q

Query

A

a message to the database requesting data from specific records and fields

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

Relational Database Model

A

consists of tables

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

Primary Key

A

uniquely identifies by each column

used to link tables

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

Entity Relationship Diagram

A

a graphical representation of all entity relationships

high level plan for databases

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

Logical or relational diagram

A

shows each relation as a table

  • see how databases are related to each other through these primary keys
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data dictionary

A

a repository of information about the data and their organization

  • consists of schema and metadata
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Schema

A

a plan that describes the structure of the databases, including

  • names and sizes of fields
  • id of primary keys
  • relationship
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Metadata

A

additional details about the data

  • source of the data
  • tables related to the data
  • field and index information
  • programs and processes that use the data
  • population rules: what is inserted, or updated, and how often
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

SQL (Sequeled query languages)

A

languages database management systems used to create, retrieve, and update data in a relational database

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

Attributes
- Object-oriented database model

A

characteristics of an object (id, size, start year, etc) stored as data

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

Object-oriented database model

A

uses an object-oriented approach for the database structure

  • store OBJECTS not records
  • consists of different OBJECTS that have ATTRIBUTES and METHODS
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Methods
- Object-oriented database model

A

Procedures an object can perform (grade, play, etc)

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

Data warehouse

A

a large repository database that supports management decision making

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

Data mart

A

a smaller collection of data focusing on a particular subject or department

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