Database Application - ANSWER Software that helps business users interact with data-
base systems.
Database Administrator - ANSWER The individual who is responsible for safeguarding
the database system against unauthorized access and enforcing procedures for user access
and system availability.
Database Designer - ANSWER Determines the format of each data element and the
overall database structure.
Authorization - ANSWER Many database users should have limited access to specific ta-
bles, columns, or rows of a database. Database systems use this to grant individual users ac-
cess to specific data.
Query Processor - ANSWER Interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application
Rules - ANSWER Database systems ensure data is consistent with structural and business
rules.
What does the query processor perform? - ANSWER Query optimization to ensure the
most efficient instructions are executed on the data.
Storage Manager - ANSWER Translates the query processor instructions into low-level
file system commands that modify or retrieve data.
1
,Indexes - ANSWER Database sizes range from megabytes to many terabytes, so the stor-
age manager uses indexes to quickly locate data.
Transaction Manager - ANSWER The transaction manager ensures efficient transaction
execution, prevents conflicts between concurrent transactions, and restores the database to
a consistent state in case of a transaction or system failure.
Metadata - ANSWER Is data about the database, such as column names and the number
of rows in each table.
Relational Database - ANSWER Stores data in tables, columns, and rows, similar to a
spreadsheet.
SQL Query Language - ANSWER All relational database systems support this.
Relational systems are ideal for databases that require.... - ANSWER An accurate record
of every transaction, such as banking, airline reservation systems, and student records.
NoSQL - ANSWER A nonrelational database.
INSERT - ANSWER Inserts rows into a table.
SELECT - ANSWER Retrieves data from a table.
UPDATE - ANSWER Modifies data in a table.
DELETE - ANSWER Deletes rows from a table.
2
, CREATE TABLE - ANSWER Statement creates a new table by specifying the table and col-
umn names.
Data Type - ANSWER Indicates the format column names. These can be numerical, tex-
tual or complex.
INT - ANSWER Stores integer values.
DECIMAL - ANSWER Stores fractional numeric values.
VARCHAR - ANSWER Stores textual values.
DATE - ANSWER Stores year, month, and day.
The Analysis Phase - ANSWER Specifies database requirements without regard to a spe-
cific database system. Requirements are represented as entities, relationships, and attrib-
utes.
Analysis - ANSWER Has many alternative names, conceptual design, entity-relationship
modeling, and requirements definition.
What shape represents an Entitiy? - ANSWER Rectangle
Logical Design Phase - ANSWER Implements database requirements in a specific data-
base system. For relational database systems, it converts entities, relationships, and attrib-
utes into tables, keys, and columns.
Physical Design Phase - ANSWER Adds indexes and specifies how tables are organized on
storage media with SQL statements such as CREATE INDEX and is specific to a database sys-
tem.
3
base systems.
Database Administrator - ANSWER The individual who is responsible for safeguarding
the database system against unauthorized access and enforcing procedures for user access
and system availability.
Database Designer - ANSWER Determines the format of each data element and the
overall database structure.
Authorization - ANSWER Many database users should have limited access to specific ta-
bles, columns, or rows of a database. Database systems use this to grant individual users ac-
cess to specific data.
Query Processor - ANSWER Interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application
Rules - ANSWER Database systems ensure data is consistent with structural and business
rules.
What does the query processor perform? - ANSWER Query optimization to ensure the
most efficient instructions are executed on the data.
Storage Manager - ANSWER Translates the query processor instructions into low-level
file system commands that modify or retrieve data.
1
,Indexes - ANSWER Database sizes range from megabytes to many terabytes, so the stor-
age manager uses indexes to quickly locate data.
Transaction Manager - ANSWER The transaction manager ensures efficient transaction
execution, prevents conflicts between concurrent transactions, and restores the database to
a consistent state in case of a transaction or system failure.
Metadata - ANSWER Is data about the database, such as column names and the number
of rows in each table.
Relational Database - ANSWER Stores data in tables, columns, and rows, similar to a
spreadsheet.
SQL Query Language - ANSWER All relational database systems support this.
Relational systems are ideal for databases that require.... - ANSWER An accurate record
of every transaction, such as banking, airline reservation systems, and student records.
NoSQL - ANSWER A nonrelational database.
INSERT - ANSWER Inserts rows into a table.
SELECT - ANSWER Retrieves data from a table.
UPDATE - ANSWER Modifies data in a table.
DELETE - ANSWER Deletes rows from a table.
2
, CREATE TABLE - ANSWER Statement creates a new table by specifying the table and col-
umn names.
Data Type - ANSWER Indicates the format column names. These can be numerical, tex-
tual or complex.
INT - ANSWER Stores integer values.
DECIMAL - ANSWER Stores fractional numeric values.
VARCHAR - ANSWER Stores textual values.
DATE - ANSWER Stores year, month, and day.
The Analysis Phase - ANSWER Specifies database requirements without regard to a spe-
cific database system. Requirements are represented as entities, relationships, and attrib-
utes.
Analysis - ANSWER Has many alternative names, conceptual design, entity-relationship
modeling, and requirements definition.
What shape represents an Entitiy? - ANSWER Rectangle
Logical Design Phase - ANSWER Implements database requirements in a specific data-
base system. For relational database systems, it converts entities, relationships, and attrib-
utes into tables, keys, and columns.
Physical Design Phase - ANSWER Adds indexes and specifies how tables are organized on
storage media with SQL statements such as CREATE INDEX and is specific to a database sys-
tem.
3
