Computer Science: An Overview (13th Edition) (What's New in Computer Science)
13th Edition
ISBN: 9780134875460
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 9.2, Problem 1QE
a.
Identify the secretary in the accounting department with experience in the personnel department:
Explanation of Solution
Refer to figure 9.5.
The secretary in the accounting department has S26Z job ID...
b.
Identify the floor manager in the sales department:
Explanation of Solution
Refer to figure 9.5.
The job ID of the floor manager in the sales department is F5...
c.
Determine the job hold by the G. Jerry Smith:
Explanation of Solution
Refer to figure 9.5.
The employee ID of G...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Consider the System Description of question no 2. All the student are advising to reply the following
queries, keeping in view the above mention system description title as "Dream Home branch offices
case study".
(a) List the details of branches in a given city.
(b) Identify the total number of branches in each city.
(c) List the name, position, and salary of staff at a given branch, ordered by staff name.
(d) Identify the total number of staff and the sum of their salaries.
(e) Identify the total number of staff in each position at branches in Glasgow.
(f) List the names of staff supervised by a named Supervisor.
(g) List the property number, address, type, and rent of all properties in Glasgow, ordered by rental
amount.
(h) Create a branch and staff relationship in view of joint perspective.
(1) List the details of properties for rent managed by a named member of staff.
G) Identify the total number of properties assigned to each member of staff at a given branch.
(k) List the details…
Use the ER Diagram shown on Figure 1 to answer question 9:
9. According to the ER diagram on Figure 1, which of the following is true?
A) For each employee, we will keep track of either the employee name or the unique
employee ID.
B) For each department, we will keep track of either the unique department ID or the
department location.
C) Each employee reports to exactly one department. A department may have many
employees reporting to it, but it does not have to have any.
D) None of the above.
Answer:
EmpID
EmpName
EMPLOYEE
Reports To
Figure 1
DeptID
DeptLocation
DEPARTMENT
The questions in this group refer to the following three relations:
SALESPERSON (Name, Age, Salary)
ORDER (Number, Customer Name, Salesperson Name, Amount)
CUSTOMER (Name, City, Industry Type)
SALESPERSON
Name
Age
Salary
Abel
63
120,000
Baker
38
42,000
Jones
26
36,000
Murphy
42
50,000
Zenith
59
118,000
Kobad
27
34,000
ORDER
Number
CustName
SalespersonName
Amount
100
Abernathy Construction
Zenith
560
200
Abernathy Construction
Jones
1800
300
Manchester Lumber
Abel
480
400
Amalgamated Housing
Abel
2500
500
Abernathy Construction
Murphy
6000
600
Tri-City Builders
Abel
700
700
Manchester Lumber
Jones
150
CUSTOMER
Name
City
Industry Type
Abernathy Construction
Willow
B
Manchester Lumber
Manchester
F
Tri-City Builders
Memphis
B
Amalgamated Housing
Memphis
B
Use the data in those tables and show the SQL…
Chapter 9 Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Ch. 9.1 - Identify two departments in a manufacturing plant...Ch. 9.1 - Prob. 2QECh. 9.1 - Summarize the roles of the application software...Ch. 9.2 - Prob. 1QECh. 9.2 - Prob. 2QECh. 9.2 - Prob. 4QECh. 9.2 - Prob. 5QECh. 9.2 - Prob. 6QECh. 9.3 - Prob. 1QECh. 9.3 - What is a persistent object?
Ch. 9.3 - Identify some classes as well as some of their...Ch. 9.3 - Prob. 4QECh. 9.4 - Prob. 1QECh. 9.4 - Prob. 2QECh. 9.4 - Prob. 3QECh. 9.4 - Prob. 4QECh. 9.4 - Prob. 5QECh. 9.4 - Prob. 6QECh. 9.5 - Prob. 1QECh. 9.5 - Prob. 2QECh. 9.5 - Prob. 3QECh. 9.5 - Prob. 4QECh. 9.5 - Prob. 5QECh. 9.5 - Prob. 6QECh. 9.5 - Prob. 7QECh. 9.6 - Prob. 1QECh. 9.6 - Give an additional example of a pattern that might...Ch. 9.6 - Prob. 3QECh. 9.6 - How does data mining differ from traditional...Ch. 9.7 - Prob. 1QECh. 9.7 - Prob. 2QECh. 9.7 - Prob. 3QECh. 9.7 - Prob. 4QECh. 9 - Prob. 1CRPCh. 9 - Prob. 2CRPCh. 9 - Prob. 3CRPCh. 9 - Prob. 4CRPCh. 9 - Prob. 5CRPCh. 9 - Prob. 6CRPCh. 9 - Prob. 7CRPCh. 9 - Prob. 8CRPCh. 9 - Prob. 9CRPCh. 9 - Prob. 10CRPCh. 9 - Prob. 11CRPCh. 9 - Prob. 12CRPCh. 9 - Using the commands SELECT, PROJECT, and JOIN,...Ch. 9 - Answer Problem 13 using SQL. PROBLEM 13 13. Using...Ch. 9 - Prob. 15CRPCh. 9 - Prob. 16CRPCh. 9 - Prob. 17CRPCh. 9 - Prob. 18CRPCh. 9 - Prob. 19CRPCh. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Prob. 22CRPCh. 9 - Prob. 23CRPCh. 9 - Prob. 24CRPCh. 9 - Prob. 25CRPCh. 9 - Write a sequence of instructions (using the...Ch. 9 - Prob. 27CRPCh. 9 - Prob. 28CRPCh. 9 - Prob. 29CRPCh. 9 - Prob. 30CRPCh. 9 - Prob. 31CRPCh. 9 - Prob. 32CRPCh. 9 - Prob. 33CRPCh. 9 - Prob. 34CRPCh. 9 - Prob. 35CRPCh. 9 - Prob. 36CRPCh. 9 - Prob. 37CRPCh. 9 - Prob. 38CRPCh. 9 - Prob. 39CRPCh. 9 - Prob. 40CRPCh. 9 - Prob. 41CRPCh. 9 - Prob. 42CRPCh. 9 - Prob. 43CRPCh. 9 - Prob. 44CRPCh. 9 - Prob. 45CRPCh. 9 - Prob. 46CRPCh. 9 - Prob. 47CRPCh. 9 - Prob. 48CRPCh. 9 - Prob. 49CRPCh. 9 - Prob. 50CRPCh. 9 - Prob. 51CRPCh. 9 - Prob. 52CRPCh. 9 - Prob. 53CRPCh. 9 - Prob. 54CRPCh. 9 - Prob. 55CRPCh. 9 - Prob. 56CRPCh. 9 - Prob. 57CRPCh. 9 - Prob. 58CRPCh. 9 - Prob. 59CRPCh. 9 - Prob. 60CRPCh. 9 - Prob. 61CRPCh. 9 - Prob. 62CRPCh. 9 - Prob. 1SICh. 9 - Prob. 2SICh. 9 - Prob. 3SICh. 9 - Prob. 4SICh. 9 - Prob. 5SICh. 9 - Prob. 6SICh. 9 - Prob. 7SICh. 9 - Prob. 8SICh. 9 - Prob. 9SICh. 9 - Prob. 10SI
Knowledge Booster
Similar questions
- The questions in this group refer to the following three relations: SALESPERSON (Name, Age, Salary) ORDER (Number, Customer Name, Salesperson Name, Amount) CUSTOMER (Name, City, Industry Type) SALESPERSON Name Age Salary Abel 63 120,000 Baker 38 42,000 Jones 26 36,000 Murphy 42 50,000 Zenith 59 118,000 Kobad 27 34,000 ORDER Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction Jones 1800 300 Manchester Lumber Abel 480 400 Amalgamated Housing Abel 2500 500 Abernathy Construction Murphy 6000 600 Tri-City Builders Abel 700 700 Manchester Lumber Jones 150 CUSTOMER Name City Industry Type Abernathy Construction Willow B Manchester Lumber Manchester F Tri-City Builders Memphis B Amalgamated Housing Memphis B Use the data in those tables and show the SQL…arrow_forwardThe questions in this group refer to the following three relations: SALESPERSON (Name, Age, Salary) ORDER (Number, Customer Name, Salesperson Name, Amount) CUSTOMER (Name, City, Industry Type) SALESPERSON Name Age Salary Abel 63 120,000 Baker 38 42,000 Jones 26 36,000 Murphy 42 50,000 Zenith 59 118,000 Kobad 27 34,000 ORDER Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction Jones 1800 300 Manchester Lumber Abel 480 400 Amalgamated Housing Abel 2500 500 Abernathy Construction Murphy 6000 600 Tri-City Builders Abel 700 700 Manchester Lumber Jones 150 CUSTOMER Name City Industry Type Abernathy Construction Willow B Manchester Lumber Manchester F Tri-City Builders Memphis B Amalgamated Housing Memphis B Use the data in those tables and show the SQL…arrow_forwardIdentify week entity in the following scenario: "Students registered in a particular course section of a specific course". AS. A. Course Section B. Course C. Student D. Register Foc 耳 hp f10arrow_forward
- I tried to understand this question. it says: An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly? Can someone help me with this problem?arrow_forwardThe questions in this group refer to the following three relations: SALESPERSON (Name, Age, Salary) ORDER (Number, Customer Name, Salesperson Name, Amount) CUSTOMER (Name, City, Industry Type) SALESPERSON Name Age Salary Abel 63 120,000 Baker 38 42,000 Jones 26 36,000 Murphy 42 50,000 Zenith 59 118,000 Kobad 27 34,000 ORDER Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction Jones 1800 300 Manchester Lumber Abel 480 400 Amalgamated Housing Abel 2500 500 Abernathy Construction Murphy 6000 600 Tri-City Builders Abel 700 700 Manchester Lumber Jones 150 CUSTOMER Name City Industry Type Abernathy Construction Willow B Manchester Lumber Manchester F Tri-City Builders Memphis B Amalgamated Housing Memphis B Use the data in those tables and show the SQL…arrow_forwardConsidering the un-normalized relational table PROJECT below: PROJECT (Project Title, EmpeName, ManagerName, Location, Hours Work, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.arrow_forward
- Question: a) Draw the entity relationship diagram for each of the following Scenario. i) The company has over 100 employees. Each employee is identified by their Employee_ID. Other attributes are Employee_Name, EmployeeAddress, and Skills. An employee may have more than one skill. And each skill can be mastered by many employees or none. ii) A customer can submit orders to buy products. Each order is identified by Order_ID, and Order_Date. A customer may submit any number of orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Addressarrow_forwardAs of the time of writing, Damon Davis was completing out the paperwork for Drano Plumbing. He estimated a $50,000 net profit would be made. He counted the columns of the balance sheet and knew how much was in the credit column ($300,000) and how much was in the negative column ($400,000). What, in your opinion, was the most plausible reason for the discrepancy in the results? What should he do next to identify the issue's cause if this wasn't the cause of the issue?arrow_forwardProblem List with Expected Results Problem 1 For all departments, display department number and the sum of all salaries for each department. Name the derived column SUM_SALARY. Result WORKDEPT SUM_SALARY A00 B01 C01 D11 D21 E01 E11 E21 128500.00 41250.00 90470.00 222100.00 150920.00 40175.00 104990.00 95310.00arrow_forward
- Note: Terry’s phone is not available in the evidence. However, several files that originated from the phone exist somewhere in the evidence. Can you find them? Are they related to the case? 2009-M57-Patents The 2009-M57-Patents scenario tracks the first four weeks of the 13corporate history of the M57 Patents company. The company started operation on Friday, November 13th, 2009, and ceased operation on Saturday, December 12, 2009. As might be imagined in the business of outsourced patent searching, lots of other activities were going on at M57-Patents.arrow_forwardConsidering the un-normalized relational table PROJECT below: PROJECT (ProjectTitle, EmpeName, ManagerName, Location, HoursWork, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.arrow_forwardThe worksheet for the Drano Plumbing Company was prepared by Damon Davis. He determined that his net income was $50,000. He added up the $400,000 shortfall on his Total Financial Sheet Columns and the $300,000 credit, and then he calculated: Who is aware of the most likely explanation for this disparity? If such is the case, how should he go about locating the issue?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L