CiS120-PJ1-report-my-name.docx)

docx

School

East Los Angeles College *

*We aren’t endorsed by this school

Course

123

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by MagistrateWaterOtter209

Q0. (Sample) List LastName and FirstName of those consultants who do not serve any clients. LastName FirstName Shields Tom Q1. List the names of all clients who have a credit limit >= $10,000 [Hint: The answer contains 3 names. One name is “Two Crefty Cousins”.] Two crafty cousins, prichard’s Pizza & Pasta, harpersburg bank Q2. List the descriptions of all items in the Tasks table that have the category DRM. [Hint: The answer contains 2 descriptions. One description is “Data Recovery Major”.] Data Recovery Major, Data Recovery Minor Q3. List the order numbers for orders placed by client number 322 on September 10, 2018. [Hint: The answer contains 2 numbers. One number is 67424.] 67424, 67949 Q4. List the order number, the order date, and the scheduled date for any work order involving the TaskID SA44. (You must show a table for this query result.) [Hint: The answer contains only one record.] 68868,9/14/2018, 9/24/2018 Q5. List the name of each client who placed an order that has exactly two different tasks in the OrderLine table. [Hint: The answer contains 2 names. One name is “Harpersburg Bank”. The other name begins with “P”.] Harpersburg bank, prichard’s Pizza & Pasta Q6. List the name of each client who has a credit limit of $5,000, and is represented by the consultant Patrick Jordan. [Hint: The answer contains 2 names. One name is “Howler, Laura”.] Howler Laura, seymour lindsey Q7. List the sum of the balances for all customers represented by the consultant Christopher Turner. [Hint: The result must be only one big $ amount, not a list of $ amounts.] $30,000 Q8. For each order placed on September 10, 2018, list the order number, the client name, the last and first name of its consultant. (You must show a table for this query result.) [Hint: The answer contains 3 records. One record is as follows: “67838 MarketPoint Sales Turner Christopher”] 67838 MarketPoint Sales Turner Christopher, 67424 mobility prichard’s Pizza & Pasta ,67949 printing issues prichard’s Pizza & Pasta Q9. List the name of each client who placed an order that has exactly three different tasks in the OrderLine table. [Hint: The answer contains only one name. The name begins with “P”.] prichard’s Pizza & Pasta

Q10. List ClientNum, ConsltNum, and City for each client whose city is the same as the city of its consultant. (You must show a table for this query result.) [Hint: The answer contains 2 records. One record is “322 35 Lizton”.] 322 35 lizton, 143 19 easton Q11. List the ClientNum and the ClientName for each client whose consultant is “Christopher Turner”, and who has ordered only one work order so far. (You must show a table for this query result.) [Hint: The answer contains only one record. The ClientName begins with character “H”.] 826 harpersburg bank Q12. BITS company would like to be able to contact clients when problems arise concerning any order. Please recommend some new attributes or columns or fields, which should be added to the Client table to assist in contacting the clients Email or phone number.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

CS 405 5-3 Activity Static Code Analysis(revised).docx

CS 405 5-1 Case Study Triple A and Defense in Depth.docx

CS 405 2-1 Journal Defense in Depth (DiD).docx

Quiz7.docx

Quiz6.docx

CiS120-PJ 2-QBE.docx

Aviation Assignment.pdf

2-2 short responses.docx

questions for final.docx

Assignment_3_Template.docx

Quiz5.docx

CSB LAB 4.pdf

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning