SQL SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Question

Want to see the full answer?

Answer 1

Question

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Write the SQL code that permits to implement the tables: Student and Transcript. NB: Add the constraints on the attributes – keys and other.

Draw an ERD that will involve the entity types: Professor, Student, Department and Course. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.

Draw an ERD that represents a book in a library system. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.

Answer 2

Question

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Answer 6

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Answer 7

Chapter 9, Problem 15CRP

Program Plan Intro

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Answer 8

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Answer 9

Explanation of Solution

b. List of employees from personnel department who have worked or are working:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Answer 10

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Answer 11

Explanation of Solution

c. List of employees from personnel department:

NEW1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT.EmplId

NEW2 <- JOIN NEW1 and JOB where ASSIGNMENT.JobId = JOB.JobId

NEW3 <- SELECT from NEW2 where JOB.Dept = “Personnel” and ASSIGNMENT.TermDate = “*”

NEW4 <- PROJECT EMPLOYEE.Name, EMPLOYEE.Address from NEW3

Explanation:

The relation “NEW1” contains all the records from the relation “EMPLOYEE” and “ASSIGNMENT” which satisfy the indicated condition...

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 15

Ch. 9.1 - Identify two departments in a manufacturing plant...Ch. 9.1 - Prob. 2QE Ch. 9.1 - Summarize the roles of the application software...Ch. 9.2 - Prob. 1QE Ch. 9.2 - Prob. 2QE Ch. 9.2 - Prob. 4QE Ch. 9.2 - Prob. 5QE Ch. 9.2 - Prob. 6QE Ch. 9.3 - Prob. 1QE Ch. 9.3 - What is a persistent object?

SQL SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Solution Summary: The author describes SQL as a structured query language used to manage the data of the database and perform manipulations.

SQL

SQL stands for structured query language. SQL is used basically to manage the data of the database and to perform manipulations over the data.

Explanation of Solution

Explanation of Solution

Want to see the full answer?

Chapter 9 Solutions