Database Basics
Database Design & Programming
Query Languages
Database Roles
What does it stand for?
Database Systems
100
Numeric, textual or audio information that describes real-world systems
Data
100
The implementation of database requirements in SQL with CREATE TABLE statements.
schema
100
Indicates the format of column values
data type
100
Responsible for securing the database system against unauthorized users
database adminstrator
100
API
application programming interface
100
A group of queries that must be either completed or rejected as a whole
transaction
200
A collection of data in a structured format
Database
200
The phase that implements database requirements in a specific database system
logical design
200
The data type VARCHAR(16) is part of a statement. What does the value 16 represent?
sixteen characters,t the number of characters allowed
200
Determines the format of each data element and the overall database structure
database designer
200
DBMS
database management system
200
NoSQL is a database system optimized for
big data
300
A request to retrieve or change data in a database.
query
300
The principle that physical design never affects query results
data independence
300
The data type DECIMAL(8, 2) is part of a statement. What does the value (8, 2) represent?
eight significant digits, including two after the decimal point
300
Develops computer programs that utilize a database
database programmer
300
SQL
Structured Query Language
300
Translates the query processor instructions into low-level file-system commands that modify or retrieve data
storage manager
400
Specialized programming language, designed specifically for database systems
query language
400
This phase specifies database requirements without regard to a specific database system
conceptual design
400
This SQL statement creates a new table by specifying the table and column names
CREATE TABLE
400
A consumer of data in a database
database user
400
CRUD
create, read, update, and delete
400
When failing to process a transaction, the database system must
Ensure transactions are processed completely or not at all
500
Reads and writes data in a database, and ensures consistency and availability
database system, also known as a database management system
500
In the following ER diagram, what do 'Book', 'Writes', and 'Address' represent?
Book => Entity
Writes => Relationship
Address => Attribute
500
The four common queries that are sometimes referred to as CRUD operations
Insert, Select, Update, and Delete
500
True or False? For simple databases with a limited amount of data and few users, one person may assume several roles,
true
500
ER diagram
Entity Relationship
500
To avoid multiple transactions accessing the same data at the same time, the database system must
Prevent conflicts between concurrent transactions