2023 In the SLP assignments in the previous modules you accomplished the following Determined the scope of | Assignment Collections
Computer Science 2023 SQL SLP
2023 In the SLP assignments in the previous modules you accomplished the following Determined the scope of | Assignment Collections
In the SLP assignments in the previous modules, you accomplished the following:
- Determined the scope of the project and the kinds of data you planned to collect based on information requirement (Module 1 SLP)
- Drew an ER diagram to represent relationship among the tables (Module 2 SLP)
- Conducted normalization to the tables so all tables satisfied the 3rd normal form, and created tables using Oracle SQL (Module 3 SLP)
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:
- Employee information (e.g., employee name, address, phone number, hiring date, salary, etc.)
- Information about the books and CDs in the bookstore (e.g., title, author, price, etc.)
- Sales of CDs and books, searchable by date
- Current inventory status of books and CDs
- Any other output you think appropriate
Write a 2- to 5-page paper that includes your SQL statements and screenshots of the results tables in the DBMS (database management system).
SLP Assignment Expectations
- You can work by yourself or with a classmate on this project. If working with a partner, be sure to write both students’ names on the assignment.
- Apply what you have learned to address the questions raised.
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.