Developing a Database System: Query the Tables Database Queries and Reports....

Developing a Database System: Query the Tables

Database Queries and Reports

For the same bookstore database, generate reports for the output specified in SLP 1:

1.       Current inventory status of the books and CDs

2.       Sales Transactions List

3.       Monthly Profit Report

4.       Inventory Status Query by Product

5.       Sales Transaction that each employee has processed

6.       Any other output you think appropriate

Write a 2- to 5-page paper that includes your SQL statements and screenshots of the result tables in DBMS.

SLP Assignment Expectations

1.       Use SQL properly for data manipulation, mainly querying the tables to obtain required information.

2.       Communicate effectively with your audience.
Powered by