You’re interested in studying the catalytic activity of a rare protein expressed in an exotic plant but present in very low amounts in plant tissues. Your supervisor asks you to search an NCBI genomic database for a potential homologous DNA sequence and you think you found a good match. Propose a strategy to obtain large quantities of this plant protein for your studies. Your complete experimental strategy must be outlined to receive full marks for this question.

Write the SQL queries that accomplish the following tasks using the AP Database

9. Write a select statement to show the invoicelineitemdescriptions that have the total invoicelineitemamount >1000 and the number of accountno is >2.

10. Write a select statement that returns the vendorid, paymentsum of each vendor, and the number of invoices of each vendor, where paymentsum is the sum of the paymentotal column. Return only the top ten vendors who have been paid the most and the number of invoices is >5.

Part A - Discussion on the audit report

The audit report is the key product of the auditing and assurance process. Using an essay format, discuss the values, issues, and future of the audit report. You are required to cite at least three readings, and two of them must be academic articles from the literature (use the Google Scholar or UoN’s library/database). The textbooks such as Moroney, et al. (2017) do not qualify as an article. APA 6^th is required with an appropriate reference list.

While scraping user data from social media sites is not illegal, failing to secure this data after it has been collected poses a serious risk to the affected users as cybercriminals could use the information from the database to target them online. What are your recommendations to the online risk policy makers as you think it is a breach of PII (Personal Identifiable Information). Justify your answer. Explain the need for cybersecurity experts in such a case scenario.

Using MongoDB, what command would you enter to retrieve this document using only the zip code 11242?

db.inspections.find(???????)


Database: city
Collection: inspections

{"_id":{"$oid":"56d61033a378eccde8a898ae"},
"id":"23536-2015-ENFO",
"certificate_number":5373970,
"business_name":"NZO CORP.",
"date":"Apr 22 2015",
"result":"Violation Issued",
"sector":"Grocery-Retail - 808",
"address":{"city":"BROOKLYN",
     "zip":11242,
     "street":"COURT ST",
     "number":26}}

General-purpose computers and domain-independent relational database systems have become a large market in the last several decades. However, many people feel that generic data mining systems will not prevail in the data mining market. What do you think? For data mining, should we focus our efforts on developing domain-independent data mining tools or on developing domain-specific data mining solutions? Present your reasoning.

Identify 4 cloud service providers and give the required criteria provided below for each of the 4 cloud services. Which provider would you select for a GIS development? Why?

• Provider
• Service Model: IAAS/ PAAS
• Deployment Model: Public Cloud, Private Cloud, Hybrid
• Virtual Machine Size: Max CPU, Max Mem
• Operating Systems
• Uptime (availability)
• Security
• Location of servers
• Application services
• Database services

Subject :Introduction to Database

SQL

Q 1: List the emp who are working for the Deptno 10 or 20.

Q 2: List the Empno, Ename, Sal, Dname of all the ‘MGRS’ and ‘ANALYST’ working in New
York or Dallas with an salary 3000, 2450 or 2850.

Q 3. List the daily salaries (Salary per day) of employees?

Q 4: Display ename ,sal , and increment of in 100 in annual sal from employee Table?