Database Implementation and Research Activity

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:..........................................................................................................................4
NoSQL Database:........................................................................................................................4
Important Features of Cloud Database:.......................................................................................6
References:......................................................................................................................................9

2DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Assessment Part A:
Query 1: SELECT SUM(LINE_UNITS) AS 'TOTAL LINE UNITS' FROM LINE
GROUP BY INV_NUMBER;
Query 2: SELECT * FROM PRODUCT WHERE V_CODE='';
Query 3: SELECT * FROM INVOICE WHERE INV_SUBTOTAL<75 AND
INV_SUBTOTAL>25;
Query 4: SELECT * FROM INVOICE I WHERE I.INV_SUBTOTAL = (SELECT
MIN(INV.INV_SUBTOTAL) FROM INVOICE INV GROUP BY INV.INV_SUBTOTAL);

3DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
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) AS 'NUMBER OF PRODUCTS'
FROM PRODUCT P WHERE V_CODE != '' GROUP BY V_CODE;