Key Concepts - Week Five

Question 1

Database:

Answer 1

Group of related files

Question 2

File:

Answer 2

Group of records of the same type

Question 3

Record:

Answer 3

Group of related fields

Question 4

Field:

Answer 4

Group of characters as words or numbers

Question 5

Key field:

Answer 5

Identifier field used to retrieve, update, sort a record

Question 6

Database Management Systems (DBMS):

Answer 6

– Separates logical and physical views of data
– A software that helps you store, manage, and organize data in a structured way

Question 7

Relational DBMS:

Answer 7

• Stores data in tables
• Represent data as two-dimensional tables
• Each table contains data on entities and attributes

Question 8

Table:

Answer 8

Grid of columns and rows

Question 9

Rows (tuples):

Answer 9

Records for different entities

Question 10

Fields (columns):

Answer 10

Represent attributes for an entity

Question 11

Primary key:

Answer 11

Field in a table used for key fields

Question 12

Foreign key:

Answer 12

Primary key used in the second table as look-up fields to identify records from the original table

Question 13

_______, ______, ______ are Structured Query Language (SQL) programming statements

Answer 13

SELECT, JOIN, PROJECT

Question 14

Blockchain:

Answer 14

A type of digital ledger technology that records transactions in a secure, transparent, and decentralized way

Question 15

Big data:

Answer 15

Massive sets of unstructured/semi-structured data from web traffic, social media, sensors, and so on

Question 16

Data warehouse:

Answer 16

Stores current and historical data from many core operational transaction systems

Question 17

Hadoop:

Answer 17

Enables distributed parallel processing of big data across inexpensive computers

Question 18

Data Mining:

Answer 18

Finds hidden patterns, relationships in datasets