logo

Database Design: Assignment

9 Pages404 Words85 Views
   

Added on  2020-03-28

Database Design: Assignment

   Added on 2020-03-28

ShareRelated Documents
Running Head: DATABASE SYSTEMDatabase Design[Student Name][University Name]
Database Design: Assignment_1
DATABASE SYSTEM1Table of ContentsQuery 12Query 23Query 33Query 44Query 55Query 66Query 77Query 87Query 98Query 109Query 1110Query 1210
Database Design: Assignment_2
DATABASE SYSTEM2Query 1SELECT DISTINCTinvoice.INV_NUMBER,invoice.INV_DATE,invoice.INV_SUBTOTAL,invoice.INV_TAX,invoice.INV_TOTAL,invoice.CUS_CODE,Count(line.INV_NUMBER)FROMinvoiceNATURAL JOIN lineGROUP BYinvoice.INV_NUMBER,invoice.INV_DATE,invoice.INV_SUBTOTAL,invoice.INV_TAX,invoice.INV_TOTAL,invoice.CUS_CODEOutput Query 2SELECTvendor.V_CODE,vendor.V_NAME,vendor.V_CONTACT,vendor.V_AREACODE,vendor.V_PHONE,vendor.V_STATE,vendor.V_ORDER
Database Design: Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Assignment on Database Design System
|9
|396
|50

Assignment on Database System
|17
|541
|50

Database System Assignment - SQL Code
|17
|541
|99

Query and Update Databases Using SQL
|13
|275
|39

Sums of Line Totals for Each Lnvoice
|10
|450
|61