Write a SQL query to find the second-highest salary from an Employee table without using LIMIT. Given a Sales table with Date, Product_ID, and Revenue, write a query to find the cumulative revenue per product over time. Design a normalized database schema for an e-commerce application handling customers, orders, and payments. Implement a stored procedure … Read more
Write a program to perform the following functionality. Part 1 Call a function to display the heading. Part 2 Write the following loop: Prompt the user for a limit. Call a function to play the game which will: Calculate a random number using the limit entered by the user. Display a message showing the range … Read more
5) Rank order all students by total credit (DESC) 6) Create a view tot_credits_dept (columns: year, dept_name, num_credits) with the total number of credits taken by all students in each year for courses offered by each department 7) Compute average number of credits over three preceding years per department using the view you created 8) … Read more
Homework Assignment #2 1. Please use SQLite3 and the financial data provided in class(sp500_mafa2024.db) to estimate the ROA, Profit Margin, Asset Turnover, PPE (property, plant and equipment) to Total assets, Debt to Total Assets ratios for the information technology industry, and the consumer staples industry respectively from 2012 to 2022. Furthermore, please provide histograms … Read more
1. Basic codes of Pythonin which average codes which includes if, elif, else, list(appending slicing, deleting ,inserting),dictionary(lengthfunc, clear, upadete etc),loop, while loop, 2. Basic codes of sql queries in which alter commands create table edit table(add row,delete row or column, change data type,describe structure..etc) Need to make 30 questions and answers using above codes. Need … Read more
Here is the Assignment Instruction: Follow all the tasks shown in the video clips in Ch 5 and do them yourself while watching the clips. At the end, turn in a file(s) that contains all the results that the author produces.
Extracting and interpreting data can be very valuable to an organization. · Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.
Using the University Database: 1) Rank order all students by total credit (DESC) 2) Create a view tot_credits_dept (columns: year, dept_name, num_credits) with the total number of credits taken by all students in each year for courses offered by each department 3) Compute average number of credits over three preceding years per department using the … Read more
Write a 3 page paper comparing SQL and NoSQL Database for Big Data. The paper should answer the following: 1. What are the SQL and NoSQL databases. 2. Use cases of SQL and NoSQL database. Differences of SQL and NoSQL databases. 3. Four types of NoSQL database. Give example of each database. Use case of … Read more
Preparation Read the assigned articles and watch the assigned videos. Tasks 1. Choose a topic on data management and data privacy that has an ethical dilemma (a non-comprehensive list has been provided below). Take a position in favor or against the topic/company you chose. Provide both quantitative and qualitative information to support your position. 2. … Read more