Quiz 1

Select all the options that describe the characteristics of a relational database - It stores large amounts of data - It is designed for efficiency and effectiveness - It is a system involving many components - It is a single software - It is designed using entities and relationships - It is designed to have data redundancy

- It stores large amounts of data - It is designed for efficiency and effectiveness - It is a system involving many components - It is designed using entities and relationships

When should you consider NOT using a database (select all that apply): - When there are large amounts of data to store. - When the application is too simple, well defined, and not expected to change much. - When access to data by multiple users is required. - If there are not enough hardware or/and software resources available, like in some embedded systems. - If access to data by multiple users is not required. - When the initial investment and overhead cost is within the budget limits.

- When the application is too simple, well defined, and not expected to change much. - If there are not enough hardware or/and software resources available, like in some embedded systems. - If access to data by multiple users is not required.

Some of the languages implemented by SQL include (select all that apply): Data Definition Language (DDL) Data Manipulation Language (DML) Views Definition Language (VDL) Data Control Language (DCL) Transaction Control Language (TCL) Storage Definition Language (SDL)

All of these

Data Definition Language (DDL) Data Manipulation Language (DML) Views Definition Language (VDL) Data Control Language (DCL) Transaction Control Language (TCL) Storage Definition Language (SDL) -Implements the conceptual schema of a database. -Used to specify database retrievals, insertions, deletions, and modifications. -Allows the creation of different perspectives of data for users. -Defines access control of a databases. -Controls commits and rollbacks -Allow us to map elements to disk and define ways to store data.

Data Definition Language (DDL) - Implements the conceptual schema of a database. Data Manipulation Language (DML) - Used to specify database retrievals, insertions, deletions, and modifications. Views Definition Language (VDL) - Allows the creation of different perspectives of data for users. Data Control Language (DCL) - Defines access control of a databases. Transaction Control Language (TCL) - Controls commits and rollbacks. Storage Definition Language (SDL) - Allow us to map elements to disk and define ways to store data.

Database schema Database state Conceptual Schema Internal Shema External Schema Match with associated concept: Physical, Intension, Logical Extension, Views

Database schema - Intension Database state - Extension Conceptual Schema - Logical Internal Shema - Physical External Schema - Views

Match each concept on the left with its associated concept on the right from the list of options shown in the drop down: Hierarchical Database Models Network Database Models Object Oriented Database Models NOSQL Database Models Relational Database Models - Use more semantics and are meant to accommodate OOP models. - Data is linked as collections of trees where many-to-many relationships are not possible. - Data is stored and linked as graphs where many-to-many relationships are possible. - Most widely used based on the concept of a schema with entities (tables) and relationships - Non-relational. Use less semantics, are dynamic, and meant for big data.

Hierarchical Database Models - Data is linked as collections of trees where many-to-many relationships are not possible. Network Database Models - Data is stored and linked as graphs where many-to-many relationships are possible. Object Oriented Database Models - Use more semantics and are meant to accommodate OOP models. NOSQL Database Models - Non-relational. Use less semantics, are dynamic, and meant for big data. Relational Database Models - Most widely used based on the concept of a schema with entities (tables) and relationships

Conceptual Data Models? ___ level and ___ semantics

High level and high semantics.

Some advantages of a relational DBMS include (select all that apply): Data dependence Inferences and actions from the stored data Data integrity Promoting data redundancy Security Efficient Access Data Administration Slow Application Development Concurrent Access

Inferences and actions from the stored data Data integrity Security Efficient Access Data Administration Concurrent Access

Implementation Data Models?

Intermediate model used by many database systems.

Physical Data Models? ___ level and ___

Low-level and internal.

Self-Describing Data Models?

Semi-structured or unstructured models

Match each step number from the database design process shown on the left with its associated description on the right from the list of options: Choose the appropriate DBMS Requirements Gathering Implement the database schema using the DBMS Language Map Conceptual model into an Implementation model Create Conceptual (high-level) model

Step 1 Requirements Gathering Step 2 Create Conceptual (high-level) model Step 3 Choose the appropriate DBMS Step 4 Map Conceptual model into an Implementation model Step 5 Implement the database schema using the DBMS Language