Computer Science: An Overview (12th Edition)
12th Edition
ISBN: 9780133760064
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 9, Problem 21CRP
| Empl Id | Name | Address | SSN | Job Id | Job Title | Skill Cod | Dept | Start Date | Term Date |
| 25X15 | Joe E. Baker | 33 Nowhere St | 111223333 | F5 | Floor manager | FM3 | Sales | 9-1-2009 | 9-30-2010 |
| 25X15 | Joe E. Baker | 33 Nowhere St | 111223333 | D7 | Dept. head | K2 | Sales | 10-1-2010 | * |
| 34Y70 | Cheryl H. Clark | 563 Downtown Ave. | 999009999 | F5 | Floor manager | FM3 | Sales | 10-1-2009 | * |
| 23Y34 | G. Jerry Smith | 1555 Circle Dr. | 111005555 | S25X | Secretary | T5 | Personnel | 3-1-1999 | 4-30-2010 |
| 23Y34 | G. Jerry Smith | 1555 Circle Dr. | 111005555 | S26Z | Secretary | T6 | Accounting | 5-1-2010 | * |
| • | • | • | • | • | • | • | • | • | • |
| • | • | • | • | • | • | • | • | • | • |
| • | • | • | • | • | • | • | • | • | • |
Figure 9.4
21. Design a relational
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
INVOICES
INVOICE LINE
INVOICE NUM INVOICE DATE CUST ID
11/15/2021
INVOICE NUM ITEM ID QUANTITY
14216
QUOTED PRICE
14216
125
CA75
$37.99
14219
11/15/2021
227
14219
AD72
$79.99
14222
11/16/2021
294
14219
DT12
4.
$39.99
14224
11/16/2021
182
14222
LD14
$47.99
14228
11/18/2021
435
14224
KH81
4.
$18.99
14231
14233
14237
11/18/2021
11/18/2021
125
14228
FS42
$124.99
435
14228
PF19
1.
$74.99
11/19/2021
616
14231
UF39
2.
S189.99
14233
KH81
$19.99
QB92
WB49
LP73
14233
$109.95
14233
$74.95
14237
$54.95
ТЕМ
ITEM ID DESCRIPTION
ON HAND
CATEGORY
LOCATION
PRICE
Dog Feeding Station
Fenthers Bird Cage (12x24x18)
AD72
12
DOG
B.
$79.99
10
BRD
B
$79.99
CA75
Enclosed Cat Litter Station
15
CAT
$39.99
Dog Toy Gift Set
Fly Mask with FRars
Folding Saddle Stand
Aquarium (55 Gallon)
DT12
27
DOG
B
$39.99
FM23
41
HOR
$24.95
FS39
12
HOR
$39.99
FS42
FSH
A.
$124.99
KHS1
LD14
Wild Bird Food (25 Ib)
24
BRD
$19.99
Locking Small Dog Door
14
DOG
$49.99
LP73
Lange Pot Carrier
23
DOG
$59.99
Pump & Filter Kit
Quilted Stable…
Table name: ADVISORS
ADVISORID
ADVISORNAME
A102
Sami
A103
Alice
A104
Suad
A105
Tamil
A101
Arun
Table name: DEPARTMENTS
DEPTID DEPTNAME
ELC
D102
D101
IT
D103
BSD
D104
ENG
Table name: STUDENTS
STUDENTID
STUDENTNAME
DOB
GENDER
ALLOWANCE
DEPTID
ADVISORID
STUDENTLEVEL
AGE
6/1/1999 Male
12/30/1994 Female
6/1/1999 Male
5/6/1995 Male
10/15/1992 Male
S103
Hisham
90
D102
A102
Level 1
22
S102
Sara
45 D103
A104
Diploma
27
S101
Salim
45
D103
A104
Diploma
22
S107
Khalil
45 D101
A101
BTech
26
S109
Said
45 D104
A101
Advanced Diploma
29
s100
Ahmad
5/1/1995 Male
45 D101
A103
BTech
26
S104
Faisal
4/5/1998 Male
90 D104
A101
Advanced Diploma
23
S105
Fatima
2/23/1992 Female
90 D102
A102
Level 2
29
9/12/1999 Female
8/13/1991 Female
S106
Arwa
45
D102
A102
Level 3
22
S108
Ibtisam
90 D103
A104
Diploma
30
Write the SQL statement for the following:
1. Using the ON clause, display the advisor name and student name for all students in the BTech
level
Table name: ADVISORS
ADVISORID
ADVISORNAME
A102
Sami
A103
Alice
A104
Suad
A105
Tamil
A101
Arun
Table name: DEPARTMENTS
DEPTID DEPTNAME
D102
ELC
D101
IT
D103
BSD
D104
ENG
Table name: STUDENTS
STUDENTID
STUDENTNAME
DOB
GENDER
ALLOWANCE
DEPTID
ADVISORID
STUDENTLEVEL
AGE
Hisham
6/1/1999 Male
90 D102
S103
A102
Level 1
22
12/30/1994 Female
45 D103
S102
Sara
A104
Diploma
27
S101
Salim
6/1/1999 Male
45 | D103
A104
Diploma
22
5107
Khalil
5/6/1995 Male
45 D101
A101
Blech
26
45 | D104
Advanced Diploma
S109
Said
10/15/1992 Male
A101
29
5/1/1995 Male
45 D101
90 D104
5100
Ahmad
BTech
Advanced Diploma
A103
26
4/5/1998 Male
2/23/1992 Female
9/12/1999 Female
S104
Faisal
A101
23
0 D102
45 D102
S105
Fatima
90
A102
Level 2
29
S106
Arwa
A102
Level 3
22
S108
Ibtisam
8/13/1991 Female
90 D103
A104
Diploma
30
Write the SQL statement for the following:
1. Using the ON clause, display the advisor name and student name for all students in the BTech
level
2. Display the student name, gender and department name of…
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
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Indirect Sorting Through Pointers #2 Write a program that solves the problem of Programming Challenge 3, except...
Starting Out with C++: Early Objects (9th Edition)
A set of standard diagrams for graphically depicting object-oriented systems is provided by _________. a. the U...
Starting Out with Python (4th Edition)
Use the alternatives forms x(t)=N(x0H)+H(Nx0)ek(NH)t(x0H)+(Nx0)ek(NH)t=H(Nx0)ek(NH)tN(Hx0)(Nx0)ek(NH)tN(Hx0) of...
Differential Equations: Computing and Modeling (5th Edition), Edwards, Penney & Calvis
In a program you need to store the populations of 12 countries. a. Define two arrays that may be used in parall...
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
Describe two properties that each candidate key must satisfy.
Modern Database Management (12th Edition)
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
- Member ID 1582 2587 3549 9536 2567 2154 3265 8765 3259 6540 First Name Mara Philip Kathleen Sau Shanice Chase Tommie Dorcas Angel Weston BookingID 1 2 3 4 5 6 7 8 Table 1: Member Last Name Gender Age Female 25 Male 36 Female 25 United States Female 25 United States Hashimoto Gent Hanner Pfau Mccrystal Karner Jia Darity Sanor Martina Room Room 15 Room 25 Room 1 Room 15 Room 5 Room 21 Room 3 Room 8 Date 29-Dec-2020 9-Dec-2021 3-Mar-2019 4-Sep-2021 13-Feb-2021 6-May-2021 10-Nov-2020 4-Apr-2022 Table 2: Booking Days 2 4 6 5 10 6 5 Female 36 Male 37 Male 26 Female 37 Male 24 Male 23 4 Table 3: Make MemberID 3549 9536 6540 2154 2567 2154 3265 1582 $150.00 $80.00 $120.00 $300.00 Country Uganda France 3 4 China Australia United States United States Cost per day $200.00 $80.00 $80.00 $150.00 5 6 7 8 France China BookingID 1 2 Joined Date 16-Aug-2020 21-May-2015 12-Dec-2017 16-Aug-2019 16-Aug-2020 1-Jan-2021 29-Dec-2018 21-May-2019 4-Mar-2019 1-Feb-2022 Status Paid Paid Pending Paid Pending Paid…arrow_forwardIndicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.arrow_forwardSuppliers * SupplierlD Products Order Details Orders Customers * CustomerID V ProductID 9 OrderlD V ProductID * OrderlD CompanyName ProductName 00 CustomeriD EmployeelD OrderDate CompanyName ContactName SupplierID CategoryID QuantityPerUnit UnitPrice UnitPrice ContactName ContactTitle Quantity ContactTitle Address Discount RequiredDate Address City Region City ShippedDate ShipVia Unitsinstock 00 Region PostalCode UnitsOnOrder PostalCode Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Employees V EmployeelD Country Reorderlevel Country Phone Discontinued Phone Fax LastName Fax HomePage FirstName Title TitleOfCourtesy Shippers V ShipperID Birthdate Categories * CategorylD HireDate CompanyName Address Phone CategoryName Description City Region Picture PostalCode Country HomePhone Extension Photo Notes Reportsto Figure 2. The relationship diagram of the NorthWind database. a. Use the ERDPlus tool to design a STAR schema of the data warehouse containing one fact…arrow_forward
- DESPATCH_LIST Order no Order Cus_name Dave E GONES 6023 6023 6028 6152 6152 date 28 Feb 28 Feb 02 Mar 04 Mar Dave E GONES Nick F JENS CHENG Chui 04 Mar CHENG Chui Order amount $1,248 $1,248 $1,290 $999 $999 Prod no EH06 DL21 EH06 SM17 SP38 Description Electric heater Desk lamp Electric heater Quantity Depot no Location 3 • Depot no determines Location (Order_no, Prod_no) determines Quantity, Depot_no 3 6 Sewing machine 1 Sewing pack 10 where, (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description N24 K10 НОЗ N24 K10 Shatin Hunghom Aberdeen Shatin Hunghom Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.arrow_forwardGiven the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees…arrow_forward1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)arrow_forward
- Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.arrow_forwardTable EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.arrow_forwardQ4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.arrow_forward
- Required information id fname lname company address city ST zip 103 Art Venere 8 W Cerritos Ave #54 Bridgeport NJ 8014 104 Lenna Paprocki Feltz Printing 639 Main St Anchorage AK 99501arrow_forwardDESPATCH_LIST Order no Order Cus_name Order Prod no Description Quantity Depot_no Location date amount 6023 28 Feb Dave E GONES $1,248 EHO6 Electric heater 3 N24 Shatin Dave E GONES $1,248 Desk lamp 6023 28 Feb DL21 K10 Hunghom 6028 02 Mar Nick FJENS $1,290 EHO6 Electric hester ноз Aberdeen 04 Mar CHENG Chui Sewing machine 1 6132 $999 SM17 N24 Shatin CHENG Chui Sewing pack 6132 04 Mar $999 SP38 10 K10 Hunghom where, (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description Depot_no determines Location • (Order_no, Prod_no) determines Quantity, Depot_no Q3. Using the DESPATCH LIST table above, identify one example each for insertion, deletion and modification anomalies.arrow_forwardDatabase name: Ch03_StoreCo Table name: EMPLOYEE EMP CODE EMP TITLE EMP LNAME EMP FNAME EP NTIAL EMP DOe STORE CODE imson John 21-May-64 Ratula 09-Feb-60 Nancy Lotte 2 Ms 3 Ms. Oreenboro R 02-Oct-61 4 Jervie Robert 01Jun-71 23-Nov-59 4 Mrs Runperstro SM. Smth 25-Dec-65 Renselser Ogalo Johneson Cary A 31--62 7 M 8 Ms Roberto 10-Sep-60 19-Apr-55 06-Ma6 21-Oct-72 Ekzbeth Endemar Jack 2. 10 Ms. Rose 11 M Broderick Ton 08-Sep 74 25-Au4 25May6 24-May-64 03-Sep-60 12-Nov.70 24 Jan-71 12 M Washington Alan Y 13 M Snth Peter IN 14 Ms Smth Sherry 15 M Olenko Howard 16 M Archiso Barry 17 Ms Grimaido Jenine 4. 18 M. Roserberg Andrew D 03-Oct-60 06-Mar-70 19 M Rosten Peter F 20 M Mckee Robert 1 21 Ma Baunann Jenniter A 11-Dec-74 Table name: STORE STORE YTD SALES REGION_CODE P CODE STORE CODE STORE NAME 1 Access anction 1003455 76 14217 39 986783 22 944568 56 2 Database Coner 3 Tuple Charge 4 Atribute Aley 5 Prinary Key Point 1 29300 45 15 Table name: REGION REGION CODE REOION DESCRPT 1 East 2 west…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
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License