List all the records in the vendor table

Assignment Help Database Management System

Reference no: EM131489179

Task

Write SQL statements to answer the following questions from the 'assignment'

Database: Answer all questions

1. List all the record/s in the vendor table that do not have a value for the attribute V_STATE.

2. Find the customers whose balance is greater than 250 but less than 400.

3. Create a query based on invoice table to show a 15% increase on tax in a new column.

4. Show the first and last names of the customers for whom we have issued invoices.

5. Show the CUS_CODE of the customers for whom we DO NOT have invoices.

6. Show the names of the customers for whom we DO NOT have invoices

7. Find out how many times a customer generated an invoice - make sure the counted column heading reads "Invoices_generated" .

8. List the names of the customers and how many times a customer generated an invoice - make sure the counted column heading reads "N_Of_Invoices" .

9. Find the customers whose last name is either Dunne, Orlando or Brown and live in area 615, sort in alphabetical order by the CUS_LNAME,.

10. Add a new attribute called 'email_address' to 'emp' table and use data type and length 'VARCHAR-20'.

11. Add a new row/record to the 'customer' table to include your actual student ID in the CUS_CODE, your lastname as the CUS_LNAME' and your firstname as CUS_FNAME. Add any other details in the other fields.

12. Delete all the vendors in the FL state.

Rationale

This assignment will assess your knowledge and ability to use SQL to create database tables. It will also test your ability to write both simple and complex queries given a set of results that are required and to the run those queries to return the requested data.

Reference no: EM131489179

Questions Cloud

Why do the different lenders have different rates : Find 5 different online mortgage lenders, such as this onehttps://www.lendingtree.com/ From these 5 lenders, find the following rates, assuming the mortgage.

International hrm case study-brunt hotels : Based on the information you have at the end of Part 1, what do you think the key priorities should be?

Compare pros and cons of the rise of pmcs and pscs : Compare the pros and cons of the rise of Private Military Companies (PMCs) and Private Security Companies (PSCs) and their operations in conflict zones.

Should fresh farming lease the tractors : Fresh Farming Company is negotiating a lease for five new tractors with Leasing International. The terms of the lease offered by Leasing International call.

List all the records in the vendor table : Write SQL statements to answer the following questions from the 'assignment'. List all the record/s in the vendor table that do not have a value for attribute

Polycentric and geocentric attitudes towards global business : Contrast ethnocentric, polycentric and geocentric attitudes towards global business.

What is the expected npv of the project : The San Francisco Yacht Company (SFYC), a prominent sailboat builder in San Francisco, is considering developing and marketing a new line of personal sailboard.

Employee feels they have been treated unfairly : What are 2-3 employment laws that an employer should consider in ethical decision making when an employee feels they have been treated unfairly.

Problem of representing two offensive linemen : The NFL season has just concluded and you have the problem of representing two offensive linemen from the Super Bowl Champion Arizona Cardinals.

Reviews

len1489179

5/9/2017 1:21:09 AM

All SQL code in MySQL must be copied and pasted into your submission file. Outputs of each query also should have shown followed by the query. Accurate and elegant SQL that answers all parts of the question. SQL code copied from MySQL as well as a screen shot of code and results into the submission file. This assessment item is required to be submitted in Word format (.doc, or .docx). All SQL statements should be copied from MySQL into the word document. All screenshots that are required should be captured and inserted into the document in the appropriate position to show that you have completed the requirement. Screenshots that are submitted in addition to the assignment document will not be marked. Databases must not be included as part of a submission. Any extensions required must be applied for before the due date of the assignment.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages