prelims

Question 1

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

Answer 1

database

Question 2

provide the tools for
creating, querying, updating,
and administering the data

Answer 2

database management systems

Question 3

types of database technologies

Answer 3

-relational
-nosql
-newsql

Question 4

These
databases store data in tables and use Structured Query
Language (SQL) for data
manipulation.

Answer 4

relational databases

Question 5

designed for unstructured or semi structured data, nosql databases provide flexibility and scalability

Answer 5

nosql databases

Question 6

These
databases aim to provide the
scalability of NoSQL systems while
maintaining the ACID (Atomicity,
Consistency, Isolation, Durability)
properties of traditional relational
databases

Answer 6

newsql databases

Question 7

importance of database technologies

Answer 7

-data management
-data integrity
-scalability

Question 8

Efficiently
storing and
retrieving
data is crucial
for
applications
ranging from
e-commerce
to healthcare

Answer 8

data management

Question 9

Ensuring the
accuracy and
consistency
of data is vital
for decisionmaking and
operational
efficiency.

Answer 9

data integrity

Question 10

As data
volumes grow,
database
technologies
must scale to
accommodate
increased
loads without
sacrificing
performance.

Answer 10

scalability

Question 11

introduced by
Edgar F. Codd in the 1970s,
revolutionized the way data is
structured and accessed. It is based
on the concept of relations (tables)
and provides a clear and logical way
to organize data.

Answer 11

the realational model

Question 12

key concepts of relational model

Answer 12

-tables
-primary keys
-foreign keys
-normalization

Question 13

advantages of relational model

Answer 13

-data integrity
-flexibility
-ease of use

Question 14

The use of primary and foreign keys
helps maintain data integrity and consistency
across related tables.

Answer 14

data integrity

Question 15

The relational model allows for complex
queries using SQL, enabling users to retrieve and
manipulate data in various ways.

Answer 15

flexibility

Question 16

The tabular structure of the relational
model is intuitive and easy to understand, making
it accessible to users and developers

Answer 16

ease of use

Question 17

the standard language used to interact with relational databases. it provides commands for creating, reading, updating and deleting data

Answer 17

sql

Question 18

challenges and considerations(relational model)

Answer 18

-scalability
-complexity
-performance

Question 19

challenge of relational model based on scalability

Answer 19

-traditional relational databasses can struggle with horizontal scaling, especially when dealing with large volumes of unstructured data or high-velocity data streams

Question 20

challenge of relational model based on complexity

Answer 20

as the number of tables and relationships increases, managing the database schema can become complex, leading to potentila performance issues

Question 21

challenge of relational model based on performance

Answer 21

as the complexity of relationships and the volume of data increases, performance can become an issue necessitating careful optimization and indexing strategies