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
Videos
Textbook Question
Chapter 9, Problem 20CRP
| 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
20. Design a relational
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
Indicate 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.
SQL QUESTIONS
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
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Write a program that checks a text file for several formatting and punctuation matters. The program asks for th...
Java: An Introduction to Problem Solving and Programming (8th Edition)
This optional Google account security feature sends you a message with a code that you must enter, in addition ...
SURVEY OF OPERATING SYSTEMS
Personal Information Class Design a class that holds the following personal data: name, address, age, and phone...
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
Sales Tax Write a program that will ask the user to enter the amount of a purchase. The program should then com...
Starting Out with Python (4th Edition)
What are some of the most commonly used brazing metals?
Degarmo's Materials And Processes In Manufacturing
Assume a telephone signal travels through a cable at two-thirds the speed of light. How long does it take the s...
Electric Circuits. (11th 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
- 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_forwardUSE MICROSOFT SQL SERVERarrow_forwardQ4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.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_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_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_forward
- Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb). Task 16: List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25lb).arrow_forwardProduct Order PID Description Quantity 300 Price Vendor OID Date 2012/5/23 2 CID Unique traders AT Cosmetics General traders Unique traders General traders Foodie Shop Shampoo 50 1 1 2 Soap 140 230 40 30 2012/5/24 3 Detergent 4 2016/4/23 4 Milk 14 33 3 2016/2/12 2016/1/10 4 Lemon Max 10 20 6 1 6. Chocolate 34 34 Invoice Customer OrderNo 1 ProductID Quantity CustomerID Name city 1 1 Ali Rawalpindi 1 3 1 Ahmad Islamabad 4 2 1 Umer Chakwal 2 6. 3 Каrim Islamabad 2 3 1 Shafig Islamabad 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 3 4 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Showname of customerand orderno who have placed any order and belong to "Islamabad". 2. Showname of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day. 4. Showdata of those product that are purchased by those customer who neither belong 5. To"Rawat"nor…arrow_forwardTable name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degreearrow_forward
- Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component. Make each entry match the values shown in the following table. TABLE P8.53 UPDATES FOR THE DETAILRENTAL TABLE RENT_NUM VID_NUM DETAIL_RETURNDATE 1001 34342 02-MAR-18 10:00am 1001 61353 03-MAR-18 11:30am 1002 59237 04-MAR-18 03:30pm 1003 54325 09-MAR-18 04:00pm 1003 61369 09-MAR-18 04:00pm 1003 61388 09-MAR-18 04:00pm 1004 44392 07-MAR-18 09:00am 1004 34367 07-MAR-18 09:00am 1004 34341 07-MAR-18 09:00am 1005 34342 05-MAR-18 12:30pm 1005 44397 05-MAR-18 12:30pm 1006 34366 04-MAR-18 10:15pm 1006 61367 1007 34368 1008 34369 05-MAR-18 09:30pm 1009 54324 1001 34366 02-MAR-18 10:00amarrow_forwardNeed correct solution else downvotearrow_forwardUse the university schema for the following questions student takes ID ID course id sec id name dept_name tot ged semester vear grade section course course id sec id department course id advisor title dept_name credits dept name s id semester Year building room number time slot id building budget time_slot time slot id day start time end time prereq instructor classroom couTse id grereg id ID building room_number name dept_name salary сараcity teaches ID course id sec id semester year Figure 2.9 Schema diagram for the university database. Use the online SQLite tool from db-book.com to write SQL statements for each of the questions below. Paste your solution SQL statement under each question and upload the document to Canvas. 1. Display the name and total institution credits taken (not tot_cred which includes transfer credits) of students that do not have an assigned advisor (across all years). a. Hint: link takes with courses and student, for students not in advisor, project the name…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