People Who Deal with Databases: Operation & maintenance of the database.

(a)  

Core Components of DBMS System Structure: The individuals who interact with the DBMS.

(a)  

Type of Attribute that cannot be divided further. Basic property of an entity.

(a)  

Core Components of an ER Model: A real-world object or thing about which data is stored.

(a)  

Core Components of DBMS System Structure: A standard language used to communicate with the database to perform operations on the data.

(a)  

People Who Deal with Databases: Designs how data is stored.

(a)  

Type of Attribute that can be broken down into smaller parts.

(a)  

People Who Deal with Databases: Advanced analytics and modeling.

(a)  

Core Components of DBMS System Structure: The most obvious part—the actual DBMS program itself.

(a)  

Type of Attribute that can have more than one value for a single entity.

(a)  

Core Components of DBMS System Structure: The most important component—the raw facts and information stored in the database.

(a)  

People Who Deal with Databases: Using the data through an interface.

(a)  

Created the Entity–Relationship Model.

(a)  

People Who Deal with Databases: Gets insights from data.

(a)  

Core Components of an ER Model: A collection of similar entities.

(a)  

Core Components of DBMS System Structure: A blueprint or a map for how data is connected, stored, and accessed within a database.

(a)  

Core Components of DBMS System Structure: Instructions and rules for using DBMS effectively.

(a)  

People Who Deal with Databases: Creates software that uses the database.

(a)  

It’s a conceptual data model used to visually describe how data is stored and related in a database.

(a)  

People Who Deal with Databases: Maintains the server and infrastructure where DB runs.

(a)  

People Who Deal with Databases: Oversees legal & security compliance.

(a)  

Core Components of an ER Model: A property or characteristic of an entity.

(a)  

Type of Entity Set that has its own key attribute (can stand alone).

(a)  

An attribute from another entity used to link tables.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
A server stores the company’s database and needs regular maintenance.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.

Maria runs SQL queries to extract customer purchase history.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.

MySQL and Oracle are examples of this, used to manage databases.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.

The customer names, phone numbers, and orders stored in the system.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.

The CPU performs query execution and ensures fast retrieval of records.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
A database designer draws an ER Diagram to show entities and relationships.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
Employees input student grades and attendance records into the school system.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
PostgreSQL is installed to manage data for a web application.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
The physical hard drives and memory used to store the company database.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
An accountant retrieves monthly financial reports from the system.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
Commands like SELECT, INSERT, and UPDATE are examples of this.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
A data scientist designs a star schema to organize sales data for analytics.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
The actual sales transactions stored in the inventory database.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
The SQL engine translates user queries into actions performed on the data.

(a)  

IDENTIFY THE DBMS COMPONENT DESCRIBED IN EACH SCENARIO.
A university hires a Database Administrator (DBA) to oversee security and backups.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Juan creates ER diagrams to define tables and relationships before the database is built.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Carla manages backups, security, and ensures the database runs smoothly without downtime.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Leo writes SQL queries and APIs to connect the company’s app with the database.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Anna runs daily queries to generate sales reports for her manager.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
A cashier inputs customer purchases into the Point-of-Sale (POS) system.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Paolo uses machine learning models to predict customer churn from big datasets.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Marco monitors the server hardware and ensures the database server is always online.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Sofia reviews database access logs to check compliance with data privacy laws.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Maria tunes SQL performance and creates indexes to speed up queries.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
A librarian uses the system to enter new books and update borrower records.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Sasha checks if the database complies with government regulations like GDPR.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
A teacher queries the student system to view class lists and upload grades.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Mark designs the schema for a hospital database, including patient and doctor entities.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
James writes stored procedures and updates code so the system can handle online payments.

(a)  

IDENTIFY THE CORRECT ROLE OF THE PERSON DESCRIBED FROM THE GROUP OF PEOPLE WHO DEAL WITH DATABASES.
Mia cleans and prepares raw data, then creates a predictive model for sales forecasting.

(a)  

Identify and write the correct name for this shape based on its role in the ER diagram.

(a)  

Identify and write the correct name for this shape based on its role in the ER diagram.

(a)  

Identify and write the correct name for this shape based on its role in the ER diagram.

(a)  

Identify and write the correct name for this shape based on its role in the ER diagram.

(a)  

Identify and write the correct name for this shape based on its role in the ER diagram.

(a)