Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Write a query to delete job with id of 10 from job table

Write a query to delete job with id of 10 from job table

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Write a query to delete job with id of 10 from job table 

tables.pdf 1 / 5 80% + For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep trackof clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers,and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, thecompany needs to be able to keep track of the data on each job an employee performs for each of their clients. E Client ClientName Address State Zip Phone (603)774-6698 03223 (603)536-9234 Email Contact City 63 Elm Street dentpro@comcast.net dstewart54@aol.com osfurniture21@aol.com johnyspizza@verizon.net Dentist Pros James Tucker Manchester NH 03308 Danny Stewart Jo Collins Danny's Hardware 5 Main Street Campton Brattleboro VT NH 1 Jo's Furniture 54 High Street 05301 Johny's Pizza Plymouth Professionals Anthony Vicente 54 Main Street 84 Highland Street Campton NH 03223 (603)536-1988 Margaret Jones Joan Jenkins 03264 03301 Plymouth maggiej@att.net thecornergrocery@att.net The Corner Grocery NH (603)536-2388 (603)254-5498 (603)536-1234 34 State Street Concord NH tmcdougal@comcast.net Mountain Coffee Terry McDougal 23 Main Street Plymouth NH 03264 Employee EmployeeName BirthDate 08/20/1966 10/04/1961 08/17/1973 10/02/1966 08/13/1971 SSN 123456789 Vedran Lelas 251466698 Sandy Harris 257992213 Jane Williams 261284363 Tony Milano 394108933 Harry Pots 546871891 | Colby Mitchel 658412335 | Bobby Daniel 04/19/1968 04/16/1964 Job JobID Email SSN JobDate TimeStart TimeEnd 1 tmcdougal@comcast.net 2 maggiej@att.net 3 josfurniture21@aol.com dentpro@comcast.net dstewart54@aol.com 6 dstewart54@aol.com thecornergrocery@att.net 8 dentpro@comcast.net 9 tmcdougal@comcast.net 10 johnyspizza@verizon.net 658412335 03/12/2006 394108933 03/12/2006 546871891 | 03/13/2006 257992213 03/13/2006 658412335 03/14/2006 261284363 03/14/2006 257992213 03/14/2006 257992213 03/15/2006 658412335 03/15/2006 251466698 03/16/2006 08:00:00 AM 05:00:00 PM 10:00:00 AM 04:00:00 PM 09:00:00 AM 05:00:00 PM 4 08:00:00 AM 02:00:00 PM 08:00:00 AM 05:00:00 PM 08:00:00 AM 07:00:00 PM 7 01:00:00 PM 03:00:00 PM 08:00:00 AM 02:00:00 PM 09:00:00 AM 01:00:00 PM 11:00:00 AM 01:00:00 PM 2:15 PM 2 Type here to search W 69°F 5/5/2022 2 ... II
Transcribed Image Text:tables.pdf 1 / 5 80% + For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep trackof clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers,and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, thecompany needs to be able to keep track of the data on each job an employee performs for each of their clients. E Client ClientName Address State Zip Phone (603)774-6698 03223 (603)536-9234 Email Contact City 63 Elm Street dentpro@comcast.net dstewart54@aol.com osfurniture21@aol.com johnyspizza@verizon.net Dentist Pros James Tucker Manchester NH 03308 Danny Stewart Jo Collins Danny's Hardware 5 Main Street Campton Brattleboro VT NH 1 Jo's Furniture 54 High Street 05301 Johny's Pizza Plymouth Professionals Anthony Vicente 54 Main Street 84 Highland Street Campton NH 03223 (603)536-1988 Margaret Jones Joan Jenkins 03264 03301 Plymouth maggiej@att.net thecornergrocery@att.net The Corner Grocery NH (603)536-2388 (603)254-5498 (603)536-1234 34 State Street Concord NH tmcdougal@comcast.net Mountain Coffee Terry McDougal 23 Main Street Plymouth NH 03264 Employee EmployeeName BirthDate 08/20/1966 10/04/1961 08/17/1973 10/02/1966 08/13/1971 SSN 123456789 Vedran Lelas 251466698 Sandy Harris 257992213 Jane Williams 261284363 Tony Milano 394108933 Harry Pots 546871891 | Colby Mitchel 658412335 | Bobby Daniel 04/19/1968 04/16/1964 Job JobID Email SSN JobDate TimeStart TimeEnd 1 tmcdougal@comcast.net 2 maggiej@att.net 3 josfurniture21@aol.com dentpro@comcast.net dstewart54@aol.com 6 dstewart54@aol.com thecornergrocery@att.net 8 dentpro@comcast.net 9 tmcdougal@comcast.net 10 johnyspizza@verizon.net 658412335 03/12/2006 394108933 03/12/2006 546871891 | 03/13/2006 257992213 03/13/2006 658412335 03/14/2006 261284363 03/14/2006 257992213 03/14/2006 257992213 03/15/2006 658412335 03/15/2006 251466698 03/16/2006 08:00:00 AM 05:00:00 PM 10:00:00 AM 04:00:00 PM 09:00:00 AM 05:00:00 PM 4 08:00:00 AM 02:00:00 PM 08:00:00 AM 05:00:00 PM 08:00:00 AM 07:00:00 PM 7 01:00:00 PM 03:00:00 PM 08:00:00 AM 02:00:00 PM 09:00:00 AM 01:00:00 PM 11:00:00 AM 01:00:00 PM 2:15 PM 2 Type here to search W 69°F 5/5/2022 2 ... II
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS