Domain 8: Databases Flashcards

1
Q

Controls all access to the database and enforces the database security

A

Database Management System (DBMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  • Allows for searching within a database

- i.e. Structured Query Language (SQL)

A

Query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  • Creates relationships between records in tables by using a primary key
  • Contains two-dimensional tables made up of rows and columns
A

Relational database

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

Another name for a table

A

Relation

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

Row in a database

A

Tuple

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

Database column

A

Attribute

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

Single cell in a database

A

Value

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

Contains the data in a database

A

Cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
  • Selected from the set of candidate keys inside a table
  • Used to uniquely identify the records in a table
  • Relational databases require unique value in each tuple in a table
A

Primary Key

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

Any attribute (column) in the table with unique values

A

Candidate Keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
  • Key in a relational database table that matches a primary key in a parent database table
  • Used to enforce relationships between two tables
A

Foreign Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q
  • Means that every foreign key in a secondary table matches a primary key in the parent table
  • If not this is not true, integrity has been broken
A

Referential Integrity

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

Means each attribute (column) value is consistent with the attribute data type

A

Semantic Integrity

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

Means each tuple has a unique primary key that is not null

A

Entity Integrity

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

- Purpose is to make data in a database table concise, organized and consistent

A

Database normalization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
  • Virtual tables you can query like a table
  • Doesn’t store data
  • Can combine data from two or more tables using joins
  • Can be used to implement multilevel security
A

Database View

17
Q

Allows the creation of database tables, read/write access to those tables, and many other functions

A

Database query languages

18
Q

What are the two subset of commands for Database query languages?

A
  1. Data definition language (DDL)

2. Data manipulation language (DML)

19
Q

Used to create, modify, an delete tables

A

Data definition language (DDL)

20
Q

Used to query and update data stored in the tables

A

Data manipulation language (DML)

21
Q
  • Combine data with functions (code) in an code-accessible framework
  • Data and functions form an object
  • Objects can then be accessed, read, and, written to by using code written in an _____ programming language
A

Object-oriented databases

22
Q
  • Log of all database transactions

- If database becomes corrupted, this can be used to restore the database

A

Database journal

23
Q
  • Allows simultaneous reads and writes to multiple replicated databases by clients
  • Provides a means of backing up an entire database or of creating high availability and redundancy
A

Database Replication

24
Q

Mirrors all database changes made to primary, but clients do not have access to this copy

A

Database Shadowing

25
Q
  • Combines records and fields that are related in a logical tree structure (one-to-many)
  • i.e. Organization chart, NCAA March Madness bracket system, DNS
A

Hierarchical database model