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
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
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…
Create Owner Table
Insert Data
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.
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
This optional Google account security feature sends you a message with a code that you must enter, in addition ...
SURVEY OF OPERATING SYSTEMS
15. The density of gasoline is 0.72 grams per cubic centimeter [g/cm3]. What is the mass in units of kilograms ...
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
The while loop is a _______ type of loop. a. pretest b. no-test c. prequalified d. post-iterative
Starting Out with Python (4th Edition)
The STL stack container is an adapter for the _________, __________, and ___________ STL containers.
Starting Out with C++ from Control Structures to Objects (9th Edition)
Describe two properties that each candidate key must satisfy.
Modern Database Management
The command from the JDK compiles a Java program.
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
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
- USE MICROSOFT SQL SERVERarrow_forwardQ4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.arrow_forwardInsert 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_forward
- 1. 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_forwardTask 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_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_forwardstudent takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> creditsarrow_forward
- CSC1100 ProductID ProdName 614 Sprinkler G15 Humming bird feeder 620 Garden hose 625 Shovel JG29 Tab connector G43 Leaf roke G46 Pruning Shears 656 Bird House 35 G57 Planter box 130 Answer the following questions about the Products table in this image 1. What are the field names? Products InStock Database Review 78 40 60 30 65 89 8arrow_forwardPROBLEM Create a C++ program that will perform record management of students. The code must involve implementation of control structures / array / struct/user-defined functions/class. INSTRUCTION: 1. Create a User's Menu for your program. An example is given below: Record Management [1] Add Record [2] Display Record Input your Choice:__ 2. If 1 is chosen, the user will be allowed to create 2 unique student records using the ADD_RECORD user-defined function. 3. After creating 2 records, the user may choose 2 to display existing and non-existing records. Use DISPLAY_RECORD user-defined function. 4. Perform the following 4 Test Cases below.arrow_forwardProduct_id Product_name Category Mfg_date Exp_Dte Product_price 01 Dairy Milk Choclate Junk 2,Aug, 2019 2aug, 2020 80 02 Lipton Tea Bags Not junk 2,jan 2019 2, jan 2020 160 03 Kurkure junk 2, april 2919 2, april, 2021 30 04 Shezan Juice Junk 3,Aug, 2019 3,aug, 2020 30 06 Olpers Milk Not junk 3,april, 2018 3,april, 2020 350 Canteen_table 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”. Change colum name of product_price to unit_price. Display products manufactured between 1, jan 2019 to 1, May 2019. Display count of only junk food items in canteen_table with alias name as “junk Food Count”. Display Count Of both Junk food and not junk food products whose count is greater then 1.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