Relational Database Management System

Running head: RELATIONAL DATABASE MANAGEMENT SYSTEM
Relational Database Management System
Name of the Student
Name of the University
Author’s note:

1RELATIONAL DATABASE MANAGEMENT SYSTEM
Table of Contents
Part A:..............................................................................................................................................2
Part B:..............................................................................................................................................7
References:....................................................................................................................................10

2RELATIONAL DATABASE MANAGEMENT SYSTEM
Part A:
Query 1: select vendor.V_CODE, V_NAME, COUNT(P_CODE) AS
NumberOfProducts
From vendor
Inner Join product
On vendor.V_CODE = product.V_CODE
Group By vendor.V_CODE;
Query 2: Select CUS_LNAME, FORMAT(SUM(INV_TOTAL), 2) as
Total_invoice_value
From customer

3RELATIONAL DATABASE MANAGEMENT SYSTEM
inner join invoice
on customer.CUS_CODE = invoice.CUS_CODE
group by customer.CUS_CODE;
Query 3: Select CUS_LNAME, Count(INV_TOTAL) as Num_Of_Invoices
From customer
inner join invoice
on customer.CUS_CODE = invoice.CUS_CODE
group by customer.CUS_CODE;