Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help me with this database task data_2023_01_17.txt you can acces in link below https://drive.google.com/file/d/1qq93GODWntIJH88UBGUTpoYHZ4BD7SrA/view?usp=sharing Tasks 1. Find in the database data_2023_01_17.txt: (3 points) the pair
help me with this database task
data_2023_01_17.txt you can acces in link below
https://drive.google.com/file/d/1qq93GODWntIJH88UBGUTpoYHZ4BD7SrA/view?usp=sharing
Tasks 1. Find in the database data_2023_01_17.txt: (3 points) the pair of products that generated the most revenue. The solution is a view called sell. 2. Your data is in the salesman table. (3 points) The table is in relation to the product table. Who sold the same products with you? The solution is a view called sellers 3. Create a table as shown in the picture and write a procedure to add unique data to the tables. If the added data exists in the table, the procedure should return the id of this data, if this data is missing, it should add the data and also return the id. ( 3 points)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started