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.

                                                                                                                                      Order Now