Answered step by step
Verified Expert Solution
Question
1 Approved Answer
full details of all parts in Rational Algebra and b. Tuple calculus (2 points) Get the total number of projects supplied by supplier S1
full details of all parts in Rational Algebra and b. Tuple calculus (2 points) Get the total number of projects supplied by supplier S1 using SQL Supply SH $1 $2 $3 $4 $5 casos co Part PH Pl P2 P3 P4 P5 P6 Project J# J1 EPRESSE J2 J3 J4 35 J6 J7 SSSSSSS SPJ $1 $1 $2 $2 $2 $2 $2 $2 $3 $4 ko|co|9 Hall $5 $5 SNAME SMITH JONES BLAKE CLARK ADAMS PNAME NUT BOLT SCREW SCREW CAM COG PH PI P1 P3 P3 P3 P3 P3 P3 P3 P6 Teile 2012 P2 P6 JNAME SORTER PUNCH READER CONSOLE STATUS 20 10 COLLATOR TERMINAL TAPE 222 30 COLOR RED GREEN BLUE RED BLUE RED 20 30 J# J1 J4 JI 32 J3 J4 J5 J6 J1 J3 J4 FIG J4 WEIGHT 12 999399 17 17 14 12 19 CITY LONDON PARIS PARIS LONDON ATHENS CITY PARIS ROME ATHENS ATHENS LONDON OSLO LONDON CITY LONDON PARIS ROME 700 400 200 200 500 600 400 200 500 500 800 LONDON PARIS LONDON QTY 200
Step by Step Solution
There are 3 Steps involved in it
Step: 1
create table SUPPLIERS with below attributes respective data types primary key create table SUPPLIERS snum char2 primary key sname varchar10 status int city varchar10 create table PARTS with below att...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