Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART III: SQL The Database of the VIDEO STORE has 4 tables (see attached code) CREATE TABLE Team idTeam varchar2(5) primary key, Name Team varchar2(30)

image text in transcribed
image text in transcribed
image text in transcribed
PART III: SQL The Database of the VIDEO STORE has 4 tables (see attached code) CREATE TABLE Team idTeam varchar2(5) primary key, Name Team varchar2(30) unique): CREATE TABLE Member idM Varchar2(5) primary key, FrameM varchar2(30), LnameM varchar2(30), CityM varchar2(30) Year Membership int(4). CONSTRAINT AKO FOREIGN KEY(id Team) REFERENCES Team (idTeam)); CREATE TABLE Competition idComp varchar2(5) primary key, TitleComp varchar2(30) unique, CompFees number(5)); CREATE TABLE Participation idM varchar2(5), idComp varchar2(5), MI UR Score number(3), CONSTRAINT pk1 PRIMARY KEY(idM, idComp). CONSTRAINT fkl FOREIGN KEY(idM) REFERENCES Member (idM), CONSTRAINT fk2 FOREIGN KEY(idComp) REFERENCES Competition (idComp)); j/ Delete from the database all members who live in Sur'. k/ As the government has imposed new taxes, we want to increase by 5% all CompFees. V Give the list of teams which have no members m/ Give all id and their team names, including those who have no team. n/ We frequently query the database for the details of a certain member by executing "select * from members where lidM=5* for example. Suppose we have a huge number of Members in the database and thus we would like to improve the performance of this sql query. Write a SQL statement for that

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Database And Transaction Processing

Authors: Philip M. Lewis, Arthur Bernstein, Michael Kifer

1st Edition

0201708728, 978-0201708721

More Books

Students also viewed these Databases questions