Computer Science: An Overview (12th Edition)
12th Edition
ISBN: 9780133760064
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 9.2, Problem 2QE
Explanation of Solution
Sequence of relational operations for given scenario:
To find a list of all job titles where the department is “personnel”, the sequence of relational operations is
LIST1 <- SELECT from JOB where
Dept = 'Personnel'
RESULT <- PROJECT JobTitle from LIST1
Code Explanation:
- The given code is used to lists the all job titles within the department “Personnel”...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
part a please fast
Convert this table to a relation in first normal form by entering appropriate data in the table. What are the determinants in this relation?
The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative.
PATIENT ID
PATIENT NAME
PATIENT DOB
CONSULT DATE
ITEM NUMBER
ITEM DESCRIPTION
FEE
PROVIDER NUMBER
DOCTOR NAME
437
REARDON
4/08/1989
19/7/2020
A012
Standard
56
S55768
Leahy
437
REARDON
4/08/1989
20/7/2020
A012
Standard
56
D42433
Meuller
562
BILSTEIN
12/05/2001
20/7/2020
A013
Short
35
S55768
Leahy
361
WILSON
13/08/1997
20/7/2020
A014
Long
75
S55768
Leahy
895
LEMOS
13/10/1952
20/7/2020
A013
Short
35
D42433
Meuller
895
LEMOS
13/10/1952
20/7/2020
A014
Long
75
D42433
Meuller
678
MORTAL
27/02/1969
20/7/2020
A014
Long
75
S55768
Leahy
432
SOAPIER
1/08/1976
21/7/2020
A012
Standard
56
S55768
Leahy
You have been asked to design a…
Chapter 9 Solutions
Computer Science: An Overview (12th Edition)
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
- An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.arrow_forwardThe relational database below contains two related tables - “Supplier” and “Product”: “Product” table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype Prod -stocklevel Prod -expireDate Supp-code 10010 aaa qwert 615 123445677 2017-11-14 501 10011 bbb asdfgg 615 234567899 2017-11-16 501 10012 ccc zxxcvv 234 345678900 2017-11-13 502 10013 eee ytuytu 234 454577777 2017-10-13 503 10014 jjj werewr 231 436436885 2017-10-23 503 10015 sdg rtyrtyry 275 676446322 2017-10-30 504 10016 ewt erterter 789 232317879 2017-12-30 501 “Supplier” table: Primary key = Supp -code, No Foreign key Supp -code Supp -lname Supp -fname Supp -Initial Supp -areacode Supp -phone 501 xxx qwert F 615 123445678 502 yyy asdfgg B 615 234567890 503 zzz zxxcvv X 234 345678901…arrow_forwardThe relational database below contains two related tables - “Supplier” and “Product”: “Product” table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype Prod -stocklevel Prod -expireDate Supp-code 10010 aaa qwert 615 123445677 2017-11-14 501 10011 bbb asdfgg 615 234567899 2017-11-16 501 10012 ccc zxxcvv 234 345678900 2017-11-13 502 10013 eee ytuytu 234 454577777 2017-10-13 503 10014 jjj werewr 231 436436885 2017-10-23 503 10015 sdg rtyrtyry 275 676446322 2017-10-30 504 10016 ewt erterter 789 232317879 2017-12-30 501 “Supplier” table: Primary key = Supp -code, No Foreign key Supp -code Supp -lname Supp -fname Supp -Initial Supp -areacode Supp -phone 501 xxx qwert F 615 123445678 502 yyy asdfgg B 615 234567890 503 zzz zxxcvv X 234 345678901…arrow_forward
- The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Scott 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Mueller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Scott 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Scott 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Mueller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Mueller 678 MORT 27/02/1969 20/7/2020 A014 Long 75 S55768 Scott 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Scott You have been asked to design a…arrow_forwardAccording to the given table, who is the secretary in the accounting department with experience in the personnel department?arrow_forwardDevelop recurrence relations for the last 3 columns of table 1. Use the recurrence relation you developed to complete the table for these months: • Month 59 • Month 60 • Month 61 • Month119 • Month 120 • Month 121 Show your calculations and completed table.arrow_forward
- Consider the tables given below and write the relational Algebra for the following tasks Table Name: Products ProductID ProductName Unit Price SupplierlD 1 Chais 10 boxes x 20 bags 18 1 Chang 24 - 12 oz bottles 19 1 3. Aniseed Syrup 12 - 550 ml bottles 10 1 4 ChefAnton's Cajun Seasoning 48 - 6 oz jars 22 Table Name: Suppliers SupplierID SupplierName ContactName Address City 1 Exotic Liquid Charlotte 49 Gilbert St. Londona Сооper New Orleans Cajun Shelley Burke P.O. Box 78934 New Delights Orleans Grandma Kelly's Regina Murphy 707 Oxford Rd. Ann Arbor Homestead 4 Tokyo Traders Yoshi Nagase 9-8 Sekimai Tokyo Musashino-shi A. Write the Relational algebra for the following questions. i. Find all the information of products whose price is from 15 to 25 inclusively. ii. Find the lowest price of products for each supplier ID. iii. Find ID, name and address of suppliers whose city is Tokyo. B. Convert the following SQL statements to Relational Algebra expressions: i. Select * From Products…arrow_forwardQ1) Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE.arrow_forwardNormalize the following unnormalized table using the three normalization rules and describe each step. Unnormalized table:arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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