WGU D426 LESSON 1,2,3,4 AND 5 LATEST
2025 WITH COMPLETE SOLUTION
database application (Database Basics) - software that helps business users interact with
database systems.
Database Administrator (Database Basics) - Database Roles: A database administrator is
responsible for safeguarding the database system against unauthorized access and enforcing
procedures for user access and system availability.
database designer (Database Basics) - determines the format of each data element and the
overall database structure.
Authorization (Database Systems) - Many database users should have limited access to
specific tables, columns, or rows of a database. Database systems authorize individual users
to access specific data.
Rules (Database Systems) - Database systems ensure data is consistent with structural and
business rules.
Query Processor (Database Systems) - interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application
The query processor performs... (Database Systems) - query optimization to ensure the most
efficient instructions are executed on the data.
storage manager (Database Systems) - translates the query processor instructions into low-
level file system commands that modify or retrieve data.
indexes (Database Systems) - Database sizes range from megabytes to many terabytes, so
the storage manager uses indexes to quickly locate data.
,transaction manager (Database Systems) - 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 (Database Systems) - is data about the database, such as column names and the
number of rows in each table.
relational database - stores data in tables, columns, and rows, similar to a spreadsheet.
All relational database systems support the - SQL query language.
Relational systems are ideal for databases that require.... - an accurate record of every
transaction, such as banking, airline reservation systems, and student records.
What are the newer nonrelational systems called ? - NoSQL
INSERT (Query Languages) - Inserts rows into a table
SELECT (Query Languages) - Retrieves data from a table
UPDATE (Query Languages) - Modifies data in a table
DELETE (Query Languages) - deletes rows from a table
CREATE TABLE (Query Languages) - statement creates a new table by specifying the table
and column names.
Data Type (Query Languages) - Indicates the format column names. These can be numerical,
textual or complex.
INT (Query Languages) - Stores integer values
, DECIMAL (Query Languages) - Stores fractional numeric values
VARCHAR (Query Languages) - stores textual values
DATE (Query Languages) - Stores year, month, and day
Analysis (Database Design) - outlines database requirements, categorized into entities,
relationships, and attributes, without mentioning a specific database system.
Conceptual Design, Entity-Relationship modeling & Requirements definition are also known as
.... ? - The Analysis Phase
Rectangles represent... - entities
Logical (Database Design) - implements database requirements in a specific database
system. For relational database systems, logical design converts entities, relationships, and
attributes into tables, keys, and columns
Physical (Database Design) - adds indexes and specifies how tables are organized on storage
media.
data independence (Database Design) - The principle that physical design never affects
query results
MySQL Command-Line Client (MYSQL) - a text interface included in the MySQL Server
download.
error code (MYSQL) - when an SQL statement is syntactically incorrect or the database
cannot execute the statement.
2025 WITH COMPLETE SOLUTION
database application (Database Basics) - software that helps business users interact with
database systems.
Database Administrator (Database Basics) - Database Roles: A database administrator is
responsible for safeguarding the database system against unauthorized access and enforcing
procedures for user access and system availability.
database designer (Database Basics) - determines the format of each data element and the
overall database structure.
Authorization (Database Systems) - Many database users should have limited access to
specific tables, columns, or rows of a database. Database systems authorize individual users
to access specific data.
Rules (Database Systems) - Database systems ensure data is consistent with structural and
business rules.
Query Processor (Database Systems) - interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application
The query processor performs... (Database Systems) - query optimization to ensure the most
efficient instructions are executed on the data.
storage manager (Database Systems) - translates the query processor instructions into low-
level file system commands that modify or retrieve data.
indexes (Database Systems) - Database sizes range from megabytes to many terabytes, so
the storage manager uses indexes to quickly locate data.
,transaction manager (Database Systems) - 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 (Database Systems) - is data about the database, such as column names and the
number of rows in each table.
relational database - stores data in tables, columns, and rows, similar to a spreadsheet.
All relational database systems support the - SQL query language.
Relational systems are ideal for databases that require.... - an accurate record of every
transaction, such as banking, airline reservation systems, and student records.
What are the newer nonrelational systems called ? - NoSQL
INSERT (Query Languages) - Inserts rows into a table
SELECT (Query Languages) - Retrieves data from a table
UPDATE (Query Languages) - Modifies data in a table
DELETE (Query Languages) - deletes rows from a table
CREATE TABLE (Query Languages) - statement creates a new table by specifying the table
and column names.
Data Type (Query Languages) - Indicates the format column names. These can be numerical,
textual or complex.
INT (Query Languages) - Stores integer values
, DECIMAL (Query Languages) - Stores fractional numeric values
VARCHAR (Query Languages) - stores textual values
DATE (Query Languages) - Stores year, month, and day
Analysis (Database Design) - outlines database requirements, categorized into entities,
relationships, and attributes, without mentioning a specific database system.
Conceptual Design, Entity-Relationship modeling & Requirements definition are also known as
.... ? - The Analysis Phase
Rectangles represent... - entities
Logical (Database Design) - implements database requirements in a specific database
system. For relational database systems, logical design converts entities, relationships, and
attributes into tables, keys, and columns
Physical (Database Design) - adds indexes and specifies how tables are organized on storage
media.
data independence (Database Design) - The principle that physical design never affects
query results
MySQL Command-Line Client (MYSQL) - a text interface included in the MySQL Server
download.
error code (MYSQL) - when an SQL statement is syntactically incorrect or the database
cannot execute the statement.
