Introduction to Database Management Systems

What is a Database Management System (DBMS)?

• A Database Management System (DBMS) is software that manages databases, allowing for data creation, manipulation, and administration.

• A Database Management System (DBMS) is a type of hardware used for data storage.

• A Database Management System (DBMS) is a programming language for data analysis.

• A Database Management System (DBMS) is a cloud service for hosting websites.

Name one type of DBMS.

• NoSQL Database System

• Relational Database Management System (RDBMS)

• Object-Oriented Database Management System

• Hierarchical Database Management System

What is the primary purpose of a DBMS?

• The primary purpose of a DBMS is to manage and facilitate the storage, retrieval, and manipulation of data in databases.

• To ensure data is stored in physical files only.

• To provide a user interface for web development.

• To create and design new programming languages.

What does SQL stand for?

• Structured Query Language

• Standard Query Language

• Simple Query Language

• Structured Query List

What is a relational database?

• A relational database is a type of cloud storage service.

• A relational database is a collection of unstructured data.

• A relational database is a database that organizes data into tables with defined relationships between them.

• A relational database is a software application for word processing.

Define the term 'table' in the context of a database.

• A table is a single row of data in a database.

• A table is a type of database software.

• A table is a structured collection of data in rows and columns in a database.

• A table is a graphical representation of data without structure.

What is a primary key?

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

• A primary key is used to store images in a database.

• A primary key can have duplicate values.

• A primary key is a type of foreign key.

What is a foreign key?

• A foreign key is a type of database index.

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

• A foreign key is a field that links two tables by referencing the primary key of another table.

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

What is normalization in databases?

• Normalization in databases is the process of organizing data to minimize redundancy and dependency.

• Normalization is the method of encrypting data for security purposes.

• Normalization involves creating multiple copies of the same data for backup.

• Normalization is the process of deleting all data from a database.

What is the difference between a database and a spreadsheet?

• A database is primarily used for creating presentations, while a spreadsheet is for writing code.

• A database can only be used by one person at a time, while a spreadsheet can be shared by many.

• A database is for managing large datasets and complex queries, while a spreadsheet is for individual data analysis and simpler calculations.

• A database is only for storing text files, while a spreadsheet is for images.