SWERS|GRADED A+|PASS ON FIRST ATTEMPT|BRAND NEW
Data - ANSWER numeric , textual , visual or audio information that describes real-world
systems.
varies in ways such as scope, format, access.
analog data - ANSWER Historically most common before computers, encoded as contin-
uous variations on various physical media.
digital data - ANSWER most common today, recorded as 0's and 1's on electronic and
magnetic media.
database designer - ANSWER determines the format of each data element and the over-
all database structure
database user - ANSWER a consumer of data in a database. can either use an application
or submit queries directly to the database. they use, request and update data. to generate
reports
transaction - ANSWER a group of queries that must be completed or rejected as whole.
will result in incomplete or incorrect data if not terminated as a whole.
Query processor - ANSWER interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
Query optimization - ANSWER to ensure the most efficient instructions are executed on
the data from the processor.
1
,Storage Manager - ANSWER translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
indexes - ANSWER used by the storage manager to quickly locate data
catalog - ANSWER also called a data dictionary , a directory of tables, columns and in-
dexes as well as other database objects.
relational database - ANSWER a database that stores data in tables that consist of rows
and columns, similar to a spreadsheet
SQL - ANSWER Structured Query Language
NoSQL - ANSWER A new generation of database management systems that is not based
on the traditional relational database model.
query - ANSWER command for a database that typically inserts, retrieves, updates and
deletes data from the database.
crud - ANSWER Create, Read, Update, Delete
statement - ANSWER a database command such as a query that inserts , selects updates
and deletes data
SELECT - ANSWER Retrieves data from a table
UPDATE - ANSWER modifies data in a table
2
, data type - ANSWER indicates the type of data that can be stored in a field of a column
data independence - ANSWER A condition in which data access is unaffected by changes
in the physical data storage characteristics.
database model - ANSWER Describes the relationship between the data elements and
provides a framework for organizing the data. contains 3 parts
data structures
operations
rules
relational model - ANSWER A database model that describes data in which all data ele-
ments are placed in two-dimensional tables, called relations, which are the logical equiva-
lent of files.
row - ANSWER an unnamed tuple of values , each value corresponds to a column and
belongs to the columns data type.
relational rules - ANSWER part of the relational model and govern data in every rela-
tional database
data lake - ANSWER An analytic database of raw, unprocessed data copied from multiple
data sources.
in-memory database - ANSWER A database management system that stores the entire
database in random access memory (RAM).
replica - ANSWER a cop of an entire database
3
Data - ANSWER numeric , textual , visual or audio information that describes real-world
systems.
varies in ways such as scope, format, access.
analog data - ANSWER Historically most common before computers, encoded as contin-
uous variations on various physical media.
digital data - ANSWER most common today, recorded as 0's and 1's on electronic and
magnetic media.
database designer - ANSWER determines the format of each data element and the over-
all database structure
database user - ANSWER a consumer of data in a database. can either use an application
or submit queries directly to the database. they use, request and update data. to generate
reports
transaction - ANSWER a group of queries that must be completed or rejected as whole.
will result in incomplete or incorrect data if not terminated as a whole.
Query processor - ANSWER interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
Query optimization - ANSWER to ensure the most efficient instructions are executed on
the data from the processor.
1
,Storage Manager - ANSWER translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
indexes - ANSWER used by the storage manager to quickly locate data
catalog - ANSWER also called a data dictionary , a directory of tables, columns and in-
dexes as well as other database objects.
relational database - ANSWER a database that stores data in tables that consist of rows
and columns, similar to a spreadsheet
SQL - ANSWER Structured Query Language
NoSQL - ANSWER A new generation of database management systems that is not based
on the traditional relational database model.
query - ANSWER command for a database that typically inserts, retrieves, updates and
deletes data from the database.
crud - ANSWER Create, Read, Update, Delete
statement - ANSWER a database command such as a query that inserts , selects updates
and deletes data
SELECT - ANSWER Retrieves data from a table
UPDATE - ANSWER modifies data in a table
2
, data type - ANSWER indicates the type of data that can be stored in a field of a column
data independence - ANSWER A condition in which data access is unaffected by changes
in the physical data storage characteristics.
database model - ANSWER Describes the relationship between the data elements and
provides a framework for organizing the data. contains 3 parts
data structures
operations
rules
relational model - ANSWER A database model that describes data in which all data ele-
ments are placed in two-dimensional tables, called relations, which are the logical equiva-
lent of files.
row - ANSWER an unnamed tuple of values , each value corresponds to a column and
belongs to the columns data type.
relational rules - ANSWER part of the relational model and govern data in every rela-
tional database
data lake - ANSWER An analytic database of raw, unprocessed data copied from multiple
data sources.
in-memory database - ANSWER A database management system that stores the entire
database in random access memory (RAM).
replica - ANSWER a cop of an entire database
3
