a1. Use CREATE statement to create a table Client (ClientName,

 

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)

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

This assignment is a 2-page individual memo about the SWOT

This assignment is a 2-page individual memo about the SWOT analysis of yourself. Many students find this assignment a good opportunity to reflect on themselves.  Discuss the following: external environment: threats and opportunities in your career and job market you seek internal environment: your strengths and weaknesses how can you capture

Directions: Heterosexism can be found in almost every social institution

  Directions: Heterosexism can be found in almost every social institution within society, especially amongst early childhood education. For our writing assignment this week, I want you to pick your favorite childhood storybook, and apply a heterosexist analysis to it. In a 1-2 page es, please answer the following questions: 

Reinforcement is a regularly used treatment for behavior modification. Reinforcers

Reinforcement is a regularly used treatment for behavior modification. Reinforcers can include food, blessings, attention, protection, and many other things. However, in order to be considered a reinforcement, it must increase future occurrences of the behavior. Describe the types of reinforcement and provide a Biblical example where reinforcement was effective

PLEASE ANSWER THE FOLLOWING QUESTION… Please find a recent news

PLEASE ANSWER THE FOLLOWING QUESTION… Please find a recent news story on the Employee Free Choice Act. How might this affect union membership? Is this good or bad for workers and employers? Why? AN EXAMPLE… A recent story that I found was in Staten Island, New York involving Amazon workers.

Scenario Upon reviewing the annual budget and fiscal standing of

 Scenario Upon reviewing the annual budget and fiscal standing of Metropolitan Memorial, the CFO has identified shortfalls that will impact the funding of its proposed expansion into rural communities. In order to secure adequate funding from the Board, the operational team must reduce current operating budget by a million dollars.

Legal Psychology and Victimization This week’s reading includes chapters addressing

  Legal Psychology and Victimization This week’s reading includes chapters addressing the issues of legal psychology and victimization. Chapter 10 in the Bartol & Bartol (2019)  text discusses criminal victimization and the practice of restorative justice. Individual bias and assumptions influence the assessments that are made about other people and

In Milestone Two, you recommended a strategic plan to the

In Milestone Two, you recommended a strategic plan to the organization from the course scenario for the IoT innovation project. Now that senior management of this company has approved your recommendation, your task is to recommend ways the organization can better support innovation. Remember that your perspective is still that

Talk about any business topic that is important or of

 Talk about any business topic that is important or of interest to you. 300 words    Reflect on and critique your experience in preparing, delivering, and evaluating talking about the business topic.address the following: What did you find difficult and/or easy about preparing the talk? What apprehension did you have (e.g.

Position paper on Motivation

write a position paper on the topic of whether or not a leader/manager should have to invest time motivating workers. The general argument for a leader needing to spend time motivating subordinates is that it is part of human nature not work very hard unless an external force provides some

Case Study: http://www.id-book.com/downloads/casestudy_n_1.pdf 1. Summarize the case study (http://www.id-book.com/downloads/casestudy_n_1.pdf) 2.

Case Study: http://www.id-book.com/downloads/casestudy_n_1.pdf   1. Summarize the case study (http://www.id-book.com/downloads/casestudy_n_1.pdf) 2. Identify the study method used and why it was appropriate (http://www.id-book.com/downloads/casestudy_n_1.pdf) 3. Explore some of the qualitative or quantitative methods gathered. (http://www.id-book.com/downloads/casestudy_n_1.pdf) 4. How would you conduct the study any differently? (from peer reviewed journal articles with references) 5.

Personal SWOT Analysis for Success in Real Estate

Personal SWOT Analysis for Success in Real Estate  Assignment Instructions Instructions: Write a 4 to 6 page paper (not including title page or reference page) in APA Format. Your paper must be written in 12 Point Arial or Times New Roman font. A minimum of 3 References required. For this

COMPREHENSIVE SOAP NOTE Nursing Assignment Help

To prepare: Review the Comprehensive SOAP Note Template. Select a patient who you saw at your practicum site during the last 5 weeks. With this patient in mind, consider the following:  Subjective: What details did the patient provide regarding the personal and medical history? Objective: What observations did you make

choose a health care statistic that health care managers would

choose a health care statistic that health care managers would use, such as one of the following: Hospital-acquired condition (HAC) Emergency department visits Labor and delivery suite usage Ambulatory surgery procedures Hospital death rates Cesarean-section rate Wait time Adverse drug events Research your chosen statistic, and provide information from an