Order ID:89JHGSJE83839 | Style:APA/MLA/Harvard/Chicago | Pages:5-10 |
Instructions:
Broward Business Question Essay Paper
It two things.
Scenario 2 activity: (below is the instruction I attached the justleeERG.png)
You successfully completed your first work project, and your boss, Michael, is thrilled that you are learning very quickly and have already gained a healthy understanding of working with databases. Now that you have this foundational knowledge, Michael wants you to begin learning to navigate in a database by using SQL SELECT statements. He will not be in the office today, but he has left your next small project sitting on your desk with detailed instructions. You sit down with a hot cup of coffee and start to review the project details that Michael has assigned you. (ERD – Figure 1.5 is attached).
Work Project Details
Your boss would like you to answer some basic information about the Jostle bookstore business related to retrieving data from a database by using some basic SELECT statements. To determine the exact name of fields used in the tables for this project, he wants you to refer to the tables in the Jostle Books database, or use the DESCRIBE table name command to view the table’s structure.
Display a list of all data contained in the BOOKS table.
List the title only of all books available in inventory, using the BOOKS table.
List the title and publication date for each book in the BOOKS table. Use the column heading “Publication Date” for the Pub date field.
List the customer number for each customer in the CUSTOMERS table, along with the city and state in which the customer lives.
Determine which categories are represented in the current book inventory. List each category only once.
List the customer number from the ORDERS table for each customer who has placed an order with the bookstore. List each customer number only once.
Create a list of each book title stored in the BOOKS table and the category to which each book belongs. Reverse the sequence of the columns so that the category of each book is listed first.
Create a list of authors that displays the last name followed by the first name for each author. The last names and first names should be separated by a comma and a blank space.
List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paid each column. Use a column alias for the calculated value to show the heading “Item Total” in the output other assignment: Using the PM software of your choice, please read the attached and complete the step-by-step instructions: I attached the document title
RUBRIC |
||||||
Excellent Quality 95-100%
|
Introduction
45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Literature Support 91-84 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met. |
|||
Average Score 50-85% |
40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided. |
83-76 points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration. |
52-49 points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met. |
|||
Poor Quality 0-45% |
37-1 points The background and/or significance are missing. No search history information is provided. |
75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration. |
48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met |
|||
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow
Broward Business Question Essay Paper |
Broward Business Question Essay Paper