Tasks

$$ Find $*$ in the database exam$\_$data$\_2023\_05\_29.$txt: $,(3$ points$)$

the pair of products that generated the most revenue in the second quarter $2021.$ The solution is $a-$

view called'sell.

It$-$should$-$look'likef$|$

Check if your data is in the seller table.

The table $-$ is in relation to the product $*$ table. $$

Who'sold the same products'$($at$-$least'one product$)$ with'You'in'your birthday month $($year$\text{'}2021$ and$-$

$?$

The solution is a view 'called'sellers. $\{$

$$ Create a tables $\text{'}$as shown'in the picture and use $($write$)$ triggers for updates and for inserting data in $-$

tables:

bank account $2/******$ Object: Table $[$dbo$].[$order$]$ Script Date: $14\mathrm{.}01\mathrm{.}202417$:$47$:$55******/$

SET ANSI$\_$NULLS ON

GO

SET QUOTED$\_$IDENTIFIER ON

GO

CREATE TABLE $[$dbo$].[$order$]($

$[$id$\_$order$][$int$]$ IDENTITY$(1,1)$ NOT NULL,

$[$id$\_$product$][$int$]$ NULL,

$[$order$][$varchar$](50)$ NULL,

$[$order$\_$date$][$date$]$ NULL,

CONSTRAINT $[$PK$\_$order$]$ PRIMARY KEY CLUSTERED

$($

$[$id$\_$order$]$ ASC

$)$WITH $($PAD$\_$INDEX $=$ OFF, STATISTICS$\_$NORECOMPUTE $=$ OFF, IGNORE$\_$DUP$\_$KEY $=$ OFF, ALLOW$\_$ROW$\_$LOCKS $=$ ON$,$ ALLOW$\_$PAGE$\_$LOCKS $=$ ON$,$ OPTIMIZE$\_$FOR$\_$SEQUENTIAL$\_$KEY $=$ OFF$)$ ON $[$PRIMARY$]$

$)$ ON $[$PRIMARY$]$

GO

$/******$ Object: Table $[$dbo$].[$product$]$ Script Date: $14\mathrm{.}01\mathrm{.}202417$:$47$:$55******/$

SET ANSI$\_$NULLS ON

GO

SET QUOTED$\_$IDENTIFIER ON

GO

CREATE TABLE $[$dbo$].[$product$]($

$[$id$\_$product$][$int$]$ IDENTITY$(1,1)$ NOT NULL,

$[$product$][$varchar$](50)$ NULL,

$[$price$][$float$]$ NULL,

CONSTRAINT $[$PK$\_$product$]$ PRIMARY KEY CLUSTERED

$($

$[$id$\_$product$]$ ASC

$)$WITH $($PAD$\_$INDEX $=$ OFF, STATISTICS$\_$NORECOMPUTE $=$ OFF, IGNORE$\_$DUP$\_$KEY $=$ OFF, ALLOW$\_$ROW$\_$LOCKS $=$ ON$,$ ALLOW$\_$PAGE$\_$LOCKS $=$ ON$,$ OPTIMIZE$\_$FOR$\_$SEQUENTIAL$\_$KEY $=$ OFF$)$ ON $[$PRIMARY$]$

$)$ ON $[$PRIMARY$]$

GO

$/******$ Object: Table $[$dbo$].[$product$\_$salesman$]$ Script Date: $14\mathrm{.}01\mathrm{.}202417$:$47$:$55******/$

SET ANSI$\_$NULLS ON

GO

SET QUOTED$\_$IDENTIFIER ON

GO

CREATE TABLE $[$dbo$].[$product$\_$salesman$]($

$[$id$\_$product$\_$salesman$][$int$]$ IDENTITY$(1,1)$ NOT NULL,

$[$id$\_$salesman$][$int$]$ NULL,

$[$id$\_$product$][$int$]$ NULL,

CONSTRAINT $[$PK$\_$product$\_$salesman$\_$new$]$ PRIMARY KEY CLUSTERED

$($

$[$id$\_$product$\_$salesman$]$ ASC

$)$WITH $($PAD$\_$INDEX $=$ OFF, STATISTICS$\_$NORECOMPUTE $=$ OFF, IGNORE$\_$DUP$\_$KEY $=$ OFF, ALLOW$\_$ROW$\_$LOCKS $=$ ON$,$ ALLOW$\_$PAGE$\_$LOCKS $=$ ON$,$ OPTIMIZE$\_$FOR$\_$SEQUENTIAL$\_$KEY $=$ OFF$)$ ON $[$PRIMARY$]$

$)$ ON $[$PRIMARY$]$

GO

$/******$ Object: Table $[$dbo$].[$salesman$]$ Script Date: $14\mathrm{.}01\mathrm{.}202417$:$47$:$55******/$

SET ANSI$\_$NULLS ON

GO

SET QUOTED$\_$IDENTIFIER ON

GO

CREATE TABLE $[$dbo$].[$salesman$]($

$[$id$\_$salesman$][$int$]$ IDENTITY$(1,1)$ NOT NULL,

$[$surname$][$nvarchar$](40)$ NULL,

$[$name$][$nvarchar$](40)$ NULL,

$[$name$2][$nvarchar$](40)$ NULL,

$[$id$][$nvarchar$](6)$ NULL,

CONSTRAINT $[$PK$\_$list$\_2024]$ PRIMARY KEY CLUSTERED

$($

$[$id$\_$salesman$]$ ASC

$)$WITH $($PAD$\_$INDEX $=$ OFF, STATISTICS$\_$NORECOMPUTE $=$ OFF, IGNORE$\_$DUP$\_$KEY $=$ OFF, ALLOW$\_$ROW$\_$LOCKS $=$ ON$,$ ALLOW$\_$PAGE$\_$LOCKS $=$ ON$,$ OPTIMIZE$\_$FOR$\_$SEQUENTIAL$\_$KEY $=$ OFF$)$ ON $[$PRIMARY$]$

$)$ ON $[$PRIMARY$]$

GO

SET IDENTITY$\_$INSERT $[$dbo$].[$order$]$ ON

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(2,30,$ N'SO$61269\text{'},$ CAST$($N$\text{'}2021-11-25\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(3,13,$ N'SO$61269\text{'},$ CAST$($N$\text{'}2021-12-15\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(4,5,$ N'SO$61270\text{'},$ CAST$($N$\text{'}2021-04-18\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(5,12,$ N'SO$61271\text{'},$ CAST$($N$\text{'}2021-10-22\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(6,21,$ N'SO$61271\text{'},$ CAST$($N$\text{'}2022-06-18\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(7,17,$ N'SO$61272\text{'},$ CAST$($N$\text{'}2021-02-25\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(8,21,$ N'SO$61272\text{'},$ CAST$($N$\text{'}2022-11-18\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(9,36,$ N'SO$61273\text{'},$ CAST$($N$\text{'}2021-08-17\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(10,4,$ N'SO$61274\text{'},$ CAST$($N$\text{'}2021-07-11\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(11,37,$ N'SO$61274\text{'},$ CAST$($N$\text{'}2021-12-07\text{'}$ AS Date$))$

INSERT $[$dbo$].[$order$]([$id$\_$order$],[$id$\_$product$],[$order$],[$order$\_$date$])$ VALUES $(12,30,$ N'SO$6127 There are 3 Steps involved in it Step: 1 Get Instant Access to Expert-Tailored 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 Recommended Textbook for Pro SQL Server Wait Statistics Authors: Enrico Van De Laar 1st Edition 1484211391, 9781484211397 More Books Students also viewed these Databases questions Question ★★★★★ In San Francisco, 30% of workers take public transportation daily (USA Today, December 21, 2005). a. In a sample of 10 workers, what is the probability that exactly three workers take public... Answered: 1 week ago Question ★★★★★ Using Short Sentences in Most Cases (LO6.1) Revise each of the following items to make the sentences shorter and more readable. A. General Mills is a dominant player in the American yogurt industry... Answered: 1 week ago Question ★★★★★ =+b) What are the advantages of this model compared to the previous model with four predictors? Answered: 1 week ago Question ★★★★★ The managing partner of a CPA firm is approached by the CEO of a major client in the firms headquarters office in New York City. The CEO cant use two tickets to the Super Bowl between the Denver... Answered: 1 week ago Question ★★★★★ Which of the following is deductible in calculating dividend received deduction modified taxable income? A) Charitable contribution deduction B) Net capital loss carrybacks C) Net operating loss... Answered: 1 week ago Question ★★★★★ 6. Solve again, with the same formula to measure speed of wave, except measure the length of the pulse itself with the ruler, and divide by the Pulse Width and enter the results in the data table... Answered: 1 week ago Question ★★★★★ A demand loan for $8,000 with interest at 16% compounded quarterly was repaid after two years and eight months. What was the amount of interest paid? Answered: 1 week ago Question ★★★★★ Period Product A Product B Product C Product D Product E 1 96 107 164 168 217 2 98 94 156 200 190 3 103 98 161 194 184 4 97 100 155 177 196 5 104 95 152 172 185 6 96 106 155 195 208 7 103 102 153 193... Answered: 1 week ago Question ★★★★★ Using IRAC (Issue, Rule of law, Analysis, and Conclusion). In the case of Horizon Mills Corp v QVC Inc., much turned on the question how consumers would interpret the term "Slinky." Do you think the... Answered: 1 week ago Question ★★★★★ (1 point) Hydrocodone is a commonly prescribed pain killer. Given an initial dosage P0 mg of hydrocodone, the amount of hydrocodone affecting a patient's nervous system If hours after taking the drug... Answered: 1 week ago Question ★★★★★ Provide a complete solution to each question. Explain your idea using proper terminology. A motorist drives along a highway at an average speed of 124 km/h. The speed limit is 100 km/h. (a) If the... Answered: 1 week ago Question ★★★★★ Explain the managers and the employees role in defining and designing work. Answered: 1 week ago Question ★★★★★ Describe the programs and services that promote overall health of employees. Answered: 1 week ago Question ★★★★★ Describe the uses of information gained from job analysis. Answered: 1 week ago Previous Question Next Question View Answer in SolutionInn App Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Secure Payment Download Our App © 2024 SolutionInn. All Rights Reserved $