Homework Answers
Please find the SQL query below.
SELECT p.* FROM person p JOIN skill s ON p.ssn = s.ssn WHERE manuf_co = '111-22-3333' GROUP BY s.ssn HAVING count(prod_id) > (SELECT avg(count(prod_id)) FROM skill WHERE manuf_co = '111-22-3333');
Add Answer to:
Translate the following query into extended Relational
Algebra
Find every person who is skilled at the...
Translate the following queries into extended Relational Algebra (Use COUNT to do this one) Find every...
Translate the following queries into extended Relational
Algebra
(Use COUNT to do this one) Find every person who is skilled in
the manufacture of every product manufactured by 111-22-3333.
company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div name, subdiv_of, dir_ssn, div_hq) site(co id, divname, loc) product(prod id, manuf co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod id, manuf co
company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div name, subdiv_of, dir_ssn, div_hq) site(co...
Consider following relational database schema and translate the queries ‘a’ and ‘b’ into relational algebra expressions...
Consider following relational database schema and translate the queries ‘a’ and ‘b’ into relational algebra expressions Teacher(ID, Name, Designation, Phone, Address) Course(CourseCode, CourseName, CreditHour) Taught(TeacherID, CourseCode, Semester) a. SELECT Name, Address FROM Teacher, Taught WHERE Teacher.ID=Taught.TeacherID and CourseCode=’IT344’ b. SELECT CourseName FROM Course, Taught WHERE Course.CourseCode=Taught.CourseCode and TeacherID=200
Task 4 Consider the tables given below and write the relational Algebra for the following tasks:...
Task 4 Consider the tables given below and write the relational Algebra for the following tasks: (30 Marks) Table Name: Products ProductID Product Name 1 Unit Price Supplier 10 boxes x 20 bags 181 24 - 12 oz bottles 191 12-550 ml bottles 10 1 2 Chang Aniseed Syrup MEC AMO_TEM OM ON Fundamentals of Relational Database Management Systems (COMP 20002) - Spring-2020 -CW Assignment - ALL-OP 4 ChefAnton's Cajun Seasoning 48-6 oz jars 22 2 Table Name: Suppliers Supplier...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
John and Jane Doe are married retired taxpayers who care for their three-year-old grandson. The following...
John and Jane Doe are married retired taxpayers who care for
their three-year-old grandson. The following information was
provided to you as documentation necessary to prepare their 2017
tax return. You will gather the appropriate information and
complete the forms provided in Blackboard (1040, Schedule A,
Schedule B and Schedule D) in preparation of their tax file. Please
note that the forms provided may not match the tax year of the
course, as IRS forms are not available until just...
23. What is the total net amount of capital gain reported on Form 1040? OA. $308...
23. What is the total net amount of capital gain reported on
Form 1040? OA. $308 OB. $2,411 C. $2,719 OD. $2,900
Advanced Scenario 7: Mark and Barbara Matthews Directions Using the tax software, complete the tax return, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering Social Security numbers (SSNs) or Employer Identification Numbers (EINS), replace the Xs as directed, or with any four digits of your choice....
Super stuck on a couple of questions on this scenario. Advanced Scenario 7: Mark and Barbara...
Super stuck on a couple of questions on this scenario.
Advanced Scenario 7: Mark and Barbara Matthews Directions Using the tax software, complete the tax retum, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering Social Security numbers (SSNS) or Employer identification Numbers (EINS), replace the Xs as directed, or with any four digits of your choice. Interview Notes • Mark and Barbara are married and want to file...
And there was a buy-sell arrangement which laid out the conditions under which either shareholder could...
And there was a buy-sell arrangement which laid out the
conditions under which either shareholder could buy out the other.
Paul knew that this offer would strengthen his financial
picture…but did he really want a partner?It was going to be a long
night.
read the case study above and answer this question
what would you do if you were Paul with regards to financing,
and why?
ntroductloh Paul McTaggart sat at his desk. Behind him, the computer screen flickered with...
Translate the following queries into extended Relational
Algebra
(Use COUNT to do this one) Find every person who is skilled in
the manufacture of every product manufactured by 111-22-3333.
company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div name, subdiv_of, dir_ssn, div_hq) site(co id, divname, loc) product(prod id, manuf co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod id, manuf co
company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div name, subdiv_of, dir_ssn, div_hq) site(co...
Task 4 Consider the tables given below and write the relational Algebra for the following tasks: (30 Marks) Table Name: Products ProductID Product Name 1 Unit Price Supplier 10 boxes x 20 bags 181 24 - 12 oz bottles 191 12-550 ml bottles 10 1 2 Chang Aniseed Syrup MEC AMO_TEM OM ON Fundamentals of Relational Database Management Systems (COMP 20002) - Spring-2020 -CW Assignment - ALL-OP 4 ChefAnton's Cajun Seasoning 48-6 oz jars 22 2 Table Name: Suppliers Supplier...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
John and Jane Doe are married retired taxpayers who care for
their three-year-old grandson. The following information was
provided to you as documentation necessary to prepare their 2017
tax return. You will gather the appropriate information and
complete the forms provided in Blackboard (1040, Schedule A,
Schedule B and Schedule D) in preparation of their tax file. Please
note that the forms provided may not match the tax year of the
course, as IRS forms are not available until just...
23. What is the total net amount of capital gain reported on
Form 1040? OA. $308 OB. $2,411 C. $2,719 OD. $2,900
Advanced Scenario 7: Mark and Barbara Matthews Directions Using the tax software, complete the tax return, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering Social Security numbers (SSNs) or Employer Identification Numbers (EINS), replace the Xs as directed, or with any four digits of your choice....
Super stuck on a couple of questions on this scenario.
Advanced Scenario 7: Mark and Barbara Matthews Directions Using the tax software, complete the tax retum, including Form 1040 and all appropri- ate forms, schedules, or worksheets. Answer the questions following the scenario. Note: When entering Social Security numbers (SSNS) or Employer identification Numbers (EINS), replace the Xs as directed, or with any four digits of your choice. Interview Notes • Mark and Barbara are married and want to file...
And there was a buy-sell arrangement which laid out the
conditions under which either shareholder could buy out the other.
Paul knew that this offer would strengthen his financial
picture…but did he really want a partner?It was going to be a long
night.
read the case study above and answer this question
what would you do if you were Paul with regards to financing,
and why?
ntroductloh Paul McTaggart sat at his desk. Behind him, the computer screen flickered with...
Most questions answered within 3 hours.
-
A few random results for you to ponder…do the results justify
the conclusions? Why or why...
asked 20 seconds from now -
Which of the following is the most accurate description of how a
sound wave propagates?
a)...
asked 1 minute from now -
Before the final distribution of cash, account balances are:
Cash $23,000; S. Penn, Capital $19,000 (Cr.);...
asked 3 minutes ago -
On May 1, Sequoia Inc. issued 30,000 shares of its common stock
with a $15 par...
asked 4 minutes ago -
For Python 2.7.8, Write a program that defines
a function that prints a short poem or...
asked 4 minutes ago -
An optical disk drive in your computer can spin a disk up to
10,000 rpm (about...
asked 15 minutes ago -
Is the purpose of lightning rods to attract lightning?
asked 24 minutes ago -
Let A be an event included in S that is independent of itself.
Then we have:...
asked 23 minutes ago -
The Adverse Childhood Experiences (ACE) Study has had a great
impact on moving psychologists to be...
asked 20 minutes ago -
Write a paper on: Assume that you have been assigned as the
project manager for a...
asked 24 minutes ago -
You plan to save $5,700 per year for the next 10 years. After
the last deposit,...
asked 57 minutes ago -
On January 1, 2019, ABC Corp. borrowed $81,000 by signing an
installment loan. The loan will be...
asked 1 hour ago