Introduction to DBMS Concepts

What is a database model?

• A database model is a type of software application.

• A database model is a framework for organizing and managing data in a database.

• A database model is a method for creating user interfaces.

• A database model is a programming language for data manipulation.

Name three types of database models.

• Hierarchical model

• Relational model, Document model, Key-value model

• Object-oriented model

• Graph model

What does SQL stand for?

• Standard Query Language

• Simple Query Language

• Structured Query Language

• Structured Query List

What is the purpose of SQL in a DBMS?

• The purpose of SQL in a DBMS is to manage and manipulate relational databases.

• To visualize data through graphical interfaces.

• To store data in a non-relational format.

• To create and design new databases.

Define primary key in a database.

• A primary key can contain duplicate values in a table.

• A primary key is used to store large amounts of data in a database.

• A primary key is a unique identifier for a record in a database table.

• A primary key is a type of foreign key in a database.

What is a foreign key?

• A foreign key is a type of primary key.

• A foreign key is a unique identifier for a single table.

• A foreign key is a field that stores images in a database.

• A foreign key is a field that links two tables in a relational database.

What does ERD stand for?

• Entity-Relationship Diagram

• Entity-Reference Diagram

• Entity-Relation Diagram

• Entity-Resource Diagram

What is the purpose of an ERD?

• To generate reports based on database queries.

• The purpose of an ERD is to illustrate the relationships and data structure within a database.

• To display the user interface of a database application.

• To store data in a physical format on disk.

List the main components of an ERD.

• Columns, Rows, Keys, Constraints

• Diagrams, Models, Schemas, Queries

• Tables, Views, Indexes, Triggers

• Entities, Attributes, Relationships, Cardinalities

What is the difference between a relational and a non-relational database?

• Relational databases are structured and use tables with relationships; non-relational databases are flexible and can store unstructured data.

• Relational databases are only for small datasets; non-relational databases are for large datasets.

• Relational databases are always faster than non-relational databases.

• Relational databases do not support transactions; non-relational databases do.