Introduction to DBMS Quiz

What is an entity-relationship model in DBMS?

• A type of computer hardware used for data storage

• A data model used to describe the data and the relationships between different entities in a database.

• A programming language used for database management

• A software application for creating spreadsheets

Explain the concept of cardinality in the entity-relationship model.

• Cardinality is the size of the entities in the model.

• Cardinality is the process of creating new entities in the model.

• Cardinality refers to the color of the entities in the model.

• Cardinality refers to the relationship between two entities and the number of instances of one entity that can be associated with the number of instances of another entity.

What are the key components of a relational database?

• Graphs, nodes, edges, and vertices

• Tables, columns, rows, keys, and relationships

• Variables, functions, loops, and conditions

• Files, folders, directories, and paths

Define normalization and its importance in relational database concepts.

• Normalization is important in relational database concepts to maximize data redundancy and decrease data integrity.

• Normalization is important in relational database concepts to minimize data redundancy and improve data integrity.

• Normalization is not important in relational database concepts as it does not affect data redundancy or data integrity.

• Normalization is important in relational database concepts to complicate data redundancy and hinder data integrity.

What is the process of creating a conceptual design in database design?

• Writing a computer program

• Identifying entities, attributes, and relationships

• Analyzing market trends

• Creating a physical model

What is a database and how is it different from a file processing system?

• A database is a collection of related data organized in a way that it can be easily accessed, managed, and updated. It is different from a file processing system in that it allows for better data organization, retrieval, and manipulation through the use of queries and relationships.

• A database is a collection of related data organized in a way that it can be easily accessed, managed, and updated. It is not different from a file processing system in terms of data organization, retrieval, and manipulation through the use of queries and relationships.

• A database is a collection of related data organized in a way that it can be difficult to access, manage, and update. It is different from a file processing system in that it allows for better data organization, retrieval, and manipulation through the use of queries and relationships.

• A database is a collection of unrelated data organized in a way that it can be easily accessed, managed, and updated. It is different from a file processing system in that it allows for worse data organization, retrieval, and manipulation through the use of queries and relationships.

Discuss the advantages of using a database over a file processing system.

• A database is less efficient and slower in processing data compared to a file processing system.

• A database is less secure and prone to data corruption compared to a file processing system.

• A database provides better data integrity, security, and concurrent access compared to a file processing system.

• A database is more difficult to use and requires more training compared to a file processing system.

What are the limitations of a file processing system?

• High level of security measures

• Lack of data redundancy, data inconsistency, difficulty in accessing data, and limited security measures

• Unlimited data redundancy and inconsistency

• Easy access to data

Explain the challenges of data redundancy and inconsistency in a file processing system.

• Decreased storage costs, data consistency, and ease in maintaining data integrity

• Increased storage costs, data inconsistency, and difficulty in maintaining data integrity

• Decreased storage costs, data inconsistency, and ease in maintaining data integrity

• No impact on storage costs, data consistency, and ease in maintaining data integrity

What is the purpose of a primary key in a relational database?

• To uniquely identify each record in a table and enforce entity integrity

• To store the most important data in a table and enforce referential integrity

• To provide a secondary level of security for the database

• To allow for easy sorting and filtering of data in a table