Homework
In the SLP homework in the previous modules, you accomplished the following:
1) Determined the scope of the project and the kinds of data you planned to collect based on information requirement.
2) Drew an ER diagram to represent relationship among the tables.
3) Conducted normalization to the tables so all tables satisfied the 3rd normal form, and created tables using Oracle SQL.
In this module, you are to finish the project by applying what you have learned to generate queries (ask questions) of the database.
Database Queries and Reports
For the same bookstore database, write SQL statements to provide the following information for the output specified in the SLP:
1) Employee information (e.g., employee name, address, phone number, hiring date, salary, etc.)
2) Information about the books and CDs in the bookstore (e.g., title, author, price, etc.)
3) Sales of CDs and books, searchable by date
4) Current inventory status of books and CDs
5) Any other output you think appropriate
Write a 2 to 5 pages paper that includes your SQL statements and screenshots of the results tables in the DBMS (database management system).
Format your homework according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.