[17.0] Databases

An organized collection of data, generally stored and accessed electronically from a computer system.

This database follows the progression of data being categorized in ranks or levels, wherein data is categorized based on a common linkage.

• hierarchical database

• network database

• object-oriented database

• relational database

• NoSQL database

A hierarchical database but the child records are given the freedom to associate with multiple parent records.

• hierarchical database

• network database

• object-oriented database

• relational database

• NoSQL database

Answer explanation

Think of how LSCS houses multiple CCS students of different courses, with some being officers and membrrs.

"define a class and define the objects associated with the class"

This database is one in which data is represented as objects and classes. These are a type of relational database.

• hierarchical database

• network database

• object-oriented database

• relational database

• NoSQL database

"Is student related to this subject? I want to know if this student is enrolled under CCPROG1."

In this database, every piece of information has a relationship with every other piece of information. Each data has a unique identity in the form of a record (ex. student ID number)

• hierarchical database

• network database

• object-oriented database

• relational database

• NoSQL database

This is a non-relational database designed to store unstructured or semi-structured data, organized using unique identifiers like a Facebook account ID, allowing all associated data to be stored under one key. It is schema-less and can efficiently handle large, diverse datasets without requiring relationships, making it ideal for flexible and scalable applications like login systems across multiple platforms.

• hierarchical database

• network database

• object-oriented database

• relational database

• NoSQL database

NoSQL is compatible for an enrollment system.

• TRUE

• FALSE

Answer explanation

NoSQL databases are not ideal for enrollment systems because they lack built-in mechanisms to enforce data integrity and handle duplicates effectively.

this is the actual information being stored

• data

• database schema

• query processor

• indexes

The structure of the database, including tables, fields, and relationships.

• data

• database schema

• query processor

• indexes

Interprets and executes database queries.

• data

• database schema

• query processor

• indexes