Download Tstbd.sql file from VU collaborates Assessments.
Important Note: after you download the file move it to any folder in the C drive (for example move it to Eclipse folder).
Start WAMP PhpMyAdmin
Create a new Database, then import thetstbd.SQL file into the database
Take screen-shoots for the SQL commands and the output for each of the below query, place these screenshots in a word file; submit the file to your class dropbox. Write your exam version on the submitted word file
Write The SQL statements for the following each question weight 2 marks
1. List part number and description for parts with prices lower than 100$
2. List Customers number who first name start with `A`
3. What is the average customer balance?
4. What is the customer number, last and first name and balance that has the highest balance?
5. Display the part descriptions of all the parts that have been selected on an order?
6. Display all the order numbers of the orders placed by customer Sally Adams
7. How many parts are stored in each of the warehouses?
8. What is the customer numbers of the customers that have placed more than one order?
9. What are the parts number and desciption of most expensive 3 parts?
10. Increase the commission by 10 percent, for sales representative responsible for Mara Galvez.
We always make sure that writers follow all your instructions precisely. You can choose your academic level or professional level, and we will assign a writer who has a respective degree.
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document.
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension.A 100% refund is guaranteed.
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.
Tutorpro support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
At Tutorpro, we have top rated masters and PhD writers who will help you tacke that homework and score A+ grade. Tutorpro services covers all levels of education : high school, college, university undergraduate, masters and PhD academic level.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Tutorpro academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. This is free because we want you to be completely satisfied with the service offered.