Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions