Please review attachments for instructions. Use the PDF book provided to answer the questions listed below. This is not an essay. Do

Please review attachments for instructions.

Use the PDF book provided to answer the questions listed below. This is not an essay. Do not answer the questions in an essay format. Keep the format the same and use the exact template below to answer the questions.


CH 5: The Relational Data Model and Relational Database Concepts: Complete the following 3 problems on page 173.


5.15 – Refer to the text on page 173


5.16 – Refer to the text on page 173


5.17 – Refer to the text on page 173


CH 6: Basic SQL

#6.10 – Specify the following queries on the COMPANY relational database schema shown in Figure 5.6 & 5.7, using the relational operators discussed in this chapter. Also show the result of each query as it would apply to the database state of Figure 3.6. Use SQL syntax. You do not have to create or load a database, only provide the SQL commands.
Show the SQL code for a, b, and c that would be used to retrieve the results.

a. Retrieve the names of employees in department 5 who work more than 10 hours per week on the ‘ProductX’ project.

b. List the names of employees who have a dependent with the same first name as themselves.

c. Find the names of employees that are directly supervised by ‘Franklin Wong’.


CH 7: More SQL: Complex Queries, Triggers, Views, and Schema Modification: Complete the Following Review Question

#7.4 – Discuss how each of the following constructs is used in SQL, and discuss the various options for each construct. Specify what each construct is useful for.

7.16

a. Nested queries

b. Joined Tables and outer joins

c. Aggregate functions and grouping

d. Triggers

e. Assertions and how they differ from Triggers

f. The SQL WITH clause

g. SQL Case Construct

h. Views and their updatability

i. Schema Change Commands

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Project 1: Develop Cloud Migration Plan  Step 1: Research Cloud Premigration Considerations  In this step, you will research premigration

Project 1: Develop Cloud Migration Plan  Step 1: Research Cloud Premigration Considerations  In this step, you will research premigration considerations, such as the analysis of the current workloads that are being served out of BallotOnline’s existing IT infrastructure, and how the  cloud migration plan will align with business objectives and BallotOnline’s updated