Module 4 SLP: Relational Algebra And SQL DML Statements

Order 100% Plagiarism free paper

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:
Current inventory status of the books and CDs
Sales Transactions List
Monthly Profit Report
Inventory Status Query by Product
Sales Transaction that each employee has processed
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
Use SQL properly for data manipulation, mainly querying the tables to obtain required information.
Communicate effectively with your audience.

source..