LOG321 CHAPTER 4 Quiz

What is data modeling and why is it important in database design?

• Data modeling is the process of creating a visual representation of the data and its relationships within a database. It is important in database design because it helps to ensure that the database is poorly structured and inefficient.

• Data modeling is the process of creating a visual representation of the data and its relationships within a database. It is important in database design because it has no impact on the needs of the users and the organization.

• Data modeling is the process of creating a visual representation of the data and its relationships within a database. It is important in database design because it helps to ensure that the database is well-structured, efficient, and meets the needs of the users and the organization.

• Data modeling is the process of creating a visual representation of the data and its relationships within a database. It is important in database design because it makes the database less efficient and harder to use.

Explain the process of normalization and its importance in database design.

• Normalization does not affect data integrity

• Normalization is not important in database design

• Normalization increases data redundancy

• Normalization is important in database design as it helps in minimizing data redundancy, improves data integrity, and reduces the chances of anomalies during data manipulation.

Draw an Entity-Relationship Diagram for a university database that includes entities such as students, courses, and professors.

• Create a flowchart for the university database

• Write a paragraph describing the university database

• Use a pie chart to represent the university database entities

• Identify the entities and their relationships, then use standard symbols and notation to represent them in the diagram.

Explain the role of Relational Database Management Systems in modern data management.

• RDBMS are not capable of efficient data retrieval

• RDBMS provide a structured way to store, manage, and retrieve data, ensuring data integrity, security, and scalability, and allowing for efficient querying and analysis of large datasets.

• RDBMS do not provide any security measures for data

• RDBMS are only useful for small datasets

What are the different types of SQL queries and provide an example of each?

• SELECT, INSERT, UPDATE, DELETE, and CREATE

• COPY, PASTE, CUT, PRINT

• SEARCH, SORT, FILTER, JOIN

• ADD, REMOVE, MODIFY, DROP

How does normalization help in reducing data redundancy and improving data integrity?

• By duplicating data in multiple tables

• By removing all relationships between tables

• By storing all data in a single unorganized table

• By organizing data into multiple related tables and enforcing relationships between them.

What are the key components of an Entity-Relationship Diagram and how are they used in database design?

• Entities, attributes, and relationships

• Data types, functions, and procedures

• Queries, forms, and reports

• Tables, columns, and indexes

Discuss the advantages and disadvantages of using Relational Database Management Systems.

• Advantages: Scalability, flexibility, and low cost. Disadvantages: No data integrity, performance issues, and inflexibility.

• Advantages: Data integrity, flexibility, and scalability. Disadvantages: Performance issues with complex queries and high cost.

• Advantages: High performance, low cost, and limited flexibility. Disadvantages: Data integrity issues and lack of scalability.

• Advantages: Limited data integrity, inflexibility, and lack of scalability. Disadvantages: No performance issues and low cost.

Write a SQL query to retrieve the names of all students who have scored above 90 in a particular course.

• SELECT name FROM students WHERE course_score > 90;

• SELECT name FROM students WHERE course_score < 90;

• SELECT name FROM students WHERE course_score >= 90 AND course_score <= 100;

• SELECT name FROM students WHERE course_score = 90;

Explain the concept of foreign keys in SQL and how they are used to establish relationships between tables.

• Foreign keys are used to establish relationships between tables by linking the primary key of one table to a cell in another table.

• Foreign keys are used to establish relationships between tables by linking the primary key of one table to a row in another table.

• Foreign keys are used to establish relationships between tables by linking the primary key of one table to a column in another table.

• Foreign keys are used to establish relationships between tables by linking the secondary key of one table to a column in another table.