Question 7 (4 points) Please use Software Expert (SWE) Database. List the first and last name...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 7 (4 points) Please use Software Expert (SWE) Database. List the first and last name of every consultant who has ever worked on a project with consultant Mark Myers. Include Mark Myers in the result set. Use a subquery. You must also use the consultant's full name in your query. Question 8 (4 points) Please use Software Expert (SWE) Database. Use the UNION operator to generate a result set consisting of two columns: project ID and name. The result must include all the projects with completed evaluations AND projects managed by consultant with last name that starts with 'Z'. Use a subquery. Remove any duplicate results. Question 9 (4 points) Please use Software Expert (SWE) Database. a. Write an ALTER TABLE statement that adds a new 'total_days' column to the project_consultant table. This new column should have a default value of 0 (zero). b. Update the new column with the difference of ROLL OFF and ROLL ON dates. c. Display all the contents of project_consultant table. d. Drop the 'total_days' column. Question 10 (4 points) Please use Software Expert (SWE) Database. a. Include statements to drop the table if it already exists. b. Create a new evaluation_audit table with these columns: - audit_id (primary key, auto increment): integer - audit_e_id: integer (do not allow nulls) - audit_score: integer - audit_user: string (length of 20) c. Insert a new row for consultant (e_id) 100 with a score of 90. d. Display all the contents of evaluation_audit table. Question 11 (5 points) Please use Software Expert (SWE) Database. Modify evaluation_audit table as follows: a. Assign empty string to audit_user column that have NULL values. Write a single ALTER TABLE statement that will disallow null values for the audit_user column. b. Write an ALTER TABLE statement that adds a new 'audit_date' column. c. Insert another row for consultant 100 with a score of 95 along with the current user and current date. Hint: Use the USER() and SYSDATE() functions. d. Display all the contents of evaluation_audit table. e. Write a negative test case by inserting a row for consultant 100 with a score of 99 with an unknown user and date. This will show an error message in the ERR file. Question 12 (1 point) Please use Software Expert (SWE) Database. Write a negative test case by inserting a new row with an unknown (NULL) skill_id to the project_skill table. Question 13 (2 points) Please use Software Expert (SWE) Database. Write a negative test case by deleting a row from the consultant table that will violate a foreign key constraint. Question 7 (4 points) Please use Software Expert (SWE) Database. List the first and last name of every consultant who has ever worked on a project with consultant Mark Myers. Include Mark Myers in the result set. Use a subquery. You must also use the consultant's full name in your query. Question 8 (4 points) Please use Software Expert (SWE) Database. Use the UNION operator to generate a result set consisting of two columns: project ID and name. The result must include all the projects with completed evaluations AND projects managed by consultant with last name that starts with 'Z'. Use a subquery. Remove any duplicate results. Question 9 (4 points) Please use Software Expert (SWE) Database. a. Write an ALTER TABLE statement that adds a new 'total_days' column to the project_consultant table. This new column should have a default value of 0 (zero). b. Update the new column with the difference of ROLL OFF and ROLL ON dates. c. Display all the contents of project_consultant table. d. Drop the 'total_days' column. Question 10 (4 points) Please use Software Expert (SWE) Database. a. Include statements to drop the table if it already exists. b. Create a new evaluation_audit table with these columns: - audit_id (primary key, auto increment): integer - audit_e_id: integer (do not allow nulls) - audit_score: integer - audit_user: string (length of 20) c. Insert a new row for consultant (e_id) 100 with a score of 90. d. Display all the contents of evaluation_audit table. Question 11 (5 points) Please use Software Expert (SWE) Database. Modify evaluation_audit table as follows: a. Assign empty string to audit_user column that have NULL values. Write a single ALTER TABLE statement that will disallow null values for the audit_user column. b. Write an ALTER TABLE statement that adds a new 'audit_date' column. c. Insert another row for consultant 100 with a score of 95 along with the current user and current date. Hint: Use the USER() and SYSDATE() functions. d. Display all the contents of evaluation_audit table. e. Write a negative test case by inserting a row for consultant 100 with a score of 99 with an unknown user and date. This will show an error message in the ERR file. Question 12 (1 point) Please use Software Expert (SWE) Database. Write a negative test case by inserting a new row with an unknown (NULL) skill_id to the project_skill table. Question 13 (2 points) Please use Software Expert (SWE) Database. Write a negative test case by deleting a row from the consultant table that will violate a foreign key constraint.
Expert Answer:
Related Book For
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall
Posted Date:
Students also viewed these databases questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
A group of investors is considering buying the Wheelwright Corporation, but does not want to contribute to the companys financial support after the purchase. Wheelwrights management has offered the...
-
New York is roughly 3000 miles from Seattle. When it is 10:00 a.m. in Seattle, it is 1:00 p.m. in New York. Using this information, estimate (a) The rotational speed of the surface of Earth, (b) The...
-
Leno Computers manufactures tablet computers for sale to retailers such as Fallon Electronics. Recently, Leno sold and delivered 200 tablet computers to Fallon for $20,000 on January 5, 2020. Fallon...
-
Why would anyone design a tuned absorber for a machine?
-
Richard, age 45, is married with two children in high school. He estimates that his average annual earnings over the next 20 years will be $60,000. He estimates that one-third of his average annual...
-
Duggins Veterinary Supplies can issue perpetual preferred stock at a price of $50 a share with an annual dividend of $4.50 per share. Duggins must pay flotation costs of 5% of the issue price. What...
-
Four pesticides used in dormant California orchards are chlorpyrifos, diazinon, methidathion, and parathion. Environmental Science & Technology (Oct. 1993) reported the number of applications of...
-
1. Discuss why is it difficult to define the concept of disaster? Is it a moving target? 2. Analyze and discuss the role of culture and the design of civilization on the way disasters are perceived....
-
Calculate and compare the Pepsi and Coke based on the broader ratios. BALANCE SHEET Pepsi Coke Assets 2019 2019 Cash 7,282 9,000 Short term investment 0 48,600 Acc. Receivable 632,160 351,200...
-
We assume that the energy of H 1s orbital is -13.6 eV (vs. vacuum, same below) and the and o* orbital in H2 molecule is -15.6 eV and -11.6 eV, respectively. Draw the band diagram of the H chain...
-
2. Write a script file that will prompt the user an arbitrary number of positive input values and will solve the harmonic mean of the numbers. Display an error message when the user input a negative...
-
A 10 m thick metal sheet of size 10 cm 10 cm is annealed in a pure nitrogen atmosphere with pN2 = 10 atm, until a uniform concentration of N atoms is established within the sheet. Then the sheet is...
-
Explain the classification of the leases for machinery A and machinery B in accordance with MFRS 117 Leases b. Prepare the Statement of Financial Position (extract) as at 30 June 2015 and 30 June...
-
The liquid level in a tank is controlled using a Pneumatic proportional controller as shown the figure below. The level sensor is able to measure over the range 1.85 to 2.25 m. it is found that,...
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
Design a search that will find potential competitors of a company such as Worlds Trend on the Web. Assume you are the customer.
-
1. Use STROBE to compare and contrast Evanss and Ketchams offices. What sort of conclusion about each persons use of information technology can you draw from your observations? How compatible do...
-
Merle, come here and take a look at these end-of-the-week reports, Portia pleads. As one of the managers on the six-person IS task force/quality assurance committee, Portia has been examining for her...
-
What would be the most effective option to increase employee motivation to stay and reduce the driver turnover rate? Why do you believe this option will be effective?
-
How else might the manager have handled the situation to prevent potential issues, including a negative impact on the teams performance?
-
In what ways do you believe providing special work arrangements or accommodations for employees impacts employee motivation? How does it help? How does it hurt?
Study smarter with the SolutionInn App