Database Lesson 3

What is relational database design?

• Storing data in a spreadsheet

• The process of organizing data to create a well-structured database.

• The process of organizing files in a computer

• Creating a disorganized database

What are the key components of a relational database?

• Graphs, nodes, edges, and vertices

• Files, folders, documents, and records

• Variables, functions, loops, and conditions

• Tables, columns, rows, keys, and relationships

Explain the concept of normalization in relational database design.

• Normalization is the process of organizing data to minimize redundancy and dependency.

• Normalization is the process of increasing dependency between data.

• Normalization is the process of adding redundancy to data for better organization.

• Normalization is the process of randomly organizing data without any specific rules.

What is the purpose of SQL queries?

• To retrieve, manipulate, and manage data in a database

• To write computer programs

• To design a user interface

• To create a new database

Differentiate between SELECT and INSERT queries in SQL.

• The SELECT query is used to create a new database, while the INSERT query is used to drop an existing database.

• The SELECT query is used to retrieve data from a database, while the INSERT query is used to add new records to a database.

• The SELECT query is used to add new records to a database, while the INSERT query is used to retrieve data from a database.

• The SELECT query is used to update existing records in a database, while the INSERT query is used to delete records from a database.

Explain the use of WHERE clause in SQL queries.

• It is used to join multiple tables together.

• It is used to perform mathematical calculations on the results.

• It is used to filter the results based on a specified condition.

• It is used to order the results alphabetically.

What is the significance of primary key in a database table?

• It allows for duplicate records in the table.

• It is used for sorting the records in the table.

• It has no significance in a database table.

• It ensures the uniqueness of each record in the table.

Discuss the concept of foreign key in relational database design.

• A foreign key is a field in a relational database table that is used to link two tables together.

• A foreign key is a field that is not related to any other table in the database

• A foreign key is a feature that allows users to access the database remotely

• A foreign key is a type of encryption used in database design

What are the different types of joins in SQL?

• INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• OUTER JOIN, CENTER JOIN, TOP JOIN, and BOTTOM JOIN

• FIRST JOIN, SECOND JOIN, THIRD JOIN, and FOURTH JOIN

• UPPER JOIN, LOWER JOIN, MIDDLE JOIN, and BOTTOM JOIN

Explain the use of GROUP BY and HAVING clauses in SQL queries.

• The GROUP BY clause is used to group the result set by one or more columns. The HAVING clause is used to filter the grouped results based on a specified condition.

• The GROUP BY clause is used to sort the result set in ascending order

• The GROUP BY clause is used to filter the result set based on a specified condition

• The HAVING clause is used to filter the result set before grouping