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:
Hey
A Data base design and database development expert is here
I can help you with your database design and SQL Queries Task
This is an initial bid
Feel free to message us
Regards
If you send me the right file, will be my pleasure aswers all questions about. Please contact me and send me the BITS Database.accdb. You attached the lock file (.laccdb) not database file(.accdb).
Hello Sir
Hows you doing ? I am a new freelancer looking for my first job here on freelancer . I have worked on similar projects on Up-work.I am a entry level DBA who have decent command over Oracle ,MySQL ,database design and PL/SQL .
Looking forward to hearing from you.
Dear Employer,
I will provide you the best and satisfactory result by using my Experience and skill set. We can discuss more on your requirement via chat and can start.
Thanks.
as a database expert for 10 years , I think your projects is simple. all the sql is used again and again in my daily life and many project , I can do it now and finish it as soon as possible.
Using my SQL database skills I am confident that I can complete this job successfully. I have 6 years experience. You have set out in great detail what needs to be done which is very helpful. I see there is a BITS database attached which I am unfamiliar with.