Homework Help | SQL CODING

Business & Finance homework help

Gateway Essay Writing Help

No enough time to write your essay? Don’t worry. Our experts will help you in writing your essay. Place an order and let our team help you get the best grade in this essay.

Plagiarism Free Essays

Plagiarism is the greatest enemy of academic assignments. You must make sure that your essays are well-referenced and uses enough citations. You must also work diligently to make sure your essay is original and with zero plagiarism. Our experts deliver quality papers that are plagiarism free.

Order Completion Rating

Online Tutors

Orders Completed [High Quality]

 

This assignment was solved yesterday, for the first time by our experts.

 

SQL CODING

 

 
a1.  Use CREATE  statement to create a table Client (ClientName,  phone). Note ClientName is primary key and you must define this primary key in CREATE statement. Show the statement.
a2. Use INSERT statement to add two client records into Client table (make up your own data for clients). Show the INSERT statements and use select statement to show the table contents.
a3.  Use ALTER statements to add a foreign key ClientName as a constraint into the Project table. So that table Client has a one  to many relationship with table Project. Note, you need to use TWO ALTER statements , one for adding attribute ClientName into Project table; one for adding foreign key constraint into Project table.  Show the ALTER statements.
a4. User ALTER statement to Add an attribute Project_Count into Employee table (data type to be integer, refer to the data type used for Workon table (hours)  in loadDB file).
a5. Use UPDATE statement to fill the value of Project_count of each employee record in Employee table. Namely, add the count of total number of projects an employee works on into Project_count in Employee table for each employee.  Hint: you need a subquery in Update statement as follows
  Update _________
  Set _____ = (select count (pid) …… )
Show the contents of Employee after update. 
a6 Create a table Promotion_list (EMPID, Name, Salary, DivisionName). 
a7 Load Promotion_list with the information of employees who make less than company average and work on at least 2 projects. (Hint use INSERT INTO SELECT statement ). Show the code and result. 
Part B
b1. Increase the budget of a project by 5% if there is a manager working on it .
b2. List the name of employee who work on a project sponsored by his/her own division. (corelated subquery)
b3. List the name of project that has budget that is higher than ALL projects from ‘marketing’ division. 
b4. List the name of project that has budget that are higher than ALL projects from ‘chen’s division. 
b5. List the name of employee who work on more projects than his/her manager.
b6. List The name of division that has employee(s) who work on other division’s project . (corelated subquery)

 

By placing an order with us, you are guaranteed to obtain an original solution to this assignment. Our rates start at $9.

Click here to order a solution.

Gateway Essay Writing Help

No enough time to write your essay? Don’t worry. Our experts will help you in writing your essay. Place an order and let our team help you get the best grade in this essay.

Plagiarism Free Essays

Plagiarism is the greatest enemy of academic assignments. You must make sure that your essays are well-referenced and uses enough citations. You must also work diligently to make sure your essay is original and with zero plagiarism. Our experts deliver quality papers that are plagiarism free.

Frequently Asked Questions – King Service FAQs

Is this service Legit?

This is an extension of Gateway Assignment essay writing services. Gateway is a group of writers brought together by the desire to help students achieve more in essay writing. Our Writers are experts in tutoring, research, and writing activities. We have worked with over 5,000 students pursuing college, undergraduate, Masters, and Ph.D. degrees. Our Services are Trusted and Verified.

Will My Paper have plagiarism?

No. Absolutely Not. All our Papers are Original and are written by our experts from scratch. To be sure, you can request a plagiarism report when placing an order.

How Fast can you deliver my paper?

Any duration you select when choosing a deadline for the paper. The number of hours could be 3 hours to 24 hours to 2 days, a month, or any other duration.

For short assignments ranging between 1 page and 3 pages(100 – 1000 words), we can have them delivered in 1 hour.

Can I get a professional writer to write my essay?

Absolutely Yes. If you are looking for the most reliable and executive essay writing service, you are in the right place.

Our Service is a program dedicated to improving student’s achievement in essay writing assignments. In our company, professional tutors and expert writers work together to create original solutions to help students complete their assignments.

Our essay writing service is the most reliable writing help online. Our writers are former students and researchers in leading institutions across the world.

Our founder, Frank, is a legend writer and educator who has contributed significantly to improving the performance of thousands of students.

The goal of Gateway Assignment is to lead in changing the learning process by allowing students to access unlimited resources in writing their essays.

How Much will it Cost?

Our Rates start at $10 per page (275 words). Plus:

  • Free First Page
  • Free Reference Page
  • Free Unlimited Revisions
Can I get a Discount for my first paper?

Ofcos. Use the discount code “GATEWAY20” at checkout to get a 20% discount off on all essays you order.

Do I get a refund if I am not satisfied with the paper?

Yes. Anytime you establish that Our Services did not help you meet your desired outcome, you are entitled to a Full Refund. Read our refund policy to learn more.

'One More Question'?

Chat with a live agent on the floating chat. Frank is online now.

Get a Plagiarism-free paper Today

Order an essay, term paper, research paper, or any other assignment and get an expert to work on it. Use GATEWAY20 to get a 20% discount on all papers.

Alternatively, Check Out the FIVE STEPS in writing an essay