Module 4 – SLP

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.

You can leave a response, or trackback from your own site.
error: Content is protected !!