Question: 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)

 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),

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(idTeam) 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), RAMUA ITA 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)); e/ Give the idComp of the competitions in which member 'Ahmed Salim' participated. f/Give for each id the number of Competitions in which he participated. g Give for each idM the total score he got from all competitions in which he participated. Show only those who scored more than 1000. W Give for each team, the number of members who live in Muscat'. i/Give the idComp of the Competition which has the highest fee

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!