Database Implementation and Research Activity: SQL Queries, NoSQL Features | SEO

Running head: DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Database Implementation and Research Activity
Name of the Student
Name of the University
Author’s note:

1DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Table of Contents
Assessment Part A:..........................................................................................................................2
Assessment Part B:..........................................................................................................................3
Important Features of Blockchain Database:...............................................................................3
Important Features of Cloud Database:.......................................................................................4
References:......................................................................................................................................6

2DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Assessment Part A:
Query 1: Select SUM(LINE_UNITS) AS 'Total Units' From line Group By
INV_NUMBER;
Query 2: Select * from product Where V_CODE='';
Query 3: Select * from invoice i Where i.INV_SUBTOTAL>25 AND
i.INV_SUBTOTAL<75;
Query 4: Select * from invoice i Where i.INV_SUBTOTAL = (Select
Min(inv.INV_SUBTOTAL) from invoice inv Group By inv.INV_SUBTOTAL);
Query 5: Select distinct p.V_CODE, v.V_NAME from vendor v inner join product p on
v.V_CODE = p.V_CODE ;
Query 6: Select v.V_CODE from vendor v EXCEPT Select p.V_CODE from product p;
Query 7: Select v.V_CODE from vendor v Where v.V_CODE NOT IN (Select
p.V_CODE from product p);
Query 8: Select p.V_CODE, COUNT(p.V_CODE) from product p Where p.V_CODE !=
'' GROUP BY p.V_CODE;
Query 9: Select Distinct v.V_NAME, v.V_CODE, COUNT(p.P_CODE) from vendor v
inner join product p on v.V_CODE=p.V_CODE Where v.V_CODE != '' GROUP BY
v.V_NAME, v.V_CODE;