DB2

Question 1

What is a Database?

Answer 1

A database is an organized collection of structured information, or data, typically stored electronically in a computer system

Question 2

What is a Database usually controlled by?

Answer 2

A DBMS

Question 3

What is a DBMS?

Answer 3

A DBMS serves as an interface between the database and its end users or programs, allowing users to retrieve, update, and manage how the information is organized and optimized

Question 4

Noem 7 DBMSystems

Answer 4

MySQL​

Microsoft Access​

Microsoft SQL Server​

Oracle Database​

Neo4J​

MangoDB​

PostgreSQL​

Question 5

What is a Database Software?

Answer 5

Database software is used to create, edit, and maintain database files and records, enabling easier file and record creation, data entry, data editing, updating, and reporting. The software also handles data storage, backup and reporting, multi-access control, and security.

Question 6

What are the 5 types of databases?

Answer 6

Relational dB, Object-oriented Db, Data Warehouses, NOSQL Db, Graph DB

Question 7

What is a RDBMS?

Answer 7

A relational database is a type of database that stores and provides access to data points that are related to one another.

Question 8

What are the benefits of RDBMS?

Answer 8

Data Consistency​

Commitment and atomicity​

Question 9

What are the ACID properties?

Answer 9

Atomicity defines all the elements that make up a complete database transaction.​

Consistency defines the rules for maintaining data points in a correct state after a transaction.​

Isolation keeps the effect of a transaction invisible to others until it is committed, to avoid confusion.​

Durability ensures that data changes become permanent once the transaction is committed.​

​

Question 10

What are Data Models?

Answer 10

Conceptual tools to describe data.​

Question 11

Entity

Answer 11

An entity can be a real-world object, that can be easily identifiable. For example, in a school database: students, teachers, classes, and courses offered can be considered as entities. ​

Question 12

Attributes

Answer 12

Things that describe the Entity. ( student name, age, birthday …) ​

Question 13

Relationship

Answer 13

The association among entities is called a relationship. For example, an employee works at a department, a student enrolls in a course. ​

Question 14

Cardinality

Answer 14

Defines the numerical attributes of the relationship between two entities or entity sets. The three main cardinal relationships are one-to-one, one-to-many, and many-many.

Question 15

ER-Diagram

Answer 15

An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system.

Question 16

What are ER-Diagrams used for?

Answer 16

ER Diagrams are most often used to design or debug relational databases in the fields of software engineering, business information systems, education and research.