Computer Science: An Overview (13th Edition) (What's New in Computer Science)
13th Edition
ISBN: 9780134875583
Author: BROOKSHEAR
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 solution
Students 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
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERD components.)
FIGURE P2.15 THE CROW’S FOOT ERD FOR PROBLEM 15
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
- answer a and b questions below Examine the table shown below. This table represents the hours worked per week for temporary staff at each branch of a company staffNo branchNo BranchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 – 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza,Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 – 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 a. Identify the functional dependencies represented by the data shown in the table. State any assumptions you make about the data (if necessary b. Using the functional dependencies identified in part (b), describe and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.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_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_forwardGiven the following Staff2 table, please write a SQL statement to find the superno who supervised 4 or more staff. The superno is the supervisor's staffno. staffno fname Iname position ABC1 New Engineer Intern CC1 Super User DBA SA9 Mary Howe SG14 David Ford SG37 Ann Beech SG5 Susan Brand SL21 John White SL41 Julie Lee XY1 New Tester Forth sex DOB M M Assistant F Supervisor M Assistant F Manager F Manager M Assistant F Assistant M salary branchno superno 1/1/2000 9000 B002 SL21 1/1/1995 90000 B005 SG14 2/19/1970 9000 B007 SG5 3/24/1958 18000 B003 SG5 11/10/1960 12000 B003 SG5 6/3/1940 24000 B003 SL21 10/1/1945 30000 B005 NULL 6/13/1965 9000 B005 SL21 1/1/1990 8000 B002 SL21arrow_forwardAn EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Question: Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.arrow_forward
- Give employee Id, name, and date hired of the managers who have the highest experience (years employed) order by employee name. If there is more than one employee with the highest experience, show all. Q1.2 : Give all manager names and date hired for managers whose work experience is higher than the work experience of their employees. List results in managers' name order. Q1.3: List Material ID and Product Id in which the Material has the highest quantity required for this material. List results in order of Material ID. Q1.4: For products that have used materials, show the product ID, product description, material ID, and quantity required of materials whose quantity required is higher than the average quantity required for that material. Sort the results by product ID and then by material IDarrow_forwardNeed help with this: Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 1-2. No computer work is required. 1. List the first and last names of all customers that have a credit limit above, but not including, $500. 2. List the invoice numbers for invoices placed by customer ID 435 on November 18, 2021. 3. List the item ID, item description, and on-hand value for each item in category HOR. (Hint: On-hand value is the result of multiplying the number of units on hand by the price.) 4. List the item ID and item description of all items that are in category DOG. 5. How many customers have a balance that exceeds their credit limit? 6. What is the item ID, description, and price of the least expensive item in the database? 7. For each invoice, list the invoice number, invoice date, customer ID, and customer first and last names. 8. For each invoice placed on November 16, 2021, list the invoice number, customer ID, and customer first and last names. 9.…arrow_forwardOne hundred students were asked whether they had taken courses in any of the three subjects, Mathematics, Computer Science and Information Technology. The results were given below. 45 had taken Mathematics; 18 had taken Mathematics and Computer Science; 38 had taken Computer Science; 21 had taken Information Technology; 9 had taken Mathematics and Information Technology.; 4 had taken Computer Science and Information Technology and 23 had taken no courses in any of the subjects. Draw a Venn diagram that will show the results of the survey.arrow_forward
- Considering 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_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_forwardFor each Consultant, list the Consultant last name, the average balance of the consultant’s clients, and the number of clients assigned to the consultant. Group the records by consultant name, and order the records by consultant name. For each Consultant, list the Consultant last name, the average balance of the consultant’s clients, and the number of clients assigned to the consultant. Group the records by consultant name, and order the records by consultant name.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 Ptr
COMPREHENSIVE 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