1. What is the primary goal of database design?
Explanation: The primary goal of database design is to organize data in a way that allows for efficient storage and retrieval while minimizing redundancy.
Report for correction2. Which term refers to a graphical representation of the structure of a database?
Explanation: An Entity-Relationship Diagram (ERD) , is a graphical representation of the structure of a database, showing entities, their attributes, and relationships.
Report for correction3. In a relational database, what is a "foreign key"?
Explanation: In a relational database, a foreign key is a key that links two tables together by establishing a relationship between them.
Report for correction4. Which type of relationship exists between two tables when one record in Table A can be related to multiple records in Table B, but each record in Table B is related to only one record in Table A?
Explanation: In a one-to-many (1:N) relationship, one record in Table A can be related to multiple records in Table B, but each record in Table B is related to only one record in Table A.
Report for correction5. What is the purpose of normalization in database design?
Explanation: The purpose of normalization in database design is to improve data integrity by minimizing data redundancy and organizing data efficiently.
Report for correction6. In the context of database design, what does "ACID" stand for?
Explanation: In the context of database design, "ACID" stands for Atomicity, Consistency, Isolation, and Durability, which are properties that ensure data reliability and integrity.
Report for correction Atomicity, Consistency, Isolation, Durability
Association, Composition, Inheritance, Dependency
Attribute, Constraint, Index, Data type
Aggregation, Cardinality, Integrity, Dependency
7. What is the primary purpose of a database index?
Explanation: The primary purpose of a database index is to speed up data retrieval by providing a quick lookup mechanism.
Report for correction8. Which database model represents data as entities, attributes, and relationships between entities?
Explanation: The relational model represents data as entities, attributes, and relationships between entities, making it one of the most widely used database models.
Report for correction9. In a relational database, what is a "primary key"?
Explanation: In a relational database, a primary key is a unique key that identifies each record in a table.
Report for correction10. What is the purpose of a "data dictionary" in database design?
Explanation: A data dictionary in database design is used to document the structure and attributes of data, providing a reference for database administrators and developers.
Report for correction11. In a database schema, what does a "table" represent?
Explanation: In a database schema, a "table" represents a collection of records, each of which contains related data.
Report for correction12. What is the purpose of referential integrity in database design?
Explanation: The purpose of referential integrity in database design is to enforce data constraints, ensuring that relationships between tables are maintained.
Report for correction13. Which database design concept involves breaking down data into its smallest meaningful parts?
Explanation: Normalization in database design involves breaking down data into its smallest meaningful parts to minimize redundancy and improve data integrity.
Report for correction14. In a database, what is an "attribute"?
Explanation: In a database, an "attribute" is a column that represents a property or characteristic of an entity.
Report for correction15. What is the primary purpose of denormalization in database design?
Explanation: The primary purpose of denormalization in database design is to optimize data retrieval by reducing the need for complex joins and improving query performance.
Report for correction16. What is a "composite key" in a database?
Explanation: A composite key in a database is a key composed of multiple columns, used to uniquely identify records when a single column is insufficient.
Report for correction17. What does the term "cardinality" refer to in the context of database relationships?
Explanation: In the context of database relationships, "cardinality" refers to the number of instances (records) in the relationship between entities.
Report for correction18. Which database design concept involves combining multiple tables into a single table to simplify data retrieval?
Explanation: Denormalization involves combining multiple tables into a single table to simplify data retrieval and improve query performance.
Report for correction19. What is the primary purpose of a "unique constraint" in a database?
Explanation: The primary purpose of a "unique constraint" in a database is to enforce the uniqueness of values in a column, preventing duplicate entries.
Report for correction20. In a database, what is a "relationship"?
Explanation: In a database, a "relationship" is a connection or association between two tables, often established through keys.
Report for correction21. Which database design concept focuses on grouping data into related entities and defining their attributes?
Explanation: Data modeling focuses on grouping data into related entities and defining their attributes and relationships.
Report for correction22. What is the primary goal of data decomposition in database design?
Explanation: The primary goal of data decomposition in database design is to improve data integrity by breaking down data into smaller, more meaningful parts.
Report for correction23. Which term refers to a database object that enforces data constraints, such as ensuring that values in a column meet specific criteria?
Explanation: In database design, a "constraint" is a database object that enforces data constraints, such as ensuring that values in a column meet specific criteria.
Report for correction24. In a database, what is an "entity"?
Explanation: In a database, an "entity" represents a real-world object or concept that is stored and managed in the database.
Report for correction25. What is the primary purpose of a "foreign key constraint" in a database?
Explanation: The primary purpose of a "foreign key constraint" in a database is to enforce data constraints and maintain referential integrity between related tables.
Report for correction