Understanding Database Concepts

What is a DBMS and its primary function?

• A DBMS is a cloud service for file sharing.

• A DBMS is a type of hardware used for data storage.

• A DBMS is software that manages databases, allowing for data creation, retrieval, updating, and management.

• A DBMS is a programming language for data analysis.

Define the relational data model.

• A method for storing data in a single flat file without relationships.

• A framework for organizing data in a non-tabular format.

• The relational data model is a way to structure data using tables (relations) with rows and columns, where each table represents an entity and relationships are defined through foreign keys.

• A model that uses only hierarchical structures for data storage.

What are integrity rules in a database?

• Integrity rules are methods for data encryption.

• Integrity rules are guidelines for database design.

• Integrity rules are only applicable to user permissions.

• Integrity rules in a database are constraints that maintain data accuracy and consistency.

Explain the concept of data modeling.

• Data modeling is the process of deleting unnecessary data.

• Data modeling involves only data storage techniques.

• Data modeling is only about creating databases.

• Data modeling is the process of creating a conceptual representation of data structures and their relationships.

What is normalization and why is it important?

• Normalization is a process that only affects data storage, not performance.

• Normalization is important because it minimizes data redundancy, ensures data integrity, and enhances query performance.

• Normalization is only necessary for small databases.

• Normalization increases data redundancy and slows down queries.

List the different normal forms in database design.

• 1NF, 2NF, 3NF, 6NF

• 1NF, 2NF, 3NF, BCNF, 4NF, 5NF

• 1NF, 2NF, 3NF, 4NF, 5NF, 8NF

• 1NF, 2NF, 3NF, 4NF, 5NF, 7NF

What is a dependency diagram used for?

• To manage user permissions in a system.

• To visualize relationships and dependencies between components in a system.

• To create a timeline of project milestones.

• To track the performance of individual components.

Describe the process of de-normalization.

• De-normalization is the process of introducing redundancy into a database schema to improve read performance.

• De-normalization is the process of removing redundancy from a database schema.

• De-normalization is the process of optimizing a database for write performance.

• De-normalization is used to ensure data integrity in a database.

Provide an example of a dependency in a database.

• EmployeeID -> EmployeeName

• EmployeeName -> EmployeeID

• ProjectID -> EmployeeRole

• DepartmentID -> ProjectName

What is the significance of theoretical relational languages?

• They focus solely on graphical representations of data.

• They offer a formal framework for understanding data relationships and support the development of robust database systems.

• They simplify the process of data entry in databases.

• They eliminate the need for data normalization.