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
Concept explainers
Expert Solution & Answer
Chapter 9, Problem 37CRP
Explanation of Solution
Sequence of operation using “JOIN”, “SELECT”, and “PROJECT”:
LIST1 <- JOIN ASSIGNMENT and JOB
where ASSIGNMENT.JobId = JOB.JobId
LIST2 <- SELECT from LIST1 where ASSIGNMENT.EmpId = '34Y70'
RESULT <- PROJECT JobTitle from LIST2
Explanation for above sequence:
The given SQL statement is used to list the job tile from two relations “Assignment” and “Job” where the value of “EmpId” in relation “Assignment” is “34Y70”
- From the given code, the statement “LIST1 <- JOIN ASSIGNMENT and JOB where ASSIGNMENT.JobId = JOB.JobId” performs join operation.
- It means combine the attributes of both relations “ASSIGNMENT” and “JOB” where the value of “JobId” in relation “ASSIGNMENT” is equal to the value of “JobId” in relation “JOB” and then store it in new relation called “LIST1”...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Table: Team Member
Primary key: Team MemberID
Team MemberID
1
2
3
Team MemberName
Joe Bloggs
Samantha Smith
Pete Ngwenya
Table: Task
Primary key: TaskID
Foreign key: Team MemberID
TaskID
1
2
3
Description
Build login screen
Implement inventory
management
Add logo to splahs 1
screen
TeamMemberEmail
joe@theoffice.com
sam@theoffice.com
pete@theoffice.com
Duration StartDate
Team MemberID
2022-05-06
1
2022-05-15 1
4
10
2022-05-06 2
For the following database scheme
Employee(empNo,fName.IName.address.DOB.sex,position.deptNo)
Department(deptNo.deptName,mgrEmpNo)
Project(projNo.projName,deptNo)
WorksOn(empNo.projNo.dateWorked,hoursWorked)
Write an SQL statement to find all the details of employees who are female
Trying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forwardWrite a SQL statement that returns a list of the team members with all their tasks. Include the team member’s name and the description of the task in the results.arrow_forwardI need the answer as soon as possiblearrow_forward
- Write a SQL statement that will change the value of the Taskdescription with ID 3 to “Add logo to splash screen”.arrow_forwardTable: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs 1 screen Duration StartDate 2022-05-06 4 10 TeamMemberID 2 1 2022-05-15 1 2022-05-06 2 Write a SQL statement that will add the below row to the Task table. TaskID Description Duration StartDate Team MemberID 3 4 Implement 2022-05-07 email notifications Write a SQL statement that will change the value of the Task description with ID 3 to "Add logo to splash screen".arrow_forwardWrite SQL statement that retrieve the department_name that has the maximum number of employees: Select one: a. select d_name from depart where depart_id=( select depart_id from emp having count(*)= (select max(count(*)) from emp group by depart_id) group by depart_id); b. select depart_name from depart where depart_id=( select depart_id from emp where count(*)= (select max(count(*)) from emp group by depart_id) group by depart_id); c. select depart_name from depart where depart_id=( select depart_id from emp having count(*)= (select max(count(*)) from empl group by depart_id)); d. select depart_name from depart where depart_id=( select depart_id from emp having count(*)= (select max(count(*)) from emp group by depart_id) group by depart_id);arrow_forward
- SQL Language Questionarrow_forwardWrite an SQL SELECT statement for the following problem statement. Retrieve the customer name, service description, employee name, employee title, charge identifier, charge start time, and charge end time. The result should only include billed charges (ChgBilled - True) with a start time in January 2020. Include a charge even if there is no employee associated with the charge.arrow_forwardWrite SQL statement that prints the intitials (first letter of first name and first lettter or last name name seperated by a space) of all individuals.arrow_forward
- The relational schema shown below is part of a hospital database. The primary and foreign keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Admission (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Write SQL queries based on the hospital database given above: 1. Create the above tables together with its constraints. 2. Insert some data into the tables to check that the tables created are correct. No limit on how many rows you want to add. Insert Syntax:insert into table_namevalues (col1_value, col2_value, etc.); 3. List all the patients’ details, alphabetically by name. IF YOU WANT SOME CHALLENGE4. List all the patients admitted today. (Join between Patient and Admission table)arrow_forwardThe SQL statement below is used to select students with the last name "Smith". What is wrong with the statement? SELECT FirstName FROM Student WHERE LastName = Smith; The literal "Smith" must be surrounded by single quotes or double quotes. The WHERE clause should be removed. The last name "Smith" may not exist in the database.arrow_forwardWrite an SQL statement for each of the following tasks: 1. List the instructors and start_time for all timeslots related to class course 'Body Pump'. The list should be ordered by the instructor’s name. 2. Find all the courses and all the related instructors that are teaching the course. Results should be ordered by the course. 3. Show the bookings planned by a specific user, e.g. uid= ‘U001’. In particular: a) Class ID, course, instructor, start_time, and reservation (only if it is ‘1’) for each timeslot, for each class taken by the user. b) The total number of bookings on each of the Class IDs that the user has reserved, if the given user is a student.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning