Database Fundamentals Quiz

Study Notes

A collection of organized data that is stored in a way that allows for efficient retrieval and manipulation.
A database is a self-describing collection of integrated, time-varying data.

Schema: The overall structure or organization of the database.
Instance: The actual data stored in the database at a particular point in time.

Relational Database: Organizes data into one or more tables with rows and columns, with each column representing a field or attribute.
NoSQL Database: A database that does not use the traditional table-based relational model, often used for big data and real-time web applications.
Object-Oriented Database: A database that stores data in the form of objects, which are instances of classes that represent real-world entities.
Cloud Database: A database that is built, deployed, and delivered through a cloud computing platform.

DBMS: A software system that allows you to create, define, maintain, and manipulate databases.
Functions of a DBMS:
- Data definition
- Data manipulation
- Data management
- Data security
- Data recovery

Entity-Relationship (ER) Model: A conceptual representation of data entities and their relationships.
ER Diagrams: Visual representations of the ER model, used to design and understand database structures.
Normalization: The process of organizing data to minimize data redundancy and improve data integrity.

CRUD Operations:
- Create: Inserting new data into the database.
- Read: Retrieving data from the database.
- Update: Modifying existing data in the database.
- Delete: Deleting data from the database.
Querying: The process of requesting specific data from the database using a query language (e.g., SQL).

Access Control: The process of controlling who can access the database and what actions they can perform.
Authentication: The process of verifying the identity of users or applications accessing the database.
Encryption: The process of protecting data in transit and at rest using encryption algorithms.

A database is a collection of organized data stored in a way that allows for efficient retrieval and manipulation.
A database is a self-describing collection of integrated, time-varying data.

Schema refers to the overall structure or organization of the database.
Instance refers to the actual data stored in the database at a particular point in time.

Relational databases organize data into tables with rows and columns, with each column representing a field or attribute.
NoSQL databases do not use the traditional table-based relational model and are often used for big data and real-time web applications.
Object-oriented databases store data in the form of objects, which are instances of classes that represent real-world entities.
Cloud databases are built, deployed, and delivered through a cloud computing platform.

A DBMS is a software system that allows you to create, define, maintain, and manipulate databases.
Functions of a DBMS include data definition, data manipulation, data management, data security, and data recovery.

The Entity-Relationship (ER) model is a conceptual representation of data entities and their relationships.
ER diagrams are visual representations of the ER model, used to design and understand database structures.
Normalization is the process of organizing data to minimize data redundancy and improve data integrity.

CRUD operations include creating new data, reading data, updating existing data, and deleting data.
Querying involves requesting specific data from the database using a query language (e.g., SQL).

Access control involves controlling who can access the database and what actions they can perform.
Authentication involves verifying the identity of users or applications accessing the database.
Encryption involves protecting data in transit and at rest using encryption algorithms.