Database Management Systems

Using SQL to (i) create and manipulate database tables, and (ii) extract information from a database. 1. List the complete Tasks table. [11 points] Answer: 2. List the number and name of all clients that are represented by consultant 22 or that have credit limits of $10,000. [11 points] Answer: 3. For each work order, list the order number, order date, number of the client that placed the order, and name of the client that placed the order. [11 points] Answer: 4. List the number and name of all clients represented by Sarah Allen. [11 points] Answer: 5. List the name and remaining credit (CreditLimitBalance) for each client. [11 points] Answer: 6. (Optional) For each consultant, list the consultant last name, the average balance of the consultant’s clients, and the number of clients assigned to the consultant. Order the records by consultant name. [10 points] Answer: 7. Create a new table named Sept21 to contain the columns OrderNum, TaskID, Description, ScheduledDate, QuotedPrice for all rows on which the ScheduledDate is 9/21/2018. You have to select the required information from the relative tables, then use an SQL command to put the result in a newly-created table. [11 points] Answer: 8. In the Sept21 table, change the description of TaskID PI54 to “Misc. Printing.” [11 points] Answer: 9. (Subquery) Find the number of hardware-based orders in OrderLine. In other words, how many “Hardware major” and “Hardware minor” orders have been placed in OrderLine? [11 points] Answer: 10. Use CREATE TABLE to create a new table, called RITStudents, that has 3 attributes, as follows: UID (integer number), Name (text), and Joined (date). [12 points] Answer: