Exploring Databases and Data Models

What is a Database Management System (DBMS)?

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

• A Database Management System (DBMS) is a cloud service for streaming media.

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

• A Database Management System (DBMS) is a programming language for creating websites.

Name three types of Database Management Systems.

• Hierarchical DBMS

• Relational DBMS, NoSQL DBMS, Object-oriented DBMS

• Network DBMS

• Flat-file DBMS

What is the primary purpose of a database?

• To visualize data in graphical formats.

• To ensure data is always encrypted and secure.

• To store, manage, and retrieve data efficiently.

• To create complex algorithms for data processing.

Define data modeling in the context of databases.

• Data modeling is the process of collecting user feedback for databases.

• Data modeling is the technique of encrypting data for security purposes.

• Data modeling is the process of defining data structures, relationships, and constraints for databases.

• Data modeling refers to the physical storage of data in a database.

What are the main components of a database?

• Network protocols

• User interface design

• Data encryption methods

• Database management system (DBMS), data models, schemas, tables, relationships.

Explain the difference between a relational and a non-relational database.

• Relational databases use tables and SQL, while non-relational databases use flexible formats and do not require a fixed schema.

• Relational databases do not support transactions.

• Relational databases are faster than non-relational databases.

• Non-relational databases only store data in JSON format.

What is a primary key in a database?

• 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.

• A primary key can have duplicate values in a database.

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

List the advantages of using a DBMS.

• Advantages of using a DBMS include data integrity, data security, reduced data redundancy, improved data access, and support for concurrent access.

• Limited data access

• Decreased data security

• Increased data redundancy

How does a data model help in database design?

• A data model helps in database design by defining data structures, relationships, and constraints, ensuring clarity and consistency.

• A data model is irrelevant to database performance.

• A data model only focuses on user interface design.

• A data model eliminates the need for data relationships.

What role does SQL play in database management?

• SQL is primarily used for graphic design in databases.

• SQL is a programming language for creating mobile applications.

• SQL is only used for data storage without any manipulation capabilities.

• SQL plays a crucial role in database management by enabling data manipulation, querying, and defining database structures.