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(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

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_2

Step: 3

blur-text-image_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

Principles Of Database Systems With Internet And Java Applications

Authors: Greg Riccardi

1st Edition

020161247X, 978-0201612479

More Books

Students also viewed these Databases questions

Question

4. What action should Cherita Howard take and why?

Answered: 1 week ago