Question: Please Proof these three SQL problems. I gave my best attempt--My sql code is listed in each problem. Update discount of all products whose category

Please Proof these three SQL problems. I gave my best attempt--My sql code is listed in each problem.  Please Proof these three SQL problems. I gave my best attempt--My
sql code is listed in each problem. Update discount of all products
whose category is 'Sports' to 25 percent. Write your query here Database

Update discount of all products whose category is 'Sports' to 25 percent. Write your query here Database structure 1 UPDATE Sports SET Pdesc - NULL WHERE PRODID 183 Salesman (Sid, Sname. Location) Product (Prodid. Pdesc Price Category, Discount) Sale (Saleld. Sid. Sldate, Amount) Saledetail (Saleld, Prodid, Quantity) Verify Submit Query Result Expected Result ORA 00920: Invalid relational operator PRODID PDESC PRICE CATEGORY DISCOUNT 101 Basketball 10 Sports 25 102 Shirt 20 Apparel 10 103 NULL 30 Electronics 15 104 Cricket Bat 20 Sports 105 Trouser 10 Apparel 5 106 Television 40 ELECTRONICS20 Type here to search i e Create Match table as per details below. A player cannot play against himself, so player 1 should not be equal to player2. Column Name Data Type Constraint Description Mid INTEGER Unique Match id for a tournament PRIMARY KEY Tid Id INTEGER FOREIGN KEY Existing tournament tournament table present in Player 1 INTEGER FOREIGN KEY Existing player Id present in player table Player should not be equal to Player2 Player2 INTEGER FOREIGN KEY Existing player Id present in player table Matcht DATE NOT NULL Match Date Winner INTEGER FOREIGN KEY Existing player Id present in Player table Score VARCHAR2(30) NOT NULL Match Score Write your query here 1 CREATE TABLE Match 2 MIG INTEGER PRIMARY KEY, 3 TID INTEGER REFERENCES Tournament (Tournamentid), Playeri INTEGER REFERENCES Player(PlayerId), Player2 INTEGER REFERENCES Player(PlayerId), MatchDt DATE NOT NULL, 7 Winner INTEGER REFERENCES Player(PlayerId), 4 5 Score VARCHAR2 (30) NOT NULL, 9 CONSTRAINT playler_id_ck CHECK (Player1 Player2) 10) Verify Submit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!