Questions from Database Systems

Q: Write SQL DDL corresponding to the schema in Figure 3.17

Write SQL DDL corresponding to the schema in Figure 3.17. Make any reason- able assumptions about data types, and be sure to declare primary and foreign keys.

Q: Consider the insurance database of Figure 3.17, where the

Consider the insurance database of Figure 3.17, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the number of accidents involving a car...

Q: List five responsibilities of a database-management system. For each

List five responsibilities of a database-management system. For each response ability, explain the problems that would arise if the responsibility were not dis- charged.

Q: Consider the bank database of Figure 3.18, where the

Consider the bank database of Figure 3.18, where the primary keys are under- lined. Construct the following SQL queries for this relational database. a. Find each customer who has an account at every...

Q: What are two advantages of encrypting data stored in the database?

What are two advantages of encrypting data stored in the database?

Q: Consider the employee database of Figure 3.19, where the

Consider the employee database of Figure 3.19, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find ID and name of each employee who lives in the...

Q: Consider the employee database of Figure 3.19. Give an

Consider the employee database of Figure 3.19. Give an expression in SQL for each of the following queries. a. Give all employees of “First Bank Corporation” a 10 percent raise. b. Give all managers o...

Q: Give an SQL schema definition for the employee database of Figure 3

Give an SQL schema definition for the employee database of Figure 3.19. Choose an appropriate domain for each attribute and an appropriate primary key for each relation schema. Include any foreign-key...

Q: List two reasons why null values might be introduced into the database

List two reasons why null values might be introduced into the database.

Q: Consider the query / Explain why appending natural join section

Consider the query Explain why appending natural join section in the from clause would not change the result.