Module 4 – SLP
RELATIONAL ALGEBRA AND SQL DML STATEMENTS
Assignment Overview
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 results 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.
Written on October 20th, 2017 by
Module 4 – SLP
Posted in Uncategorized